topic Re: Copy sheets from two different excel files into one file in ODS and Base Reporting

Copy sheets from two different excel files into one file

_22 — Thu, 09 May 2019 20:06:54 GMT

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.

Re: Copy sheets from two different excel files into one file

Tom — Thu, 09 May 2019 20:34:49 GMT

How is this a SAS question?

Re: Copy sheets from two different excel files into one file

_22 — Thu, 09 May 2019 20:40:11 GMT

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

Re: Copy sheets from two different excel files into one file

Reeza — Thu, 09 May 2019 20:41:39 GMT

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.

Re: Copy sheets from two different excel files into one file

_22 — Thu, 09 May 2019 20:46:08 GMT

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

Re: Copy sheets from two different excel files into one file

Reeza — Thu, 09 May 2019 21:40:42 GMT

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.

Re: Copy sheets from two different excel files into one file

_22 — Thu, 09 May 2019 21:41:50 GMT

you please share the link of the macro here/

Re: Copy sheets from two different excel files into one file

Reeza — Thu, 09 May 2019 22:09:30 GMT

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

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