tagsets excelxp and justified titles

[Jennys]

Hi

I have a report that goes into excel with tagsets.exelxp, with that report I have a title that contain a name and a date. The first part should be aligned to the left and the date align to the right. It works fine in ods html, but in excel it writes the first part on one line and the second part is written on the next row. Is it possible to get this title on the same row?

ods tagsets.excelxp file="D:\temp\toc.xls" style=statistical
options(embedded_titles='yes');

ods html file = 'test.html';
title j=l "left2" j=r "Right";

proc print data=sashelp.class(obs = 20); run;
ods html close;

ods tagsets.excelxp close;

best regards
Jenny

[Cynthia_sas]

Hi:
For TAGSETS.EXCELXP, the HTML methods do not work. However, TAGSETS.EXCELXP has PRINT Header and PRINT Footer sub-options with examples of how to make them work. To see the sub-options...
[pre]
ods tagsets.excelxp file='xxx.xml' style=sasweb
options(Doc='Help');
.... ... more code;
ods tagsets.excelxp close;
[/pre]

Then look in the SAS log for the print header related options.

cynthia

[Jennys]

Thanks a lot.

-jenny-