export two proc-report-outputs per excel-sheet

Konkordanz — Fri, 12 May 2023 05:12:07 GMT

Hi,

I want to export my proc-report-outputs into a excel-file. What I not want is the result of following code. Each output gets its own spreadsheet.

What I want is: Both results of output1 should be exported into the spreadsheet "sex". And the both results of Output2 should be exported into the spreadsheet "age". I dont know how to get this result. I dont get it neither if I would use the same sheet_name per output. Why? Thank you for help!

/*Exportpath*/
ods excel file="...path\Ergebnisse.xlsx"

/*=====================================*/
/*==========  output1 ==================*/
/*=====================================*/


options(sheet_name="sex_sum" embedded_titles='Yes');

/*Absolut*/
proc report 
[...]
run;

ODS excel options(sheet_name="sex_rel" embedded_titles='Yes');

/*relative*/
proc report 
[...]
run;


/*=====================================*/
/*==========  output2 ==================*/
/*=====================================*/

options(sheet_name="age_sum" embedded_titles='Yes');

/*Absolut*/
proc report 
[...]
run;

ODS excel options(sheet_name="age_rel" embedded_titles='Yes');

/*relative*/
proc report 
[...]
run;

Re: export two proc-report-outputs per excel-sheet

Kurt_Bremser — Fri, 12 May 2023 06:14:57 GMT

You need to add the option

sheet_interval="none"

to prevent the automatic creation of a new sheet for every procedure call.

topic Re: export two proc-report-outputs per excel-sheet in SAS Programming

export two proc-report-outputs per excel-sheet

Re: export two proc-report-outputs per excel-sheet