The SAS Output Delivery System and reporting techniques

tagsets excelxp and justified titles

Reply
Contributor
Posts: 34

tagsets excelxp and justified titles

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
SAS Super FREQ
Posts: 8,868

Re: tagsets excelxp and justified titles

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
Contributor
Posts: 34

Re: tagsets excelxp and justified titles

Posted in reply to Cynthia_sas
Thanks a lot.

-jenny-
Ask a Question
Discussion stats
  • 2 replies
  • 254 views
  • 0 likes
  • 2 in conversation