How do I select top 5 obs ?

[LMSSAS]

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;

LMSSAS_0-1665412822159.png

[LinusH]

Perhaps PROC RANK could help you?

[LMSSAS]

Thank you!

[PeterClemmensen · Accepted solution]

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;

[LMSSAS]

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