When you subset a relational database management system (DBMS) table by a date variable, incorrect results might occur. The problem occurs when the following conditions are true:

• A date variable is compared to a SAS^® missing value.
• A date variable is compared to an internal SAS date value using a less-than or a less-than-or-equal-to comparison.

The following example code illustrates a WHERE statement that produces incorrect results:

There are two workarounds. One is to use the IS NULL operator rather than a SAS missing value, as shown below:

The second workaround is to use a SAS date constant, as shown below:

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: