DBLABEL= Data Set Option

Specifies whether to use SAS variable labels or SAS variable names as the DBMS column names during output processing.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	NO
Restriction:	This option is valid only for creating DBMS tables.
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

Syntax

Example

Syntax

DBLABEL=YES | NO

Syntax Description

YES: specifies that SAS variable labels are used as DBMS column names during output processing.

NO: specifies that SAS variable names are used as DBMS column names.

Example: Specify a Variable Label

In this example, a SAS data set, NEW, is created with one variable C1. This variable is assigned a label of DEPTNUM. In the second DATA step, the MYDBLIB.MYDEPT table is created by using DEPTNUM as the DBMS column name. By setting DBLABEL=YES, the label can be used as the column name.

data new;
   label c1='deptnum';
   c1=001;
run;
data mydblib.mydept(dblabel=yes);
   set new;
run;
proc print data=mydblib.mydept;
run;