BL_NULL= Data Set Option

Specifies the string that represents a null value.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: '\N' [TEXT mode], unquoted empty value [CSV mode]
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: Greenplum
See: BL_DELIMITER= data set option, BL_FORCE_NOT_NULL= data set option, BL_FORMAT= set option, BL_QUOTE= data set option, BULKLOAD= data set option
Syntax
Details

Syntax

BL_NULL='\N' | empty-value

Details

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.
Copyright © SAS Institute Inc. All rights reserved.