Data Set Options for Relational Databases

DBLABEL= Data Set Option

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

Default value:	NO
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	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
Syntax Description
Details
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.

Details

This option is valid only for creating DBMS tables.

Example

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. Setting DBLABEL=YES enables the label to 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;

Top of Page