BL_ESCAPE= Data Set Option

Specifies the single character to use for C escape sequences.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: \
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: Greenplum
See: BL_FAILED_DATA= data set option, BULKLOAD= data set option

Syntax

BL_ESCAPE='<any-single-character>'

Details

Use this option to specify the single character to use for C escape sequences. These can be \n, \t, or \100. It can also be for escape data characters that might otherwise be used as row or column delimiters. Be sure to choose one that is not used anywhere in your actual column data.
Although the default is \ (backslash), you can specify any other character. You can also specify OFF to disable the use of escape characters. This is very useful for Web log data that contains numerous embedded backslashes that are not intended as escape characters.