Date:         Mon, 30 Oct 2006 13:24:18 -0800
Reply-To:     junkmail115@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         junkmail115@GMAIL.COM
Organization: http://groups.google.com
Subject:      Merging Multiple Datasets With Sequential File Names
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

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