DBTYPE=

DBTYPE=

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

Default value: DBTYPE_STR(size) or DBTYPE_R8

Option type: Data set only

Syntax
Details

Syntax

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

Details

The default type for SAS character variables is DBTYPE_STR(size), where the size is derived from the length of the SAS variable length. The default for SAS numeric variables is DBTYPE_R8 unless you specify a format such as m.n, in which case the type becomes DBTYPE_NUMERIC. For more information on SAS and OLE DB types, see OLE DB Data Types. To see a full description of this data set option, refer to DBTYPE= .

Chapter Contents
Previous
Next
Top of Page

Default value:	DBTYPE_STR(size) or DBTYPE_R8
Option type:	Data set only