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!
proc sql;
create table want as
select memname
from dictionary.tables
where libname = 'WORK' and memname like 'CHECK_%' and nobs = 0;
quit;
proc sql;
create table want as
select memname
from dictionary.tables
where libname = 'WORK' and memname like 'CHECK_%' and nobs = 0;
quit;
Super! Thank you very much!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.