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?
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.