LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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>


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

Back to: Top of message | Previous page | Main SAS-L page