Find number of datasets in sas

[bollurajkumar]

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

[Reeza]

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

---

[novinosrin]

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;

[kiranv_]

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;