DBTYPE=

DBTYPE=

Specifies a data type to use instead of the default DBMS data type when SAS creates a DBMS table.

Default value: DBMS specific

See Also: DBFORCE=

Syntax
Details

Syntax

DBTYPE=(<column-name-1=<'>DBMS type<'>> <...<column-name-n=<'DBMS-type<'>>>)

column-name: specifies a DBMS column name.
DBMS-type: specifies a DBMS data type.

Details

This option is valid only for creating DBMS tables.

By default, the SAS/ACCESS engine for your DBMS converts each SAS data type to a predetermined DBMS data type when outputting data to your DBMS. When you need a different data type, you can use DBTYPE= to override the default data type chosen by the SAS/ACCESS engine.

In the following example, DBTYPE= specifies the data types that are used when creating columns in the DBMS table.

data mydblib.newdept(dbtype=(deptno=
         'number(10,2)' city='char(25)'));
   set mydblib.dept;
run;

See your DBMS chapter for more details on the default data types for your DBMS.

Chapter Contents
Previous
Next
Top of Page