data ZIPcode;
set sashelp.ZIPcode;
if msa=0 then msa=.;
label ZIP_class=" " MSA=" " CountyNm=" " AreaCode=" ";
run;
* One PROC step can handle all variables ;
proc format;
value missfmt
.="Num Missing"
other="Num Non-Missing";
value $missfmt
" "="Char Missing"
other="Char Non-Missing";
run;
proc tabulate data=ZIPCode Missing format=comma8. out=sample;
class CountyNm AreaCode MSA ZIP_Class / preloadfmt;
tables CountyNm AreaCode MSA ZIP_Class / printmiss misstext="0";
format _numeric_ missfmt. _character_ $missfmt.;
keylabel n="Count";
title1 "Missing and Non-Missing Counts for each Variable";
run;
Hi,
any one can help me
here i am using proc tabulate for finding missing and non missing count, but soma problem with the output data set. because of i have crated user defined formats.
Thanks and Regards
Saiaram.