Please help me on how to showcase the data of 3 months from the selected month in SAS VA

[Ajai_Utd]

Dear All,

The below sample table is registered in the lasr.

Date	Stage	Amount
01-Jan-18	Stage1	100
01-Jan-18	Stage1	100
01-Jan-18	Stage1	100
02-Feb-18	Stage2	100
02-Feb-18	Stage2	100
02-Feb-18	Stage2	100
03-Mar-18	Stage3	100
03-Mar-18	Stage3	100
03-Mar-18	Stage3	100
04-Apr-18	Stage1	100
04-Apr-18	Stage1	100
04-Apr-18	Stage1	100

Based on this table I want to create a table in SAS VA in such a way that if I select a Date in the dropdown list, it shud show the values for 3 previous months for Example: If I am selecting the Date in drop-down list as 01Mar2018, its shud show the 3 months inclusive of march i.e.., 01Mar2018, 1Feb2018, and 01Jan2018.

Please let me know the solution for this in SAS VA.

Regards,

Ajai

[Renato_sas]

Hi @Ajai_Utd,

Have you taken a look at this article?

How to filter on multiple date periods based on a reference date in SAS Visual Analytics

I think it does what you are asking for.

Best,

Renato