topic Re: Why does is missing never work? in SAS Programming

Why does is missing never work?

primukh26 — Sun, 28 Jul 2019 14:12:07 GMT

I have always received an error when I use "Is Missing". For example in the code below:

data work.lowchol work.highchol work.misschol;
set sashelp.heart;
if cholesterol is missing then output work.misschol;
else if cholesterol lt 200 then output work.lowchol;
else if cholesterol ge 200 then output work.highchol;
run;

Error Message:

28 if cholesterol is missing then output work.misschol;
__
388
76
ERROR 388-185: Expecting an arithmetic operator.

ERROR 76-322: Syntax error, statement will be ignored.

Can anyone let me know why this happens? or if i am making a mistake here?

Re: Why does is missing never work?

KachiM — Sun, 28 Jul 2019 14:23:19 GMT

if cholesterol is missing then output work.misschol;

Use MISSING as a function like:

if missing(cholesterol) then output work.misschol;

Re: Why does is missing never work?

primukh26 — Sun, 28 Jul 2019 14:30:38 GMT

Thank you this removed all errors from the code.

data work.lowchol work.highchol work.misschol;
set sashelp.heart;
if missing(cholesterol) then output work.misschol;
else if cholesterol lt 200 then output work.lowchol;
else if cholesterol ge 200 then output work.highchol;
run;

Re: Why does is missing never work?

novinosrin — Sun, 28 Jul 2019 15:01:21 GMT

Hello @primukh26

You could use WHERE to make "is missing" work like->

/*Create sample input data*/
data have;
do i=1 to 5;
do cholesterol =.,0 to 300;
output;
end;
end;
run;

/*Test where cholesterol is missing*/
data work.lowchol(where=(0<=cholesterol<= 200)) 
work.highchol(where=(cholesterol gt 200)) 
work.misschol(where=(cholesterol is missing));
set have;
run;

Re: Why does is missing never work?

Tom — Sun, 28 Jul 2019 15:03:27 GMT

IS MISSING has no special meaning to SAS data step code. So the error message is telling you that you did not include any operator between the variable CHOLESTEROL and the variable IS.

You can compare variables to the missing value which is represented by a period for numeric variables or a blank for character variables.

if cholesterol = . then output work.misschol;
else if cholesterol lt 200 then output work.lowchol;
else if cholesterol ge 200 then output work.highchol;

Note that SAS also has 27 other "special" missing numeric values which are represented by ._ and .A to .Z which are distinct and different than regular missing value. So it could be safer to use the MISSING() function to test if a variable is missing or not. The MISSING() function works for both numeric and character variables.