For only quarterly reports , how to prepare a drop down in SAS VA to use the quarter-end months only. if you have months from 2017, 2018 and to move forward.
If you have the months in date format you just need to change it to year-quarter format 🙂
Otherwise you can create a quarter variable where you create it from year and month.
//Fredrik
If tou only want to show the last month in each quarter, you can use the MONTH function and create a new calculated variable.
You will then only create the quarter value if the month number is 3,6,9 or 12.
//Fredrik
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.