@Luisfco88 wrote:
Hi,
If you stored macro in this folder:
libname mylib '/home/folder/StoredMacros/';
You can recall all macro saved
options mstored sasmstore=mylib;
With this proceduce you can print a list of macros from catalog:
proc catalog CATALOG=mylib.sasmacr ;
Contents;
run;
quit;
Another option to get a list of macros using a filter on the dictionary alfter calling stored macro:
proc sql;
select *
from dictionary.catalogs
where objtype='MACRO' and libname='MYLIB';
quit;
Regards,
This corrects some of the problems with the earlier answers.
Let's spell them out.
1) LIBNAME variable in the DICTIONARY tables is always in uppercase.
2) If you are looking for the compiled macros that are currently available you need to check the setting of the SASMSTORE system option. A query against DICTIONARY.CATALOGS without limiting the results to those found in the catalog that will actually be used by SASMSTORE could return the names of macros that are compiled but not current discoverable.
... View more
