topic Re: SAS graph worsksheet for a set of graphs in Graphics Programming

SAS graph worsksheet for a set of graphs

SASAna — Mon, 02 Oct 2017 18:03:56 GMT

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

Re: SAS graph worsksheet for a set of graphs

Reeza — Mon, 02 Oct 2017 18:22:21 GMT

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

Re: SAS graph worsksheet for a set of graphs

SASAna — Wed, 04 Oct 2017 06:47:40 GMT

Thanks Reeza, It worked so perfectly. Thanks for helping me out.

Thanks,
Ana