LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

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

Syntax
Syntax Description
Details
Example

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 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.

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;

Top of Page