01-08-2016 06:08 AM
I would like to create a cumulative sum (running total) based on a category (and not a date) in SAS VA:
Thank you in advance for your help.
01-11-2016 12:03 PM
01-12-2016 09:40 AM
I'm glad you found Sam's response helpful! Feel free to "accept as solution" or "like" his reply. This helps out other community members who may run into the same issue.
02-25-2016 12:56 AM
I have same this issue, so the solution for "calculate the running total as part of your data query",
you can show how to this solution,
02-26-2016 08:54 AM
If you have the appropriate permissions in SAS VA, then you can access the data builder. On the home page you will see a "Data preparation" link.
In the data builder, you can edit the SQL expressions for your columns or edit the SAS data step for your query.
I am not an expert in this area so I am not sure exactly what expression you would want to build to calculate your running total.
I hope that helps,