QUOTE_CHAR= LIBNAME Option

Specifies which quotation mark character to use when delimiting identifiers.
Valid in: SAS/ACCESS LIBNAME statement
Default: none
Data source: Aster nCluster, Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Sybase IQ

Syntax

QUOTE_CHAR=character

Syntax Description

character
the quotation mark character to use when delimiting identifiers, such as the double quotation mark (").

Details

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 Sybase, 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 Sybase).

Examples

Example 1: Specify a Single Quotation Mark

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="'";

Example 2: Specify a Double Quotation Mark

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='"';