It sounds like you want the Top and Bottom 5 categories by percentage. See that article, "An easy way to make a "Top 10" table and bar chart in SAS."
Here is an example of how to use the technique to get the Top and Bottom 5:
/* write the sorted frequencies to a data set */
proc freq data=sashelp.cars ORDER=FREQ noprint;
table make / out=FreqOut;
run;
/* print the top 5 */
%let MaxN = 5;
title "Top &MaxN Categories";
proc print data=FreqOut(obs=&MaxN);
run;
/* print the bottom 5 */
proc sort data=FreqOut; by percent; run;
title "Bottom &MaxN Categories";
proc print data=FreqOut(obs=&MaxN);
run;
... View more
