In the third maintenance release for SAS^® 9.4 (TS1M3), a query might take much longer to run than in earlier releases of SAS. This performance issue occurs when you use the SQL procedure to join a SAS table and a database management system (DBMS) table and you use a CALCULATED column in the WHERE clause.

In addition to experiencing longer elapsed times for a query to execute, a large amount of disk space might be used as well.

These problems occur when you submit code similar to the following example:

For this example, it is expected that the WHERE t1.WhereVar='A' clause would be passed to the database. Setting the following options show that the WHERE clause is not passed to the database. You would expect to pass the WHERE t1.WhereVar='A' statement.

To work around this issue, replace the CALCULATED variable name with the expression from the SELECT clause. Using the previous code example, that replacement is as follows:

In this example, the calculated expression is not expected to be passed to the database.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

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

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