topic Re: SAS Visual Analytics (Viya 4) - Get CAS Data Set Properties (e.g. Modified date/time) into Repor in SAS Visual Analytics

SAS Visual Analytics (Viya 4) - Get CAS Data Set Properties (e.g. Modified date/time) into Report

dylanviking — Mon, 24 Jul 2023 12:18:52 GMT

Is there a way to expose the CAS data set properties in the SAS Visual Analytics report that I am building?

Basically, I'd like to have a section in the dashboard to notify users when the data set was last updated. When adding a CAS data set to the VA report, I can see all the details. But there is no way to provide that information to end users unless I go down the route of creating a separate dataset off the back of a PROC CONTENTS to get the relevant details out and then add that data set into VA

Re: SAS Visual Analytics (Viya 4) - Get CAS Data Set Properties (e.g. Modified date/time) into Repor

Sam_SAS — Mon, 24 Jul 2023 12:39:13 GMT

Hello,

You can display the time the table was updated by using dynamic text in a Text object.

Just create a Text object and click the clock icon in the text editor toolbar.

https://go.documentation.sas.com/doc/en/vacdc/v_020/vaobj/n0am6dia40z5lfn1pxqoemibdtp6.htm

Let us know if that helps,

Sam

Re: SAS Visual Analytics (Viya 4) - Get CAS Data Set Properties (e.g. Modified date/time) into Repor

dylanviking — Mon, 24 Jul 2023 13:40:44 GMT

Looks like it worked! I've actually done some work recently on the Text object to show filters applied but probably missed out on the table update time variable that is available.

Re: SAS Visual Analytics (Viya 4) - Get CAS Data Set Properties (e.g. Modified date/time) into Repor

Sam_SAS — Mon, 24 Jul 2023 13:54:28 GMT

Great! Thanks for following up with us 🙂