topic Re: For only quarterly reports , how to prepare a drop down you can use the quarter-end months onl in SAS Visual Analytics

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

QAMARSULTANA — Thu, 13 Dec 2018 19:14:07 GMT

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.

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

FredrikE — Fri, 14 Dec 2018 08:43:10 GMT

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

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

QAMARSULTANA — Fri, 14 Dec 2018 11:56:47 GMT

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

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

FredrikE — Mon, 17 Dec 2018 09:50:42 GMT

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