| The LIBNAME Statement for 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.
Note: Only up to 64 characters of
SAS variable labels are written to Microsoft Access or Microsoft Excel files. ![[cautionend]](../../../../common/61925/HTML/default/images/cautend.gif)
In the following 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. 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;
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
