SAS9.2
I have Chain, State, Volume, Client variables. 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
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
Some example have and want data files, along with your code, would help.
Art, CEO, AnalystFinder.com
PROC RANK will do it for you.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.