DBSASLABEL= LIBNAME Statement Option
Specifies how the table driver returns column labels.
| Valid in: |
LIBNAME statement |
| Default: |
COMPAT |
| Supports: |
All |
Syntax
Syntax Description
- COMPAT
-
specifies to return
the column label to the application. For data sources that support
storing column labels on the table (for example, SAS data sets), the
engine returns the label to the application. If there is no label
stored, no label is returned. For data sources that do not store column
labels on the table, the engine returns the column name as the label.
- NONE
-
specifies that column
labels are not returned even if one exists. The engine returns blanks
for the column labels.
Example: Return Blank Labels for Aliases in Headings
The following example
demonstrates how DBSASLABEL= is used as a LIBNAME option to return
blank column labels so that PROC SQL can use the column aliases as
the column headings.
libname mydblib fedsvr server="d1234.us.company.com"
port=2171 user=user1 pwd=pass1
dsn=basedsn dbsaslabel=none;
proc sql;
select deptno as Department ID, loc as Location
from mydblib.dept;Without the DBSASLABEL=
option set to NONE, the aliases would be ignored, and DEPTNO and LOC
would be used as column headings in the result set.
See Also
To apply this
option to an individual table, use the DBSASLABEL= data set option.