Data Set Options for Relational Databases

NULLCHARVAL= Data Set Option

Defines the character string that replaces missing SAS character values during insert, update, DBINDEX=, and DBKEY= processing.

Default value:	a blank character
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Aster nCluster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Greenplum, HP Neoview, Informix, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata

Syntax

NULLCHARVAL='character-string'

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

This option works with the NULLCHAR= option to determine whether a missing SAS character value is treated as a NULL value.

If NULLCHARVAL= is longer than the maximum column width, one of these things happens: