I have a report that will be published year to year and I'd like to cut down on the maintenance needed. I have a lot of aggregated measures for example.
Here's some sample code:
Sum [_ByGroup_] ('Ordered 2017'n) - Sum [_ByGroup_] ('Ordered 2016'n)
I have a chart which has the year as a category. So next year the columns will be 'Ordered 2018' and 'Ordered 2017'. Is it possible for me to do something that will dynamically adjust these column names in the code so that they're not hardcoded and will always be the current year and current year-1.
Having measures variables created according to time is awkward, it's more like an Excel layout. That said, it isn't obvious how to deal with calculations like yours in VA, makes one miss OLAP cubes sometimes.... I don't have access to VA at this point, but a vague idea. First restructure your data so you have a time classification variable instead (like year, if that is your preferred granularity). Then you perhaps could use the ParallelPeriod periodic operator to retrieve last years values. http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#n1lxnqfip132can1hdzue...
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.