I ranked Guest account based on their playdate. So a guest first playdate is ranked as 1; second playdate is ranked as 2, and so on. I got million of rows of data and I want to get the highest ranked number of the guest's.
Please see image below of the sample data. Now what I want is to take GuestNumber 103726's highest ranked number which is 75 and bring it to another dataset. How do I go about to do that ?
Thank you all, I figured it out.
Thank you all, I figured it out.
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.