Specifies which quotation mark character to use when delimiting identifiers.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Data source: | Amazon Redshift, Aster, Greenplum, HAWQ, Impala, JDBC, Microsoft SQL Server, Netezza, ODBC, OLE DB, PostgreSQL, SAP HANA, SAP IQ, Vertica, Yellowbrick |
| Notes: | Support for JDBC was added for SAS Viya 3.5. |
| Support for Yellowbrick was added in SAS 9.4M7. |
Table of Contents
specifies the quotation mark character to use when delimiting identifiers, such as the double quotation mark (").
Enclose the character in single or double quotation marks, as appropriate. For more information, see the examples below.
The provider usually specifies the delimiting character. However, when there is a difference between what the provider and the DBMS allow for this character, the QUOTE_CHAR= option overrides the character that the provider returns.
Microsoft SQL Server: QUOTE_CHAR= overrides the Microsoft SQL Server default.
ODBC: This option is mainly for the ODBC interface to SAP ASE, and you should use it with the DBCONINIT and DBLIBINIT LIBNAME options. QUOTE_CHAR= overrides the ODBC default because some drivers return a blank for the identifier delimiter even though the DBMS uses a quotation mark (for example, ODBC to SAP ASE).
Here is what to specify if you want your quotation character to be a single quotation mark.
libname x odbc dsn=mydsn pwd=mypassword quote_char="'";Here is what to specify if you want your quotation character to be a double quotation mark.
libname x odbc dsn=mydsn pwd=mypassword quote_char='"';