Date: Wed, 27 Aug 2003 15:39:17 -0400
Reply-To: Charles Patridge <charles_s_patridge@PRODIGY.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Charles Patridge <charles_s_patridge@PRODIGY.NET>
Subject: Re: Obtaining names of data sets contained within a library
This may or may not be faster/efficient but it is worth a try -
proc sql noprint ;
where LIBNAME = "libcontent"
and MEMTYPE = "DATA"
and (substr(MEMNAME,1,3) ^= 'qry') and
(substr(MEMNAME,1,4) ^= 'MSys');
order by NAME, MEMNAME
where libcontent would be your macro var.
Depending on how many libraries you have available, this could be slower.
Also, it eliminates your need to do a Proc Datasets. BTW, you should have
a "quit" instead of a "run" statement.