In the post-COVID world a question that is regularly getting asked is what growth is occurring in numbers since (for all intents and purposes for work) March 2020.
What I need to be able to do in VA is create a table that has numbers at end of month February and calculate the difference between that and the latest month. We have a "month end" in the data set and I need to show all three items in a table - February numbers, latest month numbers and the calculated difference.
I've tried various combinations of setting up March by itself using filters and latest month as a calculated item and using Treat As to change to number and then rank but can't get this to work. I've tried in both a list table and a cross tab.
Any help would be sorely appreciated.
Always the latest month | |||
Center | February | July | Growth |
A | 3100 | 4566 | 1466 |
B | 2828 | 3772 | 944 |
C | 2868 | 3944 | 1076 |
D | 593 | 1259 | 666 |
E | 1104 | 1242 | 138 |
Total | 10493 | 14783 | 4290 |
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.