Aaron,

I have a macro that does this very thing but my file names were listed as "file1" file2 ... file328 ... file1551. The counter in my macro would have to be tweaked to get you your file001 file002 and such. I'm not on a machine that has a SAS license today but I can send you my code now if you'd like.

hth,

Michael.

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of junkmail115@GMAIL.COM Sent: Thursday, November 02, 2006 10:04 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Merging Multiple Datasets With Sequential File Names

Either. There are 1770 files in text format and in SAS format.

"data _null_;" wrote: > SAS data sets or external files? > > On 10/30/06, junkmail115@gmail.com <junkmail115@gmail.com> wrote: > > I'm in need of some advice from a SAS guru. > > > > Is there a way to merge multiple files, which have a sequential naming > > convention (file001, file002, file 003 etc), into a master table that > > also creates a new variable derived from number in the file name? > > > > for example: > > > > Variables > > Name Date Cost > > > > file001 > > A 1/2006 4.25 > > C 2/2004 4.23 > > > > file002 > > J 4/2003 2.34 > > K 7/2001 5.32 > > > > Then merge the files into a master table: > > > > Variables > > Name Date Cost FileNum > > A 1/2006 4.25 001 > > C 2/2004 4.23 001 > > J 4/2003 2.34 002 > > K 7/2001 5.32 002 > > > > Anyone have a quick solution for me? > > > > Thanks Much, > > > > Aaron > >