topic Re: How to find 3 most frequently occurring values? in Statistical Procedures

How to find 3 most frequently occurring values?

Ola22 — Thu, 16 Jul 2015 12:44:44 GMT

Hello All,

How can I find three most frequently occurring values in my data set using SAS?

Regards,

Aleksandra

Re: How to find 3 most frequently occurring values?

craftsman — Fri, 17 Jul 2015 08:31:34 GMT

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;

Re: How to find 3 most frequently occurring values?

RW9 — Fri, 17 Jul 2015 08:47:33 GMT

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.