topic Re: How do I select top 5 obs ? in SAS Programming

How do I select top 5 obs ?

LMSSAS — Mon, 10 Oct 2022 14:42:41 GMT

I have the following output (see visual below SAS code) and I want to select the Top 5 obs for each manager. Can someone advise how to solve for this?

proc sql; create table DSNP_Agents1_Chart as  
select distinct
a.county,
sum(a.mbr_end_inv) as Total,
a.Broker_Manager
From DSNP_Agents1 a
group by county, Broker_manager
order by Total desc 
;quit;

proc sort data=DSNP_Agents1_Chart; 
by Broker_manager;
run;

Re: How do I select top 5 obs ?

LinusH — Mon, 10 Oct 2022 14:48:48 GMT

Perhaps PROC RANK could help you?

Re: How do I select top 5 obs ?

PeterClemmensen — Mon, 10 Oct 2022 15:01:23 GMT

One way

proc rank data=sashelp.iris out=rank descending ties=low;
   by species;
   var SepalLength;
   ranks r;
run;
 
proc sort data=rank out=want(drop = r);
   where r <= 3;
   by species r;
run;

Re: How do I select top 5 obs ?

LMSSAS — Mon, 10 Oct 2022 17:00:23 GMT

I appreciate your help, this solution worked!! Thank you for your time

Re: How do I select top 5 obs ?

LMSSAS — Mon, 10 Oct 2022 17:00:42 GMT

Thank you!