Incorrect results or a performance problem might occur when the following conditions are true:

• You are accessing at least one database management system (DBMS) table via a LIBNAME statement.
• Your SQL query contains a WHERE clause that is comparing a date variable using the BETWEEN operator.
• The date variable is being compared to an internal SAS^® value for a date variable (such as the number of days since 01JAN1960) instead of using a SAS date constant.
• Your SQL query triggers implicit pass-through.

Incorrect results occur when a DBMS allows the comparison of a date variable with a number, and the number is not interpreted as the intended date. 

Performance problems occur when a DBMS does not allow the comparison of a date variable and a number because the data types are not compatible. In this scenario, the query is partially processed by the DBMS and partially processed by SAS. This performance problem is especially apparent if the SQL query contains a join of two or more DBMS tables, because the join and the subsetting are done in SAS rather than in the DBMS.

The workaround is to use a SAS date constant instead of the number.

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: