The SAS Output Delivery System and reporting techniques

Extra lines in proc report

Reply
Contributor
Posts: 20

Extra lines in proc report

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.





Respected Advisor
Posts: 3,786

Re: Extra lines in proc report

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.

Contributor
Posts: 20

Re: Extra lines in proc report

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.

???

Respected Advisor
Posts: 3,786

Re: Extra lines in proc report

I guess you're on your own.

Super User
Posts: 9,856

Re: Extra lines in proc report

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

SAS Super FREQ
Posts: 8,815

Re: Extra lines in proc report

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

Contributor
Posts: 20

Re: Extra lines in proc report

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.


Ask a Question
Discussion stats
  • 6 replies
  • 1104 views
  • 0 likes
  • 4 in conversation