topic Re: How do i pass value for As on Date calculations in EG from SAS Visual Analytics viewer? in SAS Visual Analytics

How do i pass value for As on Date calculations in EG from SAS Visual Analytics viewer?

Arsi — Thu, 23 May 2019 07:26:51 GMT

Facing some challenges in SAS Visual Analytics 7.4 where I have to create a dashboard based on the concept of Ageing where we deal with historical data. My data-set is prepared in Enterprise Guide which has transformations and calculations being carried out based on a date time/date parameter during the beginning of the job.

Currently the data is created As on Date (the current timestamp at which the job is running). Is there a way to pass this parameter from the SAS VA viewer to populate data for a particular date in the past for comparative analytics on the dashboards?

Re: How do i pass value for As on Date calculations in EG from SAS Visual Analytics viewer?

Sam_SAS — Thu, 23 May 2019 12:37:53 GMT

Hello Arsi,

I am not an expert in data preparation, but I believe that in your data step, you could create a variable like this:

jobdate=today();

Then you could use the value of jobdate in your calculated items in VA.

Using date values in calculations can be tricky, so you might want to search this community for tips on calculating the number of days between date values, and so on.

I hope this helps,
Sam

Re: How do i pass value for As on Date calculations in EG from SAS Visual Analytics viewer?

Arsi — Fri, 24 May 2019 05:23:54 GMT

Hi Sam

Thanks for addressing the question.

While I agree that date value based calculations are tricky, there are many calculations based on numeric as well a textual data and many transformations such as append, joins etc. done at EG which might not be ideal to push it to the VA interface.

So we are talking about fetching data dynamically at run-time from SAS EG Jobs based on these date-time/date parameters entered from the VA viewer.

Re: How do i pass value for As on Date calculations in EG from SAS Visual Analytics viewer?

Sam_SAS — Fri, 24 May 2019 12:22:10 GMT

Sounds like I misunderstood -- you want to pass a parameter value selected in VA back into EG? I've never heard of this. Maybe someone else will have an idea of how it could be done.