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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 3028 views
  • 0 likes
  • 2 in conversation