DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
Default:
COMPAT
Data source:
Aster nCluster,
DB2 under UNIX and PC Hosts, DB2 under z/OS, Greenplum, HP Neoview,
Informix, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Oracle,
Sybase, Sybase IQ, Teradata
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.
Details
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.
Example: Return Blank Labels for Aliases in Headings
This example shows how
to 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.