Hello
Let's say that there is a sas data set that is saved in a permanent sas library.
Let's say that the data set is called RRR.cars (RRR is the permanent library name).
I would like to know when was the last update of this data set (date and time)
what is the way to check it?
In SQL:
select modate
from dictionary.tables
where
libname = "RRR"
and memname = "CARS"
;
Library and member name must be in upper case.
In SQL:
select modate
from dictionary.tables
where
libname = "RRR"
and memname = "CARS"
;
Library and member name must be in upper case.
Another option would be:
data wotk.x;
set sashelp.class;
run;
proc contents noprint
data = work.x
out = nodate(keep=modate varnum where=(varnum=1));
run;
it jumps directly to that particular data set.
and if you are focused on all datasets in given library:
proc contents noprint
data = work._all_
out = nodate(keep=modate varnum memname where=(varnum=1));
run;
All the best
Bart
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.