04-25-2016 04:24 AM
IS it possible to combine the WHERE and NOT statement with operator IS NULL or IS MISSING?
IN Base 9.2, it isnt. But I did try it and it works. Please help me.
04-25-2016 05:27 AM
Yes, you can combine the NOT operator with the IS NULL or IS MISSING operator in a WHERE statement.
where not (x is null);
is valid. Even the notation
where x is not null;
works and it is mentioned in the section "Use of Indexes" of the WHERE statement documentation of both SAS 9.2 and 9.4 (see links above).