identify empty datasets

[Suzy_Cat]

hi there,

I have created a number of datasets named with prefix Check_, is there any easy way to quickly identify which one is an empty dataset?

Ideally, it would be great if all datasets starting with "Check_" can be listed with total obs info.

currently I am using below code to delete unwanted datasets, the result window does not provide info that can identify an empty datasets:

proc datasets library=work memtype=data; delete Prefix_:; Run; quit;

Thanks in advance!

[Kurt_Bremser · Accepted solution]

proc sql;
create table want as
select memname
from dictionary.tables
where libname = 'WORK' and memname like 'CHECK_%' and nobs = 0;
quit; 

[Suzy_Cat]

Super! Thank you very much!