How do I calculate the year on year change in SAS Visual Analytics?

Beatrize — Thu, 18 Sep 2025 08:45:29 GMT

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%

Re: How do I calculate the year on year change in SAS Visual Analytics?

tsukune — Fri, 19 Sep 2025 04:32:58 GMT

RelativePeriod returns the aggregated value for a period of time that is relative to the current period.

The calculated item is created by the following syntax:

(RelativePeriod(_Sum_, ROI_PCT, ApplyAllFilters, YEAR, Inferred, 0, Full) - RelativePeriod(_Sum_, ROI_PCT, IgnoreInteractiveTimeFrameFilters, YEAR, ByYear, 1, Full))* -1

Here is a sample output:

The following blog and another post are helpful.

https://blogs.sas.com/content/sgf/2017/12/21/relative-period-report-in-sas-visual-analytics/

https://communities.sas.com/t5/SAS-Visual-Analytics/Creating-a-Difference-from-previous-period-variable-on-an/td-p/649205#

topic How do I calculate the year on year change in SAS Visual Analytics? in SAS Studio

How do I calculate the year on year change in SAS Visual Analytics?

Re: How do I calculate the year on year change in SAS Visual Analytics?