Hi SAS users,
I have 10 graphs in first work sheet & wanted help in displaying 10 more graphs in the second work sheet.
I tried multiple sheet_interval options like - page, table . they all were producing each work sheet for each graph. How to display all in the same second work sheet?
I tried "none" - it was printing in the first worksheet itself.
ods excel
options(
sheet_interval="page"
sheet_name="bar Graphs"
);
proc sgpanel -1
proc sgpanel -2
proc sgpanel -3
etc
Thanks,
Ana
You need none and then to start another page manually.
There used to be a bug in this, but it has a workaround.
The solution is on here - I posted it from a SAS blog link.
https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-excel-amp-multiple-sheets/td-p/261953
You need none and then to start another page manually.
There used to be a bug in this, but it has a workaround.
The solution is on here - I posted it from a SAS blog link.
https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-excel-amp-multiple-sheets/td-p/261953
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.