topic Re: To obtain end of quarter months in VA in SAS Visual Analytics

To obtain end of quarter months in VA

Sultana — Fri, 28 Dec 2018 15:55:40 GMT

Can you provide me with a code that shows only the end of quarter months March ,June, September, December and moves on in the future months my data stats from 2017.so That I can use it in the drop down menu, THIS IS FOR SAS VA

Re: To obtain end of quarter months in VA

Sam_SAS — Wed, 02 Jan 2019 14:57:48 GMT

Hello,

I believe this type of expression is what you will be looking for:

( Month('Date by Month'n) In (3, 6, 9, 12) )

Is this the type of result you want?

What I did here was create a duplicate of 'Date by Month' and set its format to Month. This data item is assigned to the button bar. To show only the 4 end of quarter months in the button bar, I created a filter similar to the code I shared above. Then I created an interaction so that the list table would be filtered by the button bar. This might happen automatically for you, depending on how you create the button bar.

Let us know if that helps, or if you are looking for something different.

Thanks,

Sam

Re: To obtain end of quarter months in VA

touwen_k — Wed, 17 Nov 2021 16:20:31 GMT

thank you Sam, it also helped me.

Re: To obtain end of quarter months in VA

Sam_SAS — Wed, 17 Nov 2021 17:57:31 GMT

Great, thanks for letting us know 🙂