topic Re: importing multiple excel into SAS in SAS Programming

importing 9 excel reports into SAS

jflo36 — Wed, 14 Oct 2015 16:35:06 GMT

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!

Re: importing multiple excel into SAS

PaigeMiller — Tue, 13 Oct 2015 21:39:31 GMT

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_spreadsheets_in_all_subfolders_of_a_top_folder

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

Re: importing multiple excel into SAS

ballardw — Tue, 13 Oct 2015 21:46:43 GMT

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.