04-12-2016 09:08 AM
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
04-13-2016 01:20 PM - edited 04-13-2016 01:22 PM
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: