https://communities.sas.com/t5/SAS-Programming/Ranking/m-p/354321#M82868 <P>PROC RANK will do it for you.</P> Fri, 28 Apr 2017 01:25:35 GMT Reeza 2017-04-28T01:25:35Z https://communities.sas.com/t5/SAS-Programming/Ranking/m-p/354308#M82865 <P>SAS9.2</P><P>I have Chain, State, Volume, Client &nbsp; variables. &nbsp;I need to figure out who the top client is (1st) in each state for each chain based on the volume. I also need another column added to my report "State rank" which is a number (rank) that ranks each state for each chain based on the volume</P><P>so far to get the top client I did the summary by Chain, State, Client and then First.state statement, but i can't figure out how to add rank</P><P>&nbsp;</P> Thu, 27 Apr 2017 23:19:39 GMT https://communities.sas.com/t5/SAS-Programming/Ranking/m-p/354308#M82865 Sdlenter 2017-04-27T23:19:39Z https://communities.sas.com/t5/SAS-Programming/Ranking/m-p/354311#M82866 <P>Some example have and want data files, along with your code, would help.</P> <P>&nbsp;</P> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Fri, 28 Apr 2017 00:07:02 GMT https://communities.sas.com/t5/SAS-Programming/Ranking/m-p/354311#M82866 art297 2017-04-28T00:07:02Z https://communities.sas.com/t5/SAS-Programming/Ranking/m-p/354321#M82868 <P>PROC RANK will do it for you.</P> Fri, 28 Apr 2017 01:25:35 GMT https://communities.sas.com/t5/SAS-Programming/Ranking/m-p/354321#M82868 Reeza 2017-04-28T01:25:35Z