topic Re: Deleting Missing Observations in New SAS User

Deleting Missing Observations

karaheller20 — Mon, 09 Sep 2019 13:43:38 GMT

I am looking for an impressive way to delete the missing observations in my variable ev_count. I know I could just list the options 0,1,2,3 and = them to themselves and then put other delete. But I have to submit my code with my project and cannot find a better more time efficient way to just delete the whole row when ev_Count is missing.

Re: Deleting Missing Observations

novinosrin — Mon, 09 Sep 2019 13:46:55 GMT

Are you meaning

if missing(ev_count) then delete;

Re: Deleting Missing Observations

PaigeMiller — Mon, 09 Sep 2019 13:47:35 GMT

data want;
   set have;
   if missing(ev_count) then delete;
run;

Re: Deleting Missing Observations

PeterClemmensen — Mon, 09 Sep 2019 13:48:52 GMT

So you simply want to delete observations whare the variable ev_count is missing?

data have;
input ev_count;
datalines;
1
.
2
.
;

data want;
    set have;
    if not missing(ev_count);
run;