LIBNAME Statement: PC Files on Microsoft Windows |
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
|
-
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.
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.
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;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.