The SAS Output Delivery System and reporting techniques

ODS HTML and excel output

Reply
N/A
Posts: 0

ODS HTML and excel output

how can i create two outputs? One html and one excel. I am using the tagset tableeditor.
ods tagsets.tableeditor file= "final.xls"
options(banner_color_odd="#CCFFCC"
banner_color_even="WHITE");

The prob is I also need an html file. Is there a way I can use two ods tagsets?
Super Contributor
Super Contributor
Posts: 3,174

Re: ODS HTML and excel output

Have a look at the (ID=n) parameter coded on the ODS HTML statement, permitting two different output destinations with a single PROC/DATA step execution.

Scott Barry
SBBWorks, Inc.
SAS Super FREQ
Posts: 8,744

Re: ODS HTML and excel output

Hi:
Sorry, I misread your original post. The ID suboption allows you to create 2 files at once using the same destination. You can use an identifier within parentheses immediately after the destination name. The "ID=" is optional and the identifying string can be text or numbers --without quotes.
cynthia
[pre]

ods tagsets.tableeditor(one) file='te1.xls' ....;
ods tagsets.tableeditor(ID=2) file='te2.xls' ....;



ods _all_ close;
[/pre]
cynthia
N/A
Posts: 0

Re: ODS HTML and excel output

Many thanks to all of you!
Ask a Question
Discussion stats
  • 3 replies
  • 106 views
  • 0 likes
  • 3 in conversation