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
Details
Example

Syntax

DBLABEL= YES | NO

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: Specifying 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;
Copyright © SAS Institute Inc. All Rights Reserved.