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
http://www.pnwsug.com/Conference_2006/Procedings/PNWSUGotherfiles/PN12Fe
hdSQL.pdf

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