The SAS Output Delivery System and reporting techniques

ODS tagsets.excelxp - how to add a free text comment?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

ODS tagsets.excelxp - how to add a free text comment?

I'm reporting some tables using ODS tagsets.excelxp and would like to add a free text note between some tables to the output file. For example, if I were using ODS PDF or ODS HTML, I would accomplish this using the code: ODS HTML TEXT="type my note here", but it seems that no similar statement exists using XML(?) I would prefer to use a statement like this in favor of a simple footnote because: 1) I already have footnotes in the document and would like to keep this separate, and 2) the footnotes appear at the bottom of the sheet, whereas I would like to add a note below one specific table. Any tips on adding a free text note like this would be greatly appreciated!


Accepted Solutions
Solution
‎07-03-2014 03:08 PM
SAS Employee
Posts: 87

Re: ODS tagsets.excelxp - how to add a free text comment?

The ExcelXP tagset does not currently support  TEXT=  as the other destinations such as HTML, PDF and RTF. You can try using the DATA step. What version of SAS are you using?

View solution in original post


All Replies
Solution
‎07-03-2014 03:08 PM
SAS Employee
Posts: 87

Re: ODS tagsets.excelxp - how to add a free text comment?

The ExcelXP tagset does not currently support  TEXT=  as the other destinations such as HTML, PDF and RTF. You can try using the DATA step. What version of SAS are you using?

Occasional Contributor
Posts: 14

Re: ODS tagsets.excelxp - how to add a free text comment?

9.3. Thanks for the idea-- I will try using a data step with a PUT

SAS Super FREQ
Posts: 8,642

Re: ODS tagsets.excelxp - how to add a free text comment?

Hi:

  If you use PROC REPORT, you can use a COMPUTE block to put ancillary text into a table (at the bottom or top of the table, as shown if you run the code below.

Cynthia

ods tagsets.excelxp file='c:\temp\addtext_xp.xml' style=sasweb

  options(doc='Help');

  

title 'This is the Title';

footnote 'This is the Footnote';

  

proc report data=sashelp.class(obs=5) nowd;

  column name age sex height weight;

  compute after / style={just=l fontweight=bold fontsize=10pt color=green };

     line "This note is part of the table.";

  endcomp;

run;

ods _all_ close;

New Contributor
Posts: 4

Re: ODS tagsets.excelxp - how to add a free text comment?

Please help me to find the solution for plain text. i don't have any dataset to print there. i only want to print the text. thanks

SAS Employee
Posts: 87

Re: ODS tagsets.excelxp - how to add a free text comment?

The new pre-production Excel destination which is available beginning in SAS 9.4M1 does support the ODS TEXT= statement, however, I realize that this will not help in this instance.

Post a Question
Discussion Stats
  • 5 replies
  • 1234 views
  • 6 likes
  • 4 in conversation