Did You Know? » the difference between IS NULL and IS MISSING?

There is really no differences. SAS does not have a concept of null like databases do and therefore you can use either WHERE operator to specify the same thing.

For example: where race is null;

Anayansi Gamboa has an extensive background in clinical data management as well as experience with different EDC systems including Oracle InForm, InForm Architect, Central Designer, CIS, Clintrial, Medidata Rave, Central Coding, OpenClinica Open Source and Oracle Clinical.

Advertisements