Lets say I have a value of 1 for each item in a group. Sometimes it adds to 13, somtimes to 7, etc. and then I want a sum, which is the final value of each group. I know I can use last.variable for each group and then output to new dataset and then combine in sql easy enoug, but I want to avoid the extra step.
Basically:
Game | Value | Cum. Sum |
---|---|---|
A | 1 | 1 |
A | 1 | 2 |
A | 1 | 3 |
A | 1 | 4 |
A | 1 | 5 |
I want the last cum. sum statement to be the last for each game (Game A would have 5 for each). Again, easy enough to do with last. and a join, but any easy way to simply do it all in one datastep?
Even if you do it in one datastep you're making more than one pass through the data.
If the one step is important, then look into a DOW loop.
Even if you do it in one datastep you're making more than one pass through the data.
If the one step is important, then look into a DOW loop.
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.