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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.