202 QUALIFIER= Data Set Option Chapter 10
Use the DQUOTE option in PROC SQL and then reference your columns using
double quotation marks. For example:
proc sql dquote=ansi;
select "Total$Cost" from mydblib.mytable;
Specify the global system option VALIDVARNAME=ANY and use name literals in
the SAS language. For example:
proc print data=mydblib.mytable;
format ’Total$Cost’n 22.2;
Note that if you are creating a table in PROC SQL, you must also include the
PRESERVE_COL_NAMES=YES option. For example:
libname mydblib oracle user=testuser password=testpass;
proc sql dquote=ansi;
create table mydblib.mytable (preserve_col_names=yes) ("my$column" int);
PRESERVE_COL_NAMES= does not apply to the Pass-Through Facility.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “PRESERVE_COL_NAMES= LIBNAME Option” on page 112
QUALIFIER= Data Set Option
Specifies the qualifier to use when you are reading database objects, such as DBMS tables and
views
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: ODBC, OLE DB, Microsoft SQL Server
Default value:
LIBNAME setting
Syntax
QUALIFIER=<qualifier-name>
Details
If this option is omitted, the default qualifier name, if any, is used for the data source.
QUALIFIER= can be used for any data source, such as a DBMS object, that allows
three-part identifier names: qualifier.schema.object.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “QUALIFIER= LIBNAME Option” on page 115.
