How to import multiple excel files residing in a SAS folder?

[Rish]

Currently I import daily excel files with different dates and then merge them into one big montlhy file. I read on the forum that I can use a macro to automate the process. I am not well versed with macro's, can somebody please shed some light? Thanks

File - 1

Proc IMPORT OUT= Test1 

DATAFILE= "/sas/data_20131101.xls"           

DBMS=xls REPLACE;         

sheet = 7061_newdata;           

GETNAMES=YES; MIXED=YES;

run;

File - 2

Proc IMPORT OUT= Test1 

DATAFILE= "/sas/data_20131102.xls"           

DBMS=xls REPLACE;         

sheet = 7061_newdata;            

GETNAMES=YES; MIXED=YES;

run;

[Reeza]

There's some macros on the support.sas.com site.

So googling will find you answers

Here's an example for TXT files, perhaps you can modify it for Excel files.  But I'm pretty sure there's one specifically for Excel on there.

24707 - Reading multiple files with PROC IMPORT