|
Yufei,
Dependent upon the structure of your access databases, the task could be
as simple as something like:
%macro getfiles;
%do i=1 %to 128;
libname county&i. access "C:\temp\NY_county&i..mdb";
%end;
data want;
set
%do i=1 %to 128;
county&i..table1
%end;
;
run;
%mend;
%getfiles
Art
--------
On Mon, 9 Jul 2007 17:18:47 -0400, Yufei Wang <yufeiw@GMAIL.COM> wrote:
>Is it same as importing multiple excel files to SAS?
>like Wenshui's blog shows:
>http://statcompute.blogspot.com/2005/09/read-multiple-excel-files-in-sas-
using.html
>My problem is the files are not in the same director. The access file
stores
>the attribute data for each county in each countie's directory, like this:
>C:\temp\NY_county1\*.mdb
>C:\temp\NY_county2\*.mdb
>C:\temp\NY_county3\*.mdb
>C:\temp\NY_county3\*.mdb
>C:\temp\NY_county4\*.mdb
>........
| 
