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;
You need to add the option
sheet_interval="none"
to prevent the automatic creation of a new sheet for every procedure call.
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
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.
Ready to level-up your skills? Choose your own adventure.