BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SASAna
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

2 REPLIES 2
Reeza
Super User

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

SASAna
Quartz | Level 8
Thanks Reeza, It worked so perfectly. Thanks for helping me out.

Thanks,
Ana

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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