topic Re: Simple proc freq of a variable limiting to top 5 on SAS studio in SAS Studio

Simple proc freq of a variable limiting to top 5 on SAS studio

byeh2017 — Tue, 25 Apr 2017 08:14:31 GMT

Hi everyone,

I have a massive output of a proc freq of a variable in which I want to only limit to the top 5. How do I set up the code? I used this and it seemed to not work:

proc freq data=janfeb.jfgmi order=freq rowlimit=5;
table finalicd10;
run;

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

Astounding — Tue, 25 Apr 2017 10:43:48 GMT

SAS has to count every observation, to know what belongs in the highest 5. So you might as well count them all:

proc freq data=jabfeb order=freq;

tables finalicd10 / noprint out=counts;

run;

By creating a SAS data set instead of printing the table, you now have choices. The simplest:

data want;

set counts (obs=5);

run;

However, if the 5th highest count also appears as the 6th or 7th highest count, you lose the ties. You could instead continue with:

data want;

set counts;

by descending count;

if first.count and _n_ > 5 then stop;

run;

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

Rick_SAS — Tue, 25 Apr 2017 12:11:57 GMT

You can also use the method that Astounding mentions to graph the top categories. See "Create a bar chart with only a few categories."

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

Ksharp — Tue, 25 Apr 2017 12:28:52 GMT

Use SQL instead .


proc sql outobs=5;
 select air,count(*) as count
  from sashelp.air
   group by air
    order by count desc;
quit;

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

byeh2017 — Tue, 25 Apr 2017 13:31:09 GMT

This works! Thanks. How do I title a proc sql statement?

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

Ksharp — Tue, 25 Apr 2017 13:46:46 GMT

You mean add a title or lable ?

title 'xxxxxxx';

proc sql outobs=5;
 select air,count(*) as count label='xxxxx'
  from sashelp.air
   group by air
    order by count desc;
quit;

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

byeh2017 — Tue, 25 Apr 2017 13:55:13 GMT

That works, thanks!

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

spcoman — Mon, 29 Jan 2018 15:10:59 GMT

Thanks so much for this code it is very helpful! How would you go about formatting a table like this. I tried using PROC TABULATE to rename the row headers etc. but I don't know how to point the PROC TAB at the new table.

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

Ksharp — Tue, 30 Jan 2018 12:14:57 GMT

Once you assign a label to a variable, proc tabulate would print the label.

like:

options label;

proc tabulate .......

And can start a brand new session to let other know your Q,and maybe others have a better idea.

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

dhwanipatel109 — Wed, 17 Jun 2020 14:27:14 GMT

You can try:

proc freq data=janfeb.jfgmi ORDER=FREQ;
tables make / maxlevels=5 Plots=FreqPlot;
run;

Re: Simple proc freq of a variable limiting to top 5 on SAS studio

wlauzon — Wed, 09 Jun 2021 16:01:25 GMT

I just stumbled upon this answer and it is by far the simplest solution, thank you so much!