NULLCHAR

Indicates how SAS character missing values are handled during insert, update, and DBKEY= processing.

Valid in:	DATA and PROC steps
Default:	SAS

Syntax

NULLCHAR= YES | NO

YES: indicates that character missing values in SAS data sets are treated as NULL values if the data source allows them. Otherwise, an error is returned.

NO: indicates that character missing values in SAS data sets are treated as the NULLCHARVAL= value, regardless of whether the data source allows NULLs for the column.

This option affects insert and update processing and also applies when you use the DBKEY= option.

in conjunction with the NULLCHARVAL= data set option, NULLCHARVAL= determines what is inserted when NULL values are not allowed.

All SAS numeric missing values (represented in SAS as .) are treated by the data source as NULLs.