LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Specifies a data type to use instead of the default data source
data type when SAS creates a data source table.
Valid in: |
DATA and PROC steps
|
Default value: |
none
|
DBTYPE=(<column-name-1>=<data-source-type>...
<column-name-1>=<data-source-type>)
|
- column-name
-
specifies a data source column name.
- data-source-type
-
specifies a data source data type. See the documentation
for your SAS/ACCESS interface for the
default data types for your data source.
By default, SAS/ACCESS converts
each SAS data type to a predetermined data source data type when outputting
data to your data source. When you need a different data type, use DBTYPE=
to override the default data type chosen by the SAS/ACCESS engine.
DBTYPE= specifies the data types that are used when you create columns
in the table.
DATA mydblib.newdept(dbtype=(deptno='double' city='char(25)'));
SET mydblib.dept;
RUN;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.