NULLCHARVAL= Data Set Option

Defines the character string that replaces missing SAS character values during insert, update, DBINDEX=, and DBKEY= processing.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: a blank character
Data source: 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
See: DBFORCE= data set option, DBINDEX= data set option, DBKEY= data set option, DBNULL= data set option, NULLCHAR= data set option

Syntax

NULLCHARVAL='character-string'

Details

This option affects insert and update processing and also applies when you use the DBINDEX= and DBKEY= data set options.
It also 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:
  • The string is truncated if DBFORCE=YES.
  • The operation fails if DBFORCE=NO.