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

Syntax Description

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.

Details

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.

See Also