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