ODS HTML and excel output

[deleted_user]

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?

[sbb]

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.

[Cynthia_sas]

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

[deleted_user]

Many thanks to all of you!