topic Re: Display 10 most frequent categories in PROC FREQ? in Statistical Procedures

Display 10 most frequent categories in PROC FREQ?

braam — Wed, 15 Jul 2020 20:25:58 GMT

Dear All,

I was wondering if there is a way to display only the most frequent categories (let's say, 10) when using PROC FREQ.

proc freq data= sashelp.cars order= freq;
	table make; run;

The code shows the list of car makers with their frequency. But I just would like to display this information for the top 10 carmakers. The below table is what I would like to have. Thanks in advance!

Make Frequency Percent Cumulative
Frequency Cumulative
Percent

Toyota 28 6.54 28 6.54

Chevrolet 27 6.31 55 12.85

Mercedes-Benz 26 6.07 81 18.93

Ford 23 5.37 104 24.30

BMW 20 4.67 124 28.97

Audi 19 4.44 143 33.41

Honda 17 3.97 160 37.38

Nissan 17 3.97 177 41.36

Chrysler 15 3.50 192 44.86

Volkswagen 15 3.50 207 48.36

Make	Frequency	Percent	Cumulative Frequency	Cumulative Percent
Toyota	28	6.54	28	6.54
Chevrolet	27	6.31	55	12.85
Mercedes-Benz	26	6.07	81	18.93
Ford	23	5.37	104	24.30
BMW	20	4.67	124	28.97
Audi	19	4.44	143	33.41
Honda	17	3.97	160	37.38
Nissan	17	3.97	177	41.36
Chrysler	15	3.50	192	44.86
Volkswagen	15	3.50	207	48.36

Re: Display 10 most frequent categories in PROC FREQ?

ballardw — Wed, 15 Jul 2020 20:37:34 GMT

One way, make a data set. Then select the observations to print:

proc freq data= sashelp.cars order= freq noprint;
	table make/out=work.carfreq; 
run;

proc print data=work.carfreq(obs=10);
run;

Re: Display 10 most frequent categories in PROC FREQ?

Watts — Thu, 16 Jul 2020 01:55:45 GMT

You can use the MAXLEVELS= option in the TABLES statement.

proc freq data=sashelp.cars order=freq;
    tables make / maxlevels=10;

Re: Display 10 most frequent categories in PROC FREQ?

mkeintz — Thu, 16 Jul 2020 05:24:26 GMT

Thanks, I was totally ignorant of MAXLEVELS - cool.

Re: Display 10 most frequent categories in PROC FREQ?

Rick_SAS — Thu, 16 Jul 2020 10:28:26 GMT

You can also use the MAXLEVELS=10 option to create a bar chart that shows the top categories. See "An easy way to make a "Top 10" table and bar chart in SAS."