https://communities.sas.com/t5/SAS-Programming/Top-N/m-p/569451#M160477 Depends on the data structure overall, but using PROC RANK should work. <BR /><BR />proc rank data=have out=want groups=4;<BR />by region;<BR />var sales;<BR />rank rankSales;<BR />run; Thu, 27 Jun 2019 14:34:44 GMT Reeza 2019-06-27T14:34:44Z https://communities.sas.com/t5/SAS-Programming/Top-N/m-p/569444#M160473 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.&nbsp;</P> Thu, 27 Jun 2019 14:27:48 GMT https://communities.sas.com/t5/SAS-Programming/Top-N/m-p/569444#M160473 alexgouv 2019-06-27T14:27:48Z https://communities.sas.com/t5/SAS-Programming/Top-N/m-p/569451#M160477 Depends on the data structure overall, but using PROC RANK should work. <BR /><BR />proc rank data=have out=want groups=4;<BR />by region;<BR />var sales;<BR />rank rankSales;<BR />run; Thu, 27 Jun 2019 14:34:44 GMT https://communities.sas.com/t5/SAS-Programming/Top-N/m-p/569451#M160477 Reeza 2019-06-27T14:34:44Z