Date:         Tue, 1 Aug 2006 09:38:38 -0700
Reply-To:     Poohbear <liuberyl@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Poohbear <liuberyl@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Need help, thanks in advance!!
Comments: To: sas-l@uga.edu
In-Reply-To:  <1154449849.697900.8510@m73g2000cwd.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

More information about the project:

all csv files I have are named this way: (a dummy number)_(file
type).csv
where the dummy numbers are totally random, we have these csv files
each month, all numbers are different for each month.
the file type are different for two report types, i.e., there are two
file types.

In each csv file, there is a variable named 'agency_id', and this id
value are not same for each file.
i.e., I have 300 csv files, there are 300 id values.

what I need to do is, replace the dummy number in each file name with
the id value for that file. so that I don't need to open each file to
see which agency the file belongs to.

And, I am using SAS 9.1 under Windows XP OS.

Thanks!
Pooh

Poohbear wrote:
> Hi all,
>
> I am still working on the project, and did not figure it out yet.
> I don't know how to read 300 csv files sequentially and get  variable
> value from each
> file?? Also, the number of variables are different from each csv
> file! ...... Anyone has any idea? :(
>
>
> Thanks a lot,
> Pooh