- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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:
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;
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;
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;
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the suggestion. If you run what you have, the word "Continued" still appears in the box and sometimes causes a page break.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content