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

Details

Examples

Example 1: Specify a Single Quotation Mark

Example 2: Specify a Double Quotation Mark

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