Specifies how to process CSV column values.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | NO |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | Aster, Greenplum, HAWQ |
| See: | BL_DELIMITER= data set option, BL_FORMAT= data set option, BL_NULL= data set option, BL_QUOTE= data set option, BULKLOAD= data set option |
Table of Contents
specifies that each specified column is processed as if it is enclosed in quotation marks and is therefore not a null value.
specifies that each specified column is processed as if it is a null value.
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.