Previous Page | Next Page

Data Set Options for Relational Databases

BL_NULL= Data Set Option



Specifies the string that represents a null value.
Default value: '\N' [TEXT mode], unquoted empty value [CSV mode]
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Greenplum

Syntax
Details
See Also

Syntax

BL_NULL='\N' | empty-value

Details

To specify this option, you must first set BULKLOAD=YES.

You might prefer an empty string even in TEXT mode for cases where you do not want to distinguish nulls from empty strings. When you use this option with external and Web tables, any data item that matches this string is considered a null value.


See Also

BL_DELIMITER= Data Set Option

BL_FORCE_NOT_NULL= Data Set Option

BL_FORMAT= Data Set Option

BL_QUOTE= Data Set Option

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page