topic Re: Combining Two different SAS Reports into excel in different tabs in SAS Procedures

Combining Two different SAS Reports into excel in different tabs

SreekanthRao — Thu, 08 Jan 2015 12:11:29 GMT

Dear All,

I have a question related to proc report. I have a business case as below.

1) I have a report called sales which outputs to excel using tagsets

it contains three tabs

sales by country-tab1,

sales by region-tab2,

overall sales-tab3

The above output is generated based out of one SAS program.

2) I have a report called Growth/Decline Sales which outputs to excel using tagsets

-it contains two tabs

sales Growth/Decline country-tab1,

sales Growth/Decline by region-tab2,

Growth/Decline overall sales-tab3

The above output is generated based out of one SAS program.

Question:I want to combine these two different SAS reports and the resultant report should contain 6 excel tabs in a single excel(3 from program1 and 3 from program2).

Kindly advice.If someone could explain with example that would be really great.

Thanks all for your wonderful help in Advance.

Wish you all a very very happy new year.

Sreekanth:)

Re: Combining Two different SAS Reports into excel in different tabs

RW9 — Thu, 08 Jan 2015 13:46:51 GMT

Output from ODS continues through a program until it is closed. Hence if you put:

ods tagsets.excelxp file=...;

Near the top of your program, and then do your reports outputting to a new tab each report. Then right at the end ods tagsets.excelxp close; it will all go out to the same file. So you will end up with one file with 6 tabs output.

Re: Combining Two different SAS Reports into excel in different tabs

Reeza — Thu, 08 Jan 2015 13:55:08 GMT

Basically make your two programs one. You can use %include if needed, as long as you remove ODS TAGSETS FILE commands from each one.

E.G.

ODS TAGSETS.EXCELXP File=" " options(.....) style=journal;

*first program;

%include 'my_report1.sas';

*second program;

%include 'my_report2.sas';

ODS TAGSETS.EXCELXP close;