NULLCHAR= Data Set Option

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

Valid in:	DATA and PROC steps
Default:	SAS
Supports:	DB2 UNIX/PC, Greenplum, MySQL, ODBC, Oracle, Teradata

Syntax

NULLCHAR= SAS | YES | NO

SAS: indicates that missing character values are treated as NULL values if the DBMS allows NULLs. Otherwise, they are treated as the NULLCHARVAL= value.

YES: indicates that missing character values are treated as NULL values if the DBMS allows NULLs. Otherwise, an error is returned.

NO: indicates that missing character values are treated as the NULLCHARVAL= value (regardless of whether the DBMS allows NULLs for the column).

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

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

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