Date: Thu, 25 Jan 2007 16:22:44 -0500
Reply-To: "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject: Re: loop through all files in dir for inclusion in macro
Content-Type: text/plain; charset="us-ascii"
> 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