topic Re: Extra lines in proc report in ODS and Base Reporting

Extra lines in proc report

nsns — Wed, 28 Jan 2015 19:14:55 GMT

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.

Re: Extra lines in proc report

data_null__ — Wed, 28 Jan 2015 19:33:32 GMT

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.

Re: Extra lines in proc report

nsns — Wed, 28 Jan 2015 20:18:14 GMT

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.

???

Re: Extra lines in proc report

data_null__ — Wed, 28 Jan 2015 20:22:34 GMT

I guess you're on your own.

Re: Extra lines in proc report

Ksharp — Thu, 29 Jan 2015 07:17:47 GMT

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

Re: Extra lines in proc report

Cynthia_sas — Thu, 29 Jan 2015 13:02:22 GMT

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

Re: Extra lines in proc report

nsns — Thu, 29 Jan 2015 14:00:58 GMT

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.