Extra table row appearing when table spans pages when using proc report and ods tagsets.rtf

[colleenbogucki]

Hello, 

I am using ods tagsets.rtf to print several outputs of proc report to a word document.  Everything is working well except an extra table row/page break appears whenever one of the tables spans multiple pages (pic below). 

It appears as a black rectangle at the top or bottom of the page then the rest of the table is either a page below or right below. It originally said "Continued" in it but I used the pretext="" code in the template to make it blank. Anybody know how to get rid of the actual box and space it takes up? I want no message of "continued" and no indication that the table was split, I just want the table to continue on the next page. 

I can't post the data. 

My template code: 

proc template;

      define style styles.siteprofile;

          parent=styles.sasweb;

          style Continued from Continued / 

              pretext=""; 

          style parskip / fontsize = 1pt;

      end;

run;

My ods code: 

ods tagsets.rtf file="filepath\file.rtf" startpage=off style=styles.siteprofile uniform;

    title "County1"; 

proc report data = county1._admin
     style(header)={background=aliceblue foreground=black};
     column administrative col1;
     define administrative / style(column)=[cellwidth=4.5in]
     style(header)=[just=l];;
     define col1 / '' style(column)=[cellwidth=2.5in];
run;

proc report data = county1._fund
    style(header)={background=aliceblue foreground=black};
    column funding col1;
    define funding / style(column)=[cellwidth=4.5in]
    style(header)=[just=l];
    define col1 / '' style(column)=[cellwidth=2.5in];
run;

proc report data = &county._rentasst
    style(header)={background=aliceblue foreground=black};
    column assistance col1;
    define assistance / style(column)=[cellwidth=4.5in]
    style(header)=[just=l];
    define col1 / '' style(column)=[cellwidth=2.5in];
run;

ods tagsets.rtf close;

I've also tried adding "class continued / width=0%" to the template and it just makes the box small, but the page break is still there. 

@Cynthia_sas

[ballardw]

Without your data can't test for identical behavior.

Did you try completely removing the Pretext line? Actually I would suggest removing the style parskip part as well to clear all definitions.

proc template;
      define style styles.siteprofile;
          parent=styles.sasweb;
          style Continued from Continued / 
          ;
      end;
run;

[colleenbogucki]

Thanks for the suggestion. If you run what you have, the word "Continued" still appears in the box and sometimes causes a page break. 

[ballardw]

Possibly using the wrong parent and that's why you still get the text "Continued". The best I come up with is

proc template;
      define style styles.siteprofile;
          parent=styles.sasweb;
          style Continued from TitlesAndFooters / 
          ; 
          style parskip / fontsize = 1pt;
      end;
run;

Which has no text but still displays a skinny box that most options I play with start inserting oddly spaced table breaks and still has a box of some sort.

However using ODS RTF and not TAGSETS.RTF the box doesn't appear though can't use the TAGSETS options like UNIFORM.

Maybe @Cynthia_sas has additional ideas

[Cynthia_sas]

Hi:

  My memory is that sometimes when both ODS RTF and ODS TAGSETS.RTF are finished writing the RTF file and the file from ODS is handed off to Word, it is possible for Word to mis-measure the page breaking and insert a blank page. I thought I remembered a Tech Support note about this, but I can't find it. I think it might be better for the OP to work with Tech Support on this question because TS can look at ALL their code and at their actual data and see if they can replicate the problem.

Cynthia

[Ksharp · Accepted solution]

Check option :
options( tables_off = "systitleandfootercontainer"
continue_tag = "no"
vspace = "no"
)
https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-TAGSET-RTF-place-footnote-in-same-location...

[colleenbogucki]

This worked!! Thank you so much.