| 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 © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
