Hi,
I have a fairly narrow report, with just 3 short columns. However I want to add a longer piece of text at the end. Below is some partial code.
proc template;
define style styles.myrtf;
parent=styles.rtf;
style Table from output /
Background=_UNDEF_
Rules=groups
Frame=above
OUTPUTWIDTH=_undef_
CELLPADDING=0
CELLSPACING=0
bordertopstyle=solid
bordertopcolor=black;
end;
run;
PROC REPORT data=adsl nowd headline headskip missing split='#';
COLUMNS subjid arm trtsdt ;
DEFINE subjid / order order=data " " style={just=l cellwidth=4cm asis=on};
DEFINE arm / style={just=l cellwidth=4cm asis=on};
DEFINE trtsdt / style={just=l cellwidth=4cm asis=on };
COMPUTE after _page_;
LINE j=l "xxx xxxxxxxx xx xxx xxxxxx xxxxxxxxx xxx xxxxxxxxxx, xx xxx 1 xx xxxxx xxx xx xxxxxxxxx xxxxxx. xxxxxxxx xxxx xx xxxxxxxxx xxxxxx xx xx xxxxxxxx xxxx xxx xxxxxxxx xx xxx 1,";
ENDCOMP;
RUN;
Now the table can be quite long, and we are using the compute after to add footnotes as we have a lot of them. Hence I would like to be able to span these the full of the page. I know I could set outputwidth=100% in the template, but this would also stretch the 3 columns over the full width of the page. Is there any way around this?
n.b. I know I am missing the ODS RTF statements, but these are in company macros so I removed them for clarity.
Thanks for the reply Cynthia,
Unfortunately I have a multiple page table with >10 footnotes so the FOOTNOTE option will not work. Is there any way to get an ODS TEXT statement to print into the footer of the RTF so that it appears on each page?
Hi:
No, ODS TEXT strings appear only where placed-- essentially at the top of bottom of output, but not in the header or footer of the document. However, you can get more than 10 footnotes in a document using the ESCAPECHAR + {newline}. But, as shown below, 20 TITLES and 20 FOOTNOTES don't leave much room for anything else in the report.
Cynthia
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.
Ready to level-up your skills? Choose your own adventure.