topic Find number of datasets in sas in SAS Programming

Find number of datasets in sas

bollurajkumar — Mon, 03 Dec 2018 04:01:07 GMT

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

Re: Find number of datasets in sas

Reeza — Mon, 03 Dec 2018 04:14:12 GMT

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

Re: Find number of datasets in sas

novinosrin — Mon, 03 Dec 2018 04:38:05 GMT

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;

Re: Find number of datasets in sas

kiranv_ — Mon, 03 Dec 2018 04:42:10 GMT

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;