topic SAS Visual Analytics Dynamic Date Parameters in SAS Visual Analytics

SAS Visual Analytics Dynamic Date Parameters

phopkinson — Fri, 10 May 2024 18:03:16 GMT

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

Re: SAS Visual Analytics Dynamic Date Parameters

AhmedAl_Attar — Mon, 13 May 2024 03:23:43 GMT

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/536536

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

Hope this helps,

Ahmed

Re: SAS Visual Analytics Dynamic Date Parameters

SASKiwi — Mon, 13 May 2024 05:01:15 GMT

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());