For only quarterly reports , how to prepare a drop down you can use the quarter-end months only.

[QAMARSULTANA]

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.

[FredrikE]

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

[QAMARSULTANA]

How do u change it to year quarter format please provide an example
I prepared a new custom category with quarter format as quarter 1
-20170100, 20170200,20170300.20180100,20180200,29180300
And the other quarters in similar way but then when I press on quarter 1 it
shows all the months I want result of only quarter end month that is
20170300or 20180100 as required

[FredrikE]

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