LIBNAME Statement: PC Files on Microsoft Windows

NULLCHAR

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

Valid in:	DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default value:	YES

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 NULLCHARVAL values (regardless of whether the data source allows NULLs for the column).

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

This option works in conjunction with the NULLCHARVAL data set option, which 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.