01-08-2013 08:49 PM
Sometimes dictionary tables perform slowly because there are lots of libraries and tables and/or some libraries point to external databases. PROC DATASETS can be a lot faster. This example uses ODS to create a dataset CONTENTS containing a list of all tables in the WORK library.
proc datasets library = WORK nolist;
contents data = _ALL_ nods;
ods output members = contents (rename = (name = memname));
ods output close;