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.
How is this a SAS question?
I mean by using SAS ODS or any other way where I can move these sheets into my final excel using SAS
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.
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
you please share the link of the macro here/
What type of output do you need? This particular one just checks variables in each data set.
https://gist.github.com/statgeek/e0b98c4627aa31a567e5
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.