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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.