I am new to SAS and I currently working in SAS Visual Analytics(latest version).
I have a cross in SAS VA that is similar to the one below:
| Year | Return On Investment (%) |
| 2019 | 5% |
| 2020 | 10% |
| 2021 | 17% |
| 2022 | 4% |
But I want to add a third that calculates the year on year change in SAS VA, like the one below.
May I have assistance?
| Year | Return On Investment (%) | YoY change |
| 2019 | 5% | 5% |
| 2020 | 10% | 7% |
| 2021 | 17% | -13% |
| 2022 | 4% |
The following blog and another post are helpful.
https://blogs.sas.com/content/sgf/2017/12/21/relative-period-report-in-sas-visual-analytics/
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.