DBLABEL

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

Valid in:	DATA and PROC steps
Default:	NO

Syntax

Details

Example

Syntax

DBLABEL=YES | NO

Syntax Description

YES: specifies that SAS variable labels are used as data source column names during output processing.

NO: specifies that SAS variable names are used as data source column names.

Details

This option is valid only for creating data source tables.

Note: Only up to 64 characters of SAS variable labels are written to a Microsoft Access or a Microsoft Excel file.

Example: Specify Label Use

In this example, the 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 data source column name. When DBLABEL=YES, you can use the label 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;