05-25-2017 11:12 AM
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.
05-27-2017 05:38 AM
05-27-2017 08:35 PM
SAS VA formulas can only be changed manually so you would be stuck with editing your code each year. Best practice in VA would be to use relative definitions like current year and last year.