Specifies how the table driver returns column labels.
| Valid in: | DATA and PROC steps |
| Default: | COMPAT |
| Supports: | All |
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.
specifies that a column label is not returned even if one exists. The engine returns blanks for the column labels.
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 (dbsaslabel=none);