LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Specifies whether to use SAS variable labels as data source column
names during output processing.
Valid in: |
DATA and PROC steps
|
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 a
Microsoft
Access or a Microsoft Excel file. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
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;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.