Data Set Options for Relational Databases |
Specifies how the engine returns column labels.
Default value: |
COMPAT
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
DB2 under UNIX and PC Hosts, DB2 under z/OS,
HP Neoview, Informix, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB,
Oracle, Sybase, Teradata
|
-
COMPAT
-
specifies that the labels returned should
be compatible with what the application normally receives. In other words,
engines exhibit their normal behavior.
-
NONE
-
specifies that the engine does not return
a column label. The engine returns blanks for the column labels.
By default, the SAS/ACCESS interface
for your DBMS generates column labels from column names instead of from the
real column labels.
You can use this option to override the default behavior.
It is useful for when PROC SQL uses column labels as headings instead of column
aliases.
This example demonstrates how you can use DBSASLABEL=
to return blank column labels so that PROC SQL can use the column aliases
as the column headings.
proc sql;
select deptno as Department ID, loc as Location
from mylib.dept(dbsaslabel=none);
When DBSASLABEL=NONE, PROC SQL ignores the aliases,
and it uses DEPTNO and LOC as column headings in the result set.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.