When was data last updated

Allan_dk — Tue, 12 Apr 2016 13:08:38 GMT

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

Re: When was data last updated

BrunoMueller — Wed, 13 Apr 2016 17:22:24 GMT

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

topic Re: When was data last updated in SAS Visual Analytics

When was data last updated

Re: When was data last updated