Data Set Options for Relational Databases

BL_FORCE_NOT_NULL= Data Set Option

Specifies how to process CSV column values.

Default value:	NO
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Aster nCluster, Greenplum

Syntax
Syntax Description
Details
See Also

Syntax

BL_FORCE_NOT_NULL=YES | NO

Syntax Description

YES: specifies that each specified column is processed as if it is enclosed in quotes and is therefore not a null value.
NO: specifies that each specified column is processed as if it is a null value.

Details

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

You can use this option only when BL_FORMAT=CSV. For the default null string, where no value exists between two delimiters, missing values are evaluated as zero-length strings.