The SAS Output Delivery System and reporting techniques

ODS rtf question

Reply
Frequent Contributor
Posts: 90

ODS rtf question

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;

 


aaa.jpg
Super User
Super User
Posts: 7,942

Re: ODS rtf question

Posted in reply to Niugg2010

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?

Frequent Contributor
Posts: 90

Re: ODS rtf question

The shell requires that.  

SAS Super FREQ
Posts: 708

Re: ODS rtf question

Posted in reply to Niugg2010

Hi

 

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

Ask a Question
Discussion stats
  • 3 replies
  • 155 views
  • 0 likes
  • 3 in conversation