BookmarkSubscribeRSS Feed
Jennys
Calcite | Level 5
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
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
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
Calcite | Level 5
Thanks a lot.

-jenny-

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 911 views
  • 0 likes
  • 2 in conversation