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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.