Specifies the single character to use for C escape sequences.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | \ (backslash) |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Interaction: | PostgreSQL: This option only applies to CSV files. Therefore, you must also set BLFORMAT=CSV. |
| Data source: | Aster, Greenplum, HAWQ, PostgreSQL, Yellowbrick |
| Note: | Support for Yellowbrick was added in SAS 9.4M7. |
| See: | BL_FORMAT= data set option, BULKLOAD= data set option |
Use this option to specify the single character to use for character escape sequences. These can be \n, \t, or \001 (start of heading). 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.
For octal codes, specify a backslash followed by a three-digit code that represents your escape character, such as \041 (‘!’). Octal notation that uses a preceding ‘E’, such as E'\24', is not supported. Some common escape characters and their corresponding octal codes are listed in the following table.
|
Escape Character |
Octal Code |
|---|---|
|
(start of heading) |
\001 |
|
(device control 4) |
\024 |
|
! |
\041 |
|
/ |
\057 |
|
^ |
\136 |
|
~ |
\176 |