Hi SAS friends, is there a way to run a frequency on a variable without displaying every level for that variable? For example i have a variable called Phone for which i have 1M observations. I don't want to know the number of occurrences of phone i just want to know if its missing. If i run the normal proc freq with the missing option it takes 20+minutes to get results. I'm running SAS 9.4 with STAT. Thank you, data BigDS; do i = 1 to 1000000; PhoneNums=INT((RanUni(07022014)*10000000000)); MissRate=RanUni(1234); if MissRate>=.8 then call missing(PhoneNums); keep PhoneNums; output; end; run; proc freq data = BigDS; table PhoneNums/missing; run;
... View more