TYPE

TYPE

Changes default DBMS data types in the new table.

Optional statement

Syntax
Details

Syntax

TYPE variable-identifier-1 = 'column-type-1'
<...variable-identifier-n = 'column-type-n'>;

Details

The TYPE statement changes the default DBMS column data types that are associated with the corresponding SAS variables.

The variable-identifier argument can be either the SAS variable name or the positional equivalent from the LIST statement. The positional equivalent is the number that represents the variable's place in the data set. For example, if you want to change the data type of the DBMS column associated with the third SAS variable, submit the following statement:

type 3='char(17)';

The argument column-type must be a valid data type for the DBMS and must be enclosed in quotes.

If you omit the TYPE statement, the column data types are generated with default DBMS data types that are based on the SAS variable formats. You can change as many data types as you want in one TYPE statement. See your DBMS chapter for a complete list of the default conversion data types for the DBLOAD procedure.

An editing statement, such as TYPE, must be specified after the database connection statements when you create and load a DBMS table. See LOAD for more information.

Chapter Contents
Previous
Next
Top of Page