Data visualization with SAS programming

SAS graph worsksheet for a set of graphs

Accepted Solution Solved
Reply
Highlighted
Frequent Contributor
Posts: 94
Accepted Solution

SAS graph worsksheet for a set of graphs

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


Accepted Solutions
Solution
2 weeks ago
Super User
Posts: 19,116

Re: SAS graph worsksheet for a set of graphs

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

View solution in original post


All Replies
Solution
2 weeks ago
Super User
Posts: 19,116

Re: SAS graph worsksheet for a set of graphs

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

Frequent Contributor
Posts: 94

Re: SAS graph worsksheet for a set of graphs

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

Thanks,
Ana
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 104 views
  • 0 likes
  • 2 in conversation