Top N%

[alexgouv]

Hi, 

I am trying to find the number of accounts that are responsible for the top 25%, 50%, and 75% of sales in each region. The final output needs to be something like 4 accounts make up the top 25%, 9 make up the top 50%, etc.

If there is a way to flag which group each account is in that would be ideal but any guidance would be helpful at this point. 

[Reeza]

Depends on the data structure overall, but using PROC RANK should work.

proc rank data=have out=want groups=4;
by region;
var sales;
rank rankSales;
run;