Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

When was data last updated

Reply
Contributor
Posts: 40

When was data last updated

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

SAS Super FREQ
Posts: 676

Re: When was data last updated

[ Edited ]

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:

Capture.PNG

Bruno

Ask a Question
Discussion stats
  • 1 reply
  • 254 views
  • 0 likes
  • 2 in conversation