topic Re: ODS rtf question in ODS and Base Reporting

ODS rtf question

Niugg2010 — Fri, 03 Feb 2017 05:21:10 GMT

Below is my code. The last page of rtf output has a blank table row title. How Can I remove that title? Thanks

title;
ods rtf file="C:\Users\XXXX\Desktop\111.rtf";
ods escapechar="^";
proc report data=sashelp.cars (obs=426);
column Make Model;
run;
ods rtf text="^S={leftmargin=1in}Dollar ^nsexcept
as ^naaano^ntedas ^nno^ntedas ^nno^ntedas ^nno^ntedas ^nno^ntedas ^nno^nte";
ods rtf close;

Re: ODS rtf question

RW9 — Fri, 03 Feb 2017 09:43:19 GMT

The reason you have the extra page is because you output an rtf text statement after your procedure. What are you triying to do with that text field? Why not just put it in a footnote?

Re: ODS rtf question

Niugg2010 — Fri, 03 Feb 2017 11:42:32 GMT

The shell requires that.

Re: ODS rtf question

BrunoMueller — Fri, 03 Feb 2017 13:22:03 GMT

As an alternate method you could make use of the "COMPUTE AFTER" block. Using this method the text is written as part of the table, and is therefor part of the table measuring, see sample code below

title;
ods rtf file="C:\temp\rtf111.rtf";
ods escapechar="^";
proc report data=sashelp.cars (obs=36) nocenter;
column rowid Make Model;
define rowid / computed;
compute rowid;
  _rowId + 1;
  rowId = _rowId;
endcomp;

compute after / style={just=left};
  length msgline $ 1024;
  msgline = "line1 ^n line2 ^n line3  ^n line 4 ^n line 5 ^n line 6";
  l = length(msgline);
  line msgLine $varying1024. l;
endcomp;
run;
/*ods text="^S={leftmargin=1in}line1 ^n line2 ^n line3  ^n line 4 ^n line 5 ^n line 6";*/
ods rtf close;

Bruno