topic Re: Missing Percentage for each variable in SAS Programming

Missing Percentage for each variable

Ujjawal — Mon, 04 May 2015 14:10:35 GMT

I am trying to create a macro that drops all the variables having missing value % greater than 80. I have written a small code to get it started. But i am stuck how to take it forward.

data have;

set sashelp.class;

if _n_ in (5,10,12) then do;

call missing(height,weight);

end;

if _n_ in (7,9) then do;

call missing(age);

end;

run;

proc means data=have noprint;

var _numeric_;

output out=temp (drop=_type_) nmiss=;

run;

Re: Missing Percentage for each variable

Steelers_In_DC — Mon, 04 May 2015 14:30:50 GMT

I'm not sure if this is what you want, let me know:

data have;

set sashelp.class;

if _n_ in (5,10,12) then do;

call missing(height,weight);

end;

if _n_ in (7,9) then do;

call missing(age);

end;

run;

data want;

set have;

if missing(height) or missing(weight) then delete;

run;

Re: Missing Percentage for each variable

data_null__ — Mon, 04 May 2015 15:01:16 GMT

You want to know the names of the variables that have more than some percentage missing?

data have;
   set sashelp.class;
   if _n_ in (5 10 12) then do; 
      call missing(height,weight);
      end; 
   if _n_ in (7 9) then do; 
      call missing(age);
      end; 
   r = ranuni(1);
   run; 
ods output summary=nmiss; 
proc means data=have stackods nmiss n; 
   var _numeric_;
   run; 
ods output close; 
proc print data=nmiss;
   run; 

%let pmisslist=;
proc sql noprint; 
   select variable into :pmisslist separated by ' '
      from nmiss where nmiss/(sum(n,nmiss)) ge .15; 
   quit; 
   run; 
%put NOTE: &=PMISSLIST;      

Re: Missing Percentage for each variable

Ujjawal — Mon, 04 May 2015 17:32:45 GMT

How can i replicate the same for character variables? PROC MEANS does not work for character variables and PROC FREQ produces clumsy output. Thanks in anticipation!