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
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;