BL_FORCE_NOT_NULL= Data Set Option

Specifies how to process CSV column values.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: NO
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: Aster nCluster, Greenplum
See: BL_DELIMITER= data set option, BL_FORMAT= data set option, BL_NULL= data set option, BL_QUOTE=set option, BULKLOAD= data set option
Syntax
Details

Syntax

BL_FORCE_NOT_NULL=YES | NO

Syntax Description

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

Details

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