LIBNAME Statement: PC Files on 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 (when accessing PC files
data using SAS/ACCESS software)
|
Default value: |
none
|
DBTYPE=(<column-name-1>=<data-source-type>...<column-name-N>=<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.
In this example, 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.