topic Re: ODS tagsets.excelxp - how to add a free text comment? in ODS and Base Reporting

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

ashlicole — Thu, 03 Jul 2014 18:21:31 GMT

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!

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

Chevell_sas — Thu, 03 Jul 2014 19:08:06 GMT

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?

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

Cynthia_sas — Thu, 03 Jul 2014 19:10:02 GMT

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;

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

ashlicole — Thu, 03 Jul 2014 19:34:28 GMT

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

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

Chevell_sas — Mon, 07 Jul 2014 13:41:36 GMT

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.

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

surajdvpatil — Wed, 09 Sep 2015 02:37:30 GMT

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