Is it possible for a user that don't have access to SASVisualAnalyticsAdministrator to see when the data in LASR was updated.
A workaround is to add a variable last_updated when the data is created, but I think there must be another way around.
VA version 7.3
Hi
I am not awhere of any builtin function that will return this information. However one could create a Stored Process that will return this information. The Stored Process could be called by anyone who wants to see this information, it could also be part of a report that displays this information.
Find below a code example on how to get this information. running this code as a Stored Process one needs to provide the information for the SAS library and table to be used as parameter values (&libref and &tablename). The program will display when the LASR table was last modified. This has nothing to do with any date information within the data.
options nocenter;
libname EVDMLA META library="Environment Manager Data Mart LASR";
proc sql;
create table myInfo as
select
catx(".", libname, memname) as tableName
, crdate format=datetime19.
, modate format=datetime19.
from
dictionary.tables
where
libname = "%upcase(&libref)"
and memname = "%upcase(&tablename)"
;
quit;
proc report data=myInfo noheader;
run;
The output of the Stored Process is in add to your report. See sample output below:
Bruno
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.