DATA Step, Macro, Functions and more

importing 9 excel reports into SAS

Reply
Occasional Contributor
Posts: 10

importing 9 excel reports into SAS

[ Edited ]

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!

Trusted Advisor
Posts: 1,908

Re: importing multiple excel into SAS

[ Edited ]

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.

Super User
Posts: 11,336

Re: importing multiple excel into SAS

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.

Ask a Question
Discussion stats
  • 2 replies
  • 158 views
  • 0 likes
  • 3 in conversation