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
Comments: To: Doug Cacialli <Doug_Cacialli@URMC.ROCHESTER.EDU>

Doug,

This may or may not be faster/efficient but it is worth a try -

proc sql noprint ;
             select *
               from  dictionary.columns
               where LIBNAME = "libcontent"
                 and MEMTYPE = "DATA"
                 and (substr(MEMNAME,1,3) ^= 'qry') and
                (substr(MEMNAME,1,4) ^= 'MSys');
             order by NAME, MEMNAME
             ;
          quit ;



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.

HTH,
Charles Patridge