DBSASLABEL= LIBNAME Option

Specifies the column labels an engine uses.

Valid in:	SAS/ACCESS LIBNAME statement
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
See:	DBSASLABEL= data set option

Syntax

Details

Example

Syntax

DBSASLABEL=COMPAT | NONE

Syntax Description

COMPAT: specifies that the labels returned should be compatible with what the application normally receives—meaning that 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 the 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 headers instead of column aliases.

Example: Return Blank Labels for Aliases in Headings

This example shows how to use DBSASLABEL= as a LIBNAME option o return blank column labels so that PROC SQL can use the column aliases as the column headings.

libname x oracle user=scott pw=tiger;
proc sql;
     select deptno as Department ID, loc as Location 
            from mylib.dept(dbsaslabel=none);

Without DBSASLABEL=NONE, aliases are ignored, and DEPTNO and LOC are used as column headings in the result set.