Data Set Options for Relational Databases

BL_ESCAPE= Data Set Option

Specifies the single character to use for C escape sequences.

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

Syntax
Details
See Also

Syntax

BL_ESCAPE='<any-single-character>'

Details

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

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.