If you use a WHERE clause that contains an OR condition and the first two arguments in the OR condition are identical, an incorrect number of observations might be returned.

The following code example illustrates the issue. After the code executes, zero observations occur, but the expectation is that one observation should be returned:

No notes, warnings, or errors are issued in the SAS^® log to indicate that an incorrect number of observations has been returned.

A workaround is to substitute an IF statement in place of the WHERE clause. Using an IF statement in the code example above returns the correct expected number of observations.

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_M5 is available at:

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: