SAS Visual Analytics Dynamic Date Parameters

[phopkinson]

Hi,

I am currently working on a report which I want to refresh each month with the latest data - I have a date parameters representing the current month, but my question is if there anyway I can increment it using the calculated items to create multiple date parameters as I want to specify the periods for which my data is from and I can't see any other feasible way of doing this?

Thanks

[AhmedAl_Attar]

Hi @phopkinson 

Check out these articles , and the articles they reference

https://communities.sas.com/t5/SAS-Communities-Library/Use-the-latest-date-in-your-VA-report/ta-p/53...

https://communities.sas.com/t5/SAS-Communities-Library/Build-a-date-in-SAS-Visual-Analytics-reports/...

Hope this helps,

Ahmed

[SASKiwi]

With our VA reporting we derive a "month counter" before loading the data into the LASR / CAS server. Current month = 0, last month = 1, two months back = 2 and so on. Next month is tagged -1. That way a VA static filter of  "month counter" = 0 will always get the current month and no date formulas are required. This is how we create the counter:

  * Derive reporting month counter, latest month = 0, previous month = 1 and so on.;
  Reporting_Month = intck('MONTH', Reporting_Date, today());