The LIBNAME Statement for Relational Databases |
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
|
ESCAPE_BACKSLASH=YES | NO
|
- 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.
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.
To apply this option to an individual data set, see
the ESCAPE_BACKSLASH= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.