Date: Thu, 25 Jan 2007 16:39:25 -0500
Reply-To: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject: Re: loop through all files in dir for inclusion in macro
Refer to the D...-functions in the SAS docu (DOPEN, DNUM, DREAD, ...) for
reading the files in a data-step and put them into macro variables like
do i=1 to number_of;
Then you can use a macro loop to get them all in.
On Thu, 25 Jan 2007 16:22:44 -0500, Fehd, Ronald J. (CDC/CCHIS/NCPHI)
>> From: StephenTGallagher
>> I have a directory with ten (abitrary number...could be
>> hundreds) of files, whose naming convention is not
>> consistent, but, more or less, extension is .txt or .csv.
>> I have a macro to, for example, import all of these files.
>> Currently I am hardcoding the filenames. I am sure this is a
>> tremendous waste of time.
>I provide a non-trivial sql solution to this problem in this paper:
>How to Use Proc SQL select into for List Processing
>send e-mail with
>subject: request HOW-SQL ProcSQL-select-into-list-from-filenames.sas
>Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov