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 |
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.