Data Set Options for Relational Databases |
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_FORCE_NOT_NULL= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.