topic Re: ODS HTML and excel output in ODS and Base Reporting

ODS HTML and excel output

deleted_user — Mon, 21 Jul 2008 02:31:57 GMT

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?

Re: ODS HTML and excel output

sbb — Mon, 21 Jul 2008 03:00:04 GMT

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.

Re: ODS HTML and excel output

Cynthia_sas — Mon, 21 Jul 2008 03:23:55 GMT

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

Re: ODS HTML and excel output

deleted_user — Mon, 21 Jul 2008 07:22:14 GMT

Many thanks to all of you!