Goof Afternoon,
Does anyone know if it is possible to have a procedure or macro that will delete all empty datasets (ie dataset that has 0 obs) in the work library?
Many thanks.
cxkev
You can query DICTIONARY.TABLES to find the members with 0 obs.
You could use the information to generate DROP TABLE statements.
proc sql noprint ;
select 'drop table work.'||memname into :empties separated by ';'
from dictionary.tables
where libname='WORK' and nobs=0
;
&empties;
quit;
You can query DICTIONARY.TABLES to find the members with 0 obs.
You could use the information to generate DROP TABLE statements.
proc sql noprint ;
select 'drop table work.'||memname into :empties separated by ';'
from dictionary.tables
where libname='WORK' and nobs=0
;
&empties;
quit;
Thaks Tom - Do I need to code the macro &empties, do you know how I would go about that?
Just copied and pasted your code and got "apparent symbolic reference EMPTIES not resolved"
Apols if I'm missing somethign obvious here.
Thanks,
cxkev
Actually Tom - I can go from here - I was not aware of DICTIONARY.TABLES before but now I have that I know where to go.
Thanks very much for your help.
cxkev
Add this line before the SELECT statement to clear the macro variable and make sure it is defined and empty even when there are no results returned from the query.
%let empties=;
Thanks Tom - That's worked a treat!
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.