topic Why the is missing operator is not working with if then statement? in SAS Data Science

Why the is missing operator is not working with if then statement?

devarayalu — Thu, 19 Jul 2012 11:19:41 GMT

data one;

infile datalines missover;

input age;

if age is missing then age=9999;

else age=age;

cards;

;

proc print;

run;

Quentin — Thu, 19 Jul 2012 12:18:03 GMT

Hi,

You probably want the missing FUNCTION. Try:

if missing(age) then age=9999;

Also I would suggest you use SAS special missing values instead of numeric codes. So:

if missing(age) then age=.S;

--Q.

cwilson — Thu, 19 Jul 2012 13:28:46 GMT

Also, the "is missing" syntax is used with the "where" clause, as in Proc SQL or as a filter on Proc freq, for example.

Proc freq data = . . . ;

where age is missing ;

tables . . . ;

In a DATA step, use:

if age = . then age = 9999 ;

(and you really don't need the else clause)

ballardw — Thu, 19 Jul 2012 15:22:32 GMT

if missing(age) then age=9999;