The LIBNAME Statement for Relational Databases

ESCAPE_BACKSLASH= LIBNAME Option

Specifies whether backslashes in literals are preserved during data copy from a SAS data set to a table.

Default value:	NO
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	MySQL

Syntax
Syntax Description
Details
See Also

Syntax

ESCAPE_BACKSLASH=YES | NO

Syntax Description

YES: specifies that an additional backslash is inserted in every literal value that already contains a backslash.
NO: specifies that backslashes that exist in literal values are not preserved. An error results.

Details

MySQL uses the backslash as an escape character. When data that is copied from a SAS data set to a MySQL table contains backslashes in literal values, the MySQL interface can preserve these if ESCAPE_BACKSLASH=YES.