Break page proc report ods rtf/pdf

[reznac]

Hello,

I have a dataset that  contain a breaking page , byte(12) , as shown bellow

data test;
attrib a length=$50; 
     a= "aaaa"; output;
     a=byte(12); output;
     a= "bbbb"; output;
     a=byte(12); output;
     a= "cccc"; output;
     a=byte(12); output;
     a= "dddd"; output;
 run ;
 
 
 proc report data=test ;
 col a;
 run ;

I use the proc report to display the dataset within an ods PDF / RTF

I would like to break the page when the a variable equal to byte(12) , but the proc report don’t do  that , it display only a blank space.

The are another way to break page by creating a _page variable and add  break before __page / page ; but it is not appropriate because it create a new section for each breaking page

Best regard

[RW9]

Hi,

Create a page variable containing the observations per page and break on that:

data test;
  length a $50; 
     a= "aaaa"; pge=1; output;
     a= "bbbb"; pge=1; output;
     a= "cccc"; pge=2; output;
     a= "dddd"; pge=2; output;
 run ;
  
proc report data=test ;
  col pge a;
  define pge / group noprint;  /* Or order instead of group */
  define a / "Avar";

  break after pge / page;
run;

[data_null__]

This is a very good question.  I don't know the answer.   One way might be to edit the RTF file I do that to remove paragraph marks in RTFs with embedded graphics.  There are 4 paragraph marks that are inserted, by something, that take up a lot of vertical space, but enough about that.

Another possibility might be to use PROC DOCUMENT but that may produce the same section breaks I don't know.

Hope you get a good answer that's easy.

It might be good to know your SAS version and OS.

[reznac]

sas version : 9.4 

os : hpux 

[data_null__]

This uses a data step to remove the section break but did not work unless I used ODS option BODYTITLE.  I don't know if this will be helpful.

data test;
   do page=1 to 2;
      do n = 0 to 4;
         length a $128;
         a = repeat('It is working? ',n);
         output;
         end; 
      end;
   run ;
ods rtf file='~/section.rtf' bodytitle;
title 'title1';
footnote 'Footnote 1';
proc report data=test ;
   col page a;
   define page / order noprint; 
   define a / "Avar";
   break after page / page;
   run;
   ods rtf close;
data _null_;
   infile '~/section.rtf' length=l lrecl=1024;
   file '~/section2.rtf' lrecl=1024;
   input;
   if find(_infile_,'sect\sectd\') then do;
      putlog _infile_;
      _infile_ = transtrn(_infile_,'\sect\sectd',trimn(' '));
      putlog _infile_;
      end;
   put _infile_;
   run;

[reznac · Accepted solution]

thank you for this solution 
i have another solution which consists to replace the byte(32) values by "^R'\pagebb'" as follow

ods rtf; 
data test;
attrib a length=$50; 
     a= "aaaa"; output;
     a=strip("^R'\pagebb'") ; output;
     a= "bbbb"; output;
     a=strip("^R'\pagebb'") ; output;
     a= "cccc"; output;
     a=strip("^R'\pagebb'") ; output;
     a= "dddd"; output;
 run ;

 
 proc report data=test ;
 col a;
 run ;
 ods rtf close ; 

best regard 

[data_null__]

I did not know about \pagebb.  But what about that weird blank cell on pages 2 and above.

[reznac]

it is rtf tag to break page 

we can do that alse within ods rtf 

ods rtf text="^R'\pagebb'"; we have the same result