BookmarkSubscribeRSS Feed
Allan_dk
Quartz | Level 8

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

1 REPLY 1
BrunoMueller
SAS Super FREQ

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 1 reply
  • 2586 views
  • 0 likes
  • 2 in conversation