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 (December 1999, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 16 Dec 1999 16:17:43 -0500
Reply-To:   Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject:   Re: Reading in multiple files of the same extension from a single directory
Content-Type:   text/plain; charset=US-ASCII

I've used this wildcard technique. Recently had a bit of trouble though when the filenames had no extension. To get SAS to process the files, I ended up renaming them ("foo1" became "foo1.dat" etc.). This was using SAS 6.12 TS020 and Win 95.

> From: Peter Crawford <peter.crawford@DB.COM> > > suppose the filevar option gets a bit top heavy (it is quite memory > intensive when you have lots of datasets) > > just try global naming (something like) > infile 'my*.txt' truncover file=filenam; > > or where you already have the meta data of the physical names required, > in a sas data set, populate a macro variable with the names wanted using > sql code like (untested!) > > proc sql noprint; > select distinct quote( physName ) into :wantname separated by ' ' > from meta.data /* or which-ever */ > where <it is really wanted>; > quit; > > then your infile statement might be > infile ( &wantname ) truncover filename = filenam > ls=10000 /* larger than the largest */ ; > > the infile option FileName= allows you to know from which text file the > infile is reading at run time.


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