data temp;
input var1-var6;
datalines;
1 2 3 4 5 6
. 1 2 3 4 6
. . 2 0 . 6
4 5 6 7 8 6
1 . 3 4 . 6
;
run;
ods select none;
ods output nlevels=nlevels;
proc freq data=temp nlevels;
table _all_;
run;
ods select all;
proc sql noprint;
select TableVar into :keep separated by ' ' from nlevels where NMissLevels=0;
quit;
data want;
set temp;
keep &keep.;
run;
... View more
