PRELOADFMT in proc freq or counting percentage in proc summary

hira — Sat, 19 May 2018 11:09:13 GMT

Hi,

I am trying to get some missing data for the whole class by proc freq.

It can easily be achived by proc summary as below. for example if pregnant='Y' is complety missing , it will still produce the desire result.

proc summary data= test completetypes nway ;
by allgrp nbyvar;
class pregnent / preloadfmt;
output out=test1(drop=_type_) / autoname;
format pregnent ynf. ;
run;

I would like to know the percent as well which is possible in proc freq as below but it does not give me the 0 count for pregnent='Y' even i tried sparse option too.

proc freq data= test1 noprint;
by allgrp nbyvar;
table pregnent/ out=test2;
format &var1. ynf. ;
run;

Is there any way i can achive percent in proc summary or missing count in proc freq?

Thanks,

Re: PRELOADFMT in proc freq or counting percentage in proc summary

ChrisNZ — Mon, 21 May 2018 05:06:06 GMT

It would be a lot easier to understand your need if you provided a data sample and an expected result.

I presume you saw this? What's missing there?

topic Re: PRELOADFMT in proc freq or counting percentage in proc summary in SAS Programming

PRELOADFMT in proc freq or counting percentage in proc summary

Re: PRELOADFMT in proc freq or counting percentage in proc summary