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).