About briani

SASKiwi · ‎01-08-2013

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)); run; ods output close; quit;

Tom · ‎01-04-2013

SET is an executable statement. So if you code it in a loop then it just reads one observation for each time it is called. You have what has been termed a DOW loop. See this earlier posting that has a link to an article on DOW loops. https://communities.sas.com/message/140387#140387

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Datasets in Library

SET statement in DO loop

Re: Datasets in Library

Re: SET statement in DO loop