topic How can I suppress categories with low frequencies from SA in SAS Programming

How can I suppress categories with low frequencies from SA

ama220 — Thu, 16 Feb 2023 21:36:10 GMT

Hello,

I need to suppress categories with low frequency values (less than 10) from the output of proc freq. Any tips to me me out would be appreciated.

proc freq order= freq ; table outcome_coded

Re: How can I suppress categories with low frequencies from SA

ballardw — Thu, 16 Feb 2023 22:56:00 GMT

Generally when I have such a requirement I send the output to a data set, which I then have for reference when the inevitable question comes back later, and just display the desired values in a report.

proc freq data=whatever order=freq noprint;
   tables outcome_coded / out=outcome_freqs outcum;
run;

Proc print data=outcome_freqs noobs;
   where count>10; /* or whatever limit*/
run;

The OUTCUM option means to include the cumulative count and percents. By default they do not appear in the out= data set.

Another approach if you want to show that the category existed but just suppress the count could be done but how you would address the percent values.

Re: How can I suppress categories with low frequencies from SA

ama220 — Fri, 17 Feb 2023 14:39:06 GMT

Thanks!