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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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