When optimization is done for a user-defined format so that it can be processed by the database management system (DBMS), incorrect code might be passed to the DBMS. Incorrect results might occur when the following is true about the query:

• A DBMS engine is used to reference a DBMS table
• A PUT function referencing a numeric user-defined format is used in a SELECT, WHERE, GROUP BY, or HAVING clause
• Any of the numeric values that are part of the format are greater than 12 digits in length
• SAS and user-defined formats have not been published to the database

When SAS^® tries to optimize the performance of the query by passing the format to the database, it uses a BEST12. format to format the value in the format rather than the actual value. Consequently, a number like 1234567890123 is passed as 1234567900000.

To work around this issue, turn off optimization of the PUT function by setting the system option SQLREDUCEPUT=NONE.

Operating System and Release Information

A fix for this issue for Base SAS 9.4_M3 is available at: