Previous Page | Next Page

LIBNAME Statement: PC Files on Microsoft Windows

DBLABEL



Specifies whether to use SAS variable labels as data source column names during output processing.
Valid in: DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
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.

No more than 64 characters of SAS variable labels are written to Microsoft Access or Microsoft Excel files.


Example

In this example, the SAS data set New is created with one variable C1. It 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. By setting DBLABEL=YES, the label is 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;

Previous Page | Next Page | Top of Page