DBLABEL=

DBLABEL=

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

Default value: NO

Syntax
Details

Syntax

DBLABEL=YES | NO

YES: uses SAS variable labels as DBMS column names.
NO: uses SAS variable names as DBMS column names.

Details

This option is valid only for creating DBMS tables.

In the following 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;

Chapter Contents
Previous
Next
Top of Page