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!
This may be overkill, but you can use the %FOR macro for this purpose. The last example in this paper does the importing.
Since you don't define what you mean by "summary report", I have no suggestions there.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.