DBLABEL= Data Set Option
Specifies whether to use SAS column labels or SAS
column names as the DBMS column names during output processing.
| Valid in: |
DATA and PROC steps |
| Default: |
NO |
| Supports: |
All |
Syntax
Syntax Description
- YES
-
specifies that SAS
column labels are used as DBMS
column names during output processing.
- NO
-
specifies that SAS
column names are used as DBMS
column names.
Details
This option is valid
only for creating DBMS tables.
Example: Specify a Variable Label
In the following example,
a SAS data set, NEW, is created with one column C1. This column 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;