The LIBNAME Statement for Relational Databases

QUOTE_CHAR= LIBNAME Option

Specifies which quotation mark character to use when delimiting identifiers.

Default value:	none
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Aster nCluster, Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Sybase IQ

Syntax
Syntax Description
Details
Examples

Syntax

QUOTE_CHAR=character

Syntax Description

character: is 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 allows for this character and what the DBMS allows, the QUOTE_CHAR= option overrides the character returned by the provider.

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

If you would like your quotation character to be a single quotation mark, then specify the following:

libname x odbc dsn=mydsn pwd=mypassword quote_char="'";

If you would like your quotation character to be a double quotation mark, then specify the following:

libname x odbc dsn=mydsn pwd=mypassword quote_char='"';

Top of Page