topic Re: Full width compute after text, in narrow report in ODS and Base Reporting

Full width compute after text, in narrow report

SwissC — Fri, 19 Feb 2021 16:06:08 GMT

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.

Re: Full width compute after text, in narrow report

Cynthia_sas — Sat, 20 Feb 2021 21:04:35 GMT

Hi:
Anything you write with a LINE statement must stay within the boundary of the table. So what you want is not possible without stretching the entire table. The LINE statement cannot stretch from margin to margin if the table itself does not stretch from margin to margin. Or to put it another way, the report table cannot be 4 inches wide but you want the LINE output to be 7 inches wide. Both have to be either 4 inches or 7 inches.

You should look at using regular FOOTNOTE statements or ODS TEXT statements to insert text after a table. The FOOTNOTE automatically is centered on the page width, not the table width. The ODS TEXT can be made to stretch from margin to margin. By default is it left justified, so you might need to change your template to format the ODS TEXT element to have the characteristics and justification you wanted.

Cynthia

Re: Full width compute after text, in narrow report

SwissC — Mon, 22 Feb 2021 08:08:43 GMT

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?

Re: Full width compute after text, in narrow report

Cynthia_sas — Mon, 22 Feb 2021 15:35:43 GMT

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