• Print |
• E-mail  |
• Bookmark

The WHERE statement returns incorrect results when the WHERE clause
contains overlapping ranges.  An overlapping range is when the WHERE
clause has multiple AND'd or OR'd conditions which an observation can
meet.  For example, the following DATA step:

  DATA CLASS;
    SET SASHELP.CLASS;
    WHERE ((AGE GE 11 AND AGE LE 12) OR
           (AGE GE 15 AND AGE LE 16)) AND
           (AGE GT 0) AND
           (AGE LT 100);
  RUN;

returns the incorrect number of observations.

To prevent the problem, change the last AND'd condition to:

   ...and age le 100;

or use a subsetting IF statement in place of the WHERE.


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

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#013577

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

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#013577


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013577

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

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013577

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:

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :