Data Set Options for Relational Databases |
Specifies
whether to use SAS variable labels or SAS variable names
as the DBMS column names during output processing.
Default value: |
NO
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Aster nCluster, DB2 under
UNIX and PC Hosts, DB2 under z/OS,
Greenplum, HP Neoview, Informix, Microsoft SQL Server, MySQL, Netezza, ODBC,
OLE DB, Oracle, Sybase, Sybase IQ, Teradata
|
-
YES
-
specifies that SAS variable labels are used as DBMS column names during output
processing.
-
NO
-
specifies that SAS variable names are used as DBMS column names.
This option is valid only for creating
DBMS tables.
In this example, a 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 DBMS
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 © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.