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

[ashlicole]

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!

[Chevell_sas · Accepted solution]

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?

[ashlicole]

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

[Cynthia_sas]

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;

[surajdvpatil]

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

[Chevell_sas]

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.