How can I suppress categories with low frequencies from SA

[ama220]

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

[ballardw · Accepted solution]

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.

[ama220]

Thanks!