Hello,
I am running a proc report that is going to an ods rtf file.
The table that is produced has a line on the top of the page as well as on the bottom of the page. It seems like this is the top and bottom border of the entire table. I cannot figure out how to remove this line.
Attached is part of the code and output. Please notice the line at the top of the page and the line on the bottom of the pages. Where are these coming from and how do I get rid of them?
Thank you for your help.
I'm gonna say the lines are coming from pretext="^R/RTF'\brdrb\brdrs\brdrw10 '"}; in your COMPUTE BEFORE _PAGE_ and COMPUTE AFTER _PAGE_ blocks.
Thanks for the response, however, when I tried that, the COMPUTE BEFORE _PAGE_ causes the 2nd line from the top to go away. The top line is still there.
Commenting out The COMPUTE AFTER _PAGE_ did not remove the bottom line.
???
I guess you're on your own.
I guess the problem might be here :
style=[frame=hsides rules=groups font_size=8 pt cellpadding=1pt]
style(header)={ protectspecialchars=off background=_undef_}
remove rules=groups,
also check frame=
Xia Keshan
Hi,
Without rules=groups, he will probably get the interior lines from the style template being used, I don't understand why MINIMAL is used instead of JOURNAL. FRAME=VOID would get rid of ALL the lines around the outside of the TABLE. A quick test would be to change his FRAME=HSIDES to FRAME=VSIDES -- I think the line on the VERY top and VERY bottom are put there by FRAME=HSIDES. With FRAME=VSIDES, what should happen (teaching, so not on a computer with SAS right now) is that the very top and very bottom lines move to the left and right sides of the table. RULES controls the interior table lines. So if he wants a line under the column headers before the data lines, then RULES=GROUP will do that (which is what the JOURNAL style sets automatically).
cynthia
Hi. Thanks all so much for the help.
Cynthia, I actually saw your post for something else (you have helped me on many other things as well - so thanks!) and figured out to use frame=hsides rules=groups cellspacing=0. This actually did remove the very top and very bottom lines. But as you mentioned, the line under the column headers before the data lines disappears.
A work around I found was a compute before, however, there is lots of space between the column headers and the line that is placed below.
compute before _page2 / style={just=l asis=on protectspecialchars=off pretext="^R/RTF'\brdrb\brdrs\brdrw10 '"};
endcomp;
Any ideas on how to get the line back in the proc report line? or how to get rid of the space from the compute text?
thanks.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.