Hi everyone, I try to count number of missing for each variable of my dataset with following codes. proc format;
value $missfmt '-9'='Missing' '-8'='Missing' '-6'='Missing' '-7'='Missing' ''='Missing' ' '='Missing' other='Not Missing';
value missfmt . ='Missing' -9='Missing' -8='Missing' -6='Missing' -7='Missing' other='Not Missing';
run;
data pii;
set pii.pii_trad_nochc;
format _NUMERIC_ missfmt. _CHAR_ $missfmt.;
run;
proc freq data=pii;
format _NUMERIC_ missfmt. _CHAR_ $missfmt.; /* apply format for the duration of this PROC */
table _all_ / nocum;
run; I have 600 variables and the proc freq gives me the number of missing for all of them. The question is how to save the output in one dataset? Please advise, Bibi
... View more
