Hi,
We have a financial year running from July to June, with 5,5,4 structure.
What can be done to manipulate this in SAS VA 7.3 using periodic functions.
Unless I hardcode rawdata, that is only way to enable year to date or if I use a list table to manipulate combined with parameters.
I would much rather prefer to have a table which should day, week, month, quarter, year to date and comparison to last year. This table needs to be manipulated with drop downs.
Is there is a very simple solution is SAS VA that I should be leveraging to resolve this issue. It almost seems like SAS VA can only deal with calendar year only !
Any help you can provide would be appreciated.
thks,
Sukh
Hi Sukh,
Unfortunately the periodic calculations within the VA interface is only for calendar year. Discussions and requests to have this for financial year have been had in other threads, see below...
Period calculations in VA using Financial Year
I would like to know how to make a fiscal year
An alternative would be do use this finanical year calculations using SAS as part of your data preparation prior to loading into VA.
Kind Regards,
Michelle
Hi Sukh,
Unfortunately the periodic calculations within the VA interface is only for calendar year. Discussions and requests to have this for financial year have been had in other threads, see below...
Period calculations in VA using Financial Year
I would like to know how to make a fiscal year
An alternative would be do use this finanical year calculations using SAS as part of your data preparation prior to loading into VA.
Kind Regards,
Michelle
Thanks Sukhbir for posting what you did to achieve this.
Agree - hopefully there will be a built-in financial year capability in the future.
Kind Regards,
Michelle
Hi Sam,
Any details on that functionality? will it be flexible in order to supoprt other calndars such as academic year?
I can't make any promises about future planned features, but currently the plan is to allow you to start the year on any month, for the cumulativePeriod operator (which is used for YTD calculations.)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.