DBSASLABEL= LIBNAME Statement Option

Specifies how the table driver returns column labels.

Valid in: LIBNAME statement
Default: COMPAT
Supports: All

Syntax

DBSASLABEL= COMPAT | NONE

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: Returning 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.