The SAS Output Delivery System and reporting techniques

Prevent Tabs on Multiple Print Requests

Reply
Super Contributor
Posts: 358

Prevent Tabs on Multiple Print Requests

Hi All:

Just a quick question to same me hours and hours of searching...

Is there a way to prevent the EXCELXP tagset from generating a new tab for each PROC REPORT that I have?

I'm generating a number of reports after I open the sheet, but the user wants them one after the other, rather than on separate tabs.

Thanks in advance.
SAS Super FREQ
Posts: 8,745

Re: Prevent Tabs on Multiple Print Requests

Hi:
Run your job with the sub-option for doc:
[pre]
ods tagsets.excelxp file='xxxx.xml' options(doc='Help');
[/pre]

and then look for the SHEET_INTERVAL sub-option. I believe that you can control whether a new tab starts by using that sub-option.

In addition, if you want more control over printing of the ExcelXP spreadsheet from within Excel, this is a very useful paper:
http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf

cynthia
Super Contributor
Posts: 358

Re: Prevent Tabs on Multiple Print Requests

Cynthia:

Genius, as always.

Thanks.
Ask a Question
Discussion stats
  • 2 replies
  • 96 views
  • 0 likes
  • 2 in conversation