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!
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?
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?
9.3. Thanks for the idea-- I will try using a data step with a PUT
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;
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.