LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

DBLABEL

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

Valid in:	DATA and PROC steps
Default value:	NO

Syntax
Syntax Description
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. [cautionend]

Example

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;

Top of Page