• Print |
• E-mail  |
• Bookmark

Using a compound WHERE clause that contains the NOT IN operator on the
key sort variable on a sorted SAS data set returns an incorrect number
of observations.  An example

  data two;
    set one;
    where y > 2 and x not in(0,1);
  run;

where data set ONE is sorted by variable X returns an incorrect number
of observations.

The circumvention is to either use the compound WHERE clause against a
unsorted SAS data set or use an IF statement in place of the WHERE.

Operating System and Release Information