Using the DBSASTYPE= data set option, you can change the DBMS definition of the data type of a column when it comes into SAS. This use of DBSASTYPE= is often employed when the column in the DBMS is an integer that is larger than the 15 significant digits that can be stored in SAS.

You can add the DBSASTYPE= option to a table when the table is being registered in SAS Management Console. However, if your query contains one or more of the following, the column might still come in as the data type defined in the DBMS table instead of the data type specified in the option:

• DISTINCT operator
• ORDER BY clause
• SUMMARY function
• GROUP BY clause
• Join

There is no workaround for this issue.