DBTYPE=

DBTYPE=

Specifies data types(s) to override the default ODBC data type(s) when SAS outputs data to DBMS tables through ODBC.

Default value: The default type for SAS character variables is SQL_VARCHAR(size) which corresponds to the DBMS data type for variable length character data. Size is derived from the length of the SAS variable. The default for SAS numeric variables is SQL_DOUBLE, which corresponds to the DBMS data type for a double numeric value.

Syntax
Details

Syntax

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

Details

For a full description of this option, refer to DBTYPE= .

Chapter Contents
Previous
Next
Top of Page