• Print |
• E-mail  |
• Bookmark

The WHERE statement returns incorrect results when specifying a range and including additional conditions that fall outside of the range. For example:

   WHERE (a < 5 OR a > 10) AND a NE 8 AND a NE 9;

By modifying the WHERE clause to the following:

   WHERE (a < 5 OR a > 10) AND (a NE 8 OR a NE 9);

the WHERE condition returns the correct results.

A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this issue is available at:

For customers running SAS with Asian Language Support (DBCS), this hot fix should be downloaded from:

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at: