Copy sheets from two different excel files into one file

[_22]

I have a template file having 2 sheets. Also, I have a output file having 3 sheets. I want to copy or move these sheets from each files into a new single file having 5 sheets. 

[Tom]

How is this a SAS question?

[_22]

I mean by using SAS ODS or any other way where I can move these sheets into my final excel using SAS

[Reeza]

Redesign your process such that you take your template, make a copy of it (FCOPY() function) and then export your three sheets straight to that copy instead. 

---

@_22 wrote:

I have a template file having 2 sheets. Also, I have a output file having 3 sheets. I want to copy or move these sheets from each files into a new single file having 5 sheets. 

---

[_22]

I did the same but the problem is --

I need to output proc compare result which i was output using ods excel in my second file. since this result is not in dataset format , i am stuck in the process of getting these results into new excel file

[Reeza]

Unfortunately I don't recommend using PROC COMPARE either, I usually generate those reports using my own macros. One is on GitHub that does the variable comparisons and I export that straight to Excel.

[_22]

 you please share the link of the macro here/

[Reeza]

What type of output do you need? This particular one just checks variables in each data set. 

https://gist.github.com/statgeek/e0b98c4627aa31a567e5