BookmarkSubscribeRSS Feed
nsns
Obsidian | Level 7

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.





6 REPLIES 6
data_null__
Jade | Level 19

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.

nsns
Obsidian | Level 7

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.

???

data_null__
Jade | Level 19

I guess you're on your own.

Ksharp
Super User

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

Cynthia_sas
SAS Super FREQ

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

nsns
Obsidian | Level 7

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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 4011 views
  • 0 likes
  • 4 in conversation