IS MISSING and IS NOT MISSING Operators in SAS Programming
-
IS MISSING Operator: Selecting Missing Values
Task 1: Suppose you want to select only those observations in which students did not fill their section information.
data readin;inputname$Section$ Score;cards;Raj A 80Atul . 77Priya B 45Sandeep A 95Rahul . 84Shreya . 44;run;data readin1;setreadin;whereSectionismissing;run;chevron_rightfilter_noneOutput:
Where Section is missing => This would tell SAS to select missing values for variable SECTION.
-
IS NOT MISSING Operator: Selecting Non-Missing Values
Task 2: Suppose you want to select only those observations in which students filled their section information.
data readin;inputname$Section$ Score;cards;Raj A 80Atul . 77Priya B 45Sandeep A 95Rahul . 84Shreya C 44;run;data readin1;setreadin;whereSectionisnotmissing;run;chevron_rightfilter_noneOutput:
Where Section is not missing => This would tell SAS to select non-missing values.
The NOT operator can be used with WHERE statement in many other ways:
-
where the section is not missing and the score is missing;
-
where not (score in (34, 44, 84));
-
where not (Score between 50 and 90);
-
where NOT(Section EQ “A”);
-
