You can check the sashelp.vtable data set or run the following code to get a report.
proc datasets lib=sashelp;
run;
@bollurajkumar wrote:
Hi all,
I created a library and I add some datasets.
I want to check number of datasets in the created library and
Which one added recently (if it is possible)
Thanks in advance
proc sql;
select count(memname) as no_of_datasets
from
dictionary.tables
where libname='YOUR_LIBRARYNAME';
quit;
proc sql;
select memname ,crdate
from
dictionary.tables
having libname='YOUR_LIBRARYNAME'
order by crdate desc;
quit;
you can use dictionary.tables as suggested by @Reeza. crdate is create date. use your libname instead of sashelp
proc sql;
select memname, crdate from dictionary.tables
where upcase(libname) ='SASHELP'
order by crdate desc;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.