11-07-2014 04:54 AM
I hope all is well. I am not expert in SAS; but strive to definitely learn more of this program.
I am currently undertaking a project with deals with a lot a datasets placed under different libraries. I have created multiple %macro definitions which in turn has generated many output tables and utilised many input tables. These tables are saved under different libraries.
My computer slows down when these datafiles are created. Clearing unwanted tables in every macro program session speedens up computational response.
Is there a way to generate a list of input and output tables created either using PROC SQL or DATA steps by EACH MACRO PROGRAM? Each MACRO PROGRAM has multiple %macros, once again from code readability purposes. Prefixing/suffixing the datafiles with 'IN' or 'OUT' statements does not help. This would help me in data management. All help is appreciated. thanks. seb
11-07-2014 05:54 AM
Just to quantify myself, sorry for the brief post, am in meetings. What I would suggest is that you have some kind of logical assignment, so either have a set of libraries which hold you datasets, or have a fixed pre-fix you could search for. Then its just a matter of querying the SAS metadata tables - SASHELP, or as Kurt has mentioned DICTIONARY in SQL. Pull these out as a list of datasets to evaluate. To remove them something like:
set sashelp.vtable (where=(libaname="STORE")) end=last;
if _n_=1 then call execute('proc datasets library=store; delete ');
if last then call execute(';quit;');
11-07-2014 05:29 AM
Or, in proc sql, use DICTIONARY.TABLES.