|
June,
There is probably an easier way but, tonight, the best I could come up with
is shown below. I provided a three variable example, but it should work for
1200 variables as well (as long as they are all numeric variables).
Art
-----
data one;
input varone varetwo varthree;
cards;
1 1 1
2 . 2
3 . .
. . .
;
run;
proc summary data=one;
var _numeric_;
output out=two nmiss=;
run;
proc transpose data=two out=three;
run;
data four (drop=freq col1);
retain freq;
set three;
if _n_ gt 1;
if _n_=2 then freq=col1;
else do;
pct=col1/freq;
output;
end;
run;
--------
"June" <spairz@yahoo.com> wrote in message
news:339066a0.0405211321.28cf4e92@posting.google.com...
> Hi All,
> I have a huge data set with 1200 variables, How could I check freq of
> each variable without typing in ?
> What I mean is that I want to know what's the missing percentage of
> each variable.
| 
