DBTYPE

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: none

Syntax

DBTYPE=(<column-name-1> =<data-source-type> ...
<column-name-1> =<data-source-type> )

Syntax Description

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.

Details

By default, SAS/ACCESS converts each SAS data type to a predetermined data source data type when it writes 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.

Example: Specify the Data Type to Use

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;