NULLCHARVAL=

NULLCHARVAL=

Defines the character string to insert into a DBMS table when a character missing value is encountered in a SAS data set or PROC SQL INSERT statement.

Default value: a blank character

See Also: NULLCHAR=, DBFORCE=, DBNULL=

Syntax
Details

Syntax

NULLCHARVAL='character-string'

character-string: is a string of characters.

Details

The NULLCHARVAL= option works with the NULLCHAR= option and affects insert and update processing. The NULLCHAR= option determines whether or not a SAS character NULL value is inserted into the DBMS column as a NULL value. If a NULL is not inserted, the value of the NULLCHARVAL= option is inserted. If NULLCHARVAL= is not specified, a blank is inserted.

Note: If NULLCHARVAL= is longer than the maximum column width, one of the following occurs on insert:

The string is truncated if DBFORCE=YES.
The insert operation fails if DBFORCE=NO.

Chapter Contents
Previous
Next
Top of Page

Default value:	a blank character
See Also:	NULLCHAR=, DBFORCE=, DBNULL=