- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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