topic Re: identify empty datasets in SAS Programming

identify empty datasets

Suzy_Cat — Tue, 10 Dec 2019 22:22:54 GMT

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 — Tue, 10 Dec 2019 22:27:28 GMT

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

Suzy_Cat — Tue, 10 Dec 2019 22:31:50 GMT

Super! Thank you very much!