Hello All,
How can I find three most frequently occurring values in my data set using SAS?
Regards,
Aleksandra
proc means data=sashelp.class NoPrint CharType;
class _numeric_;
var _numeric_;
output out=Freq(where=(_TYPE_ in('100','010','001'))) n=;
run;
option obs=3;
proc sort
data=Freq
out=FreqMax;
by descending _FREQ_;
run;
option obs=max;
Proc rank springs to mind: Base SAS(R) 9.2 Procedures Guide
Or coding it in SQL:
proc sql;
create table WANT as
select VAR,
count(OTHER_VAR) as CNT
from HAVE
group by VAR;
quit;
Where var is the caegorisor, and other_var is the occuring variable. Then you can just take the top x from the resulting dataset.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.