importing 9 excel reports into SAS

[jflo36]

Hi everyone, I have 9 different reports in excel file format. I am trying to import all these reports into SAS and create one summary report for them. 6 of these reports are from the same folder and the rest are from separate folders, but they all have the same path. I am new to SAS. 

Thanks for your help!

[PaigeMiller]

This may be overkill, but you can use the %FOR macro for this purpose. The last example in this paper does the importing.

http://www.sascommunity.org/wiki/Streamlining_Data-Driven_SAS_With_The_%25FOR_Macro#Import_all_sprea...

Since you don't define what you mean by "summary report", I have no suggestions there.

[ballardw]

If all of those 9 reports came from the same source data you might consider bringing the raw data into SAS and then generating the reports and the summary from the same data.

We really would need to know what the individual rules are to discuss combining them.