topic Gap when using bordercolor=white in proc report in SAS Procedures

Gap when using bordercolor=white in proc report

jtcowder — Tue, 01 Dec 2020 19:48:45 GMT

Using the code here : https://support.sas.com/kb/46/022.html

the output has a gap in the top/bottom borders

Is there a way to suppress the left/right cell border without having the white color cutting through the horizontal borders?

Re: Gap when using bordercolor=white in proc report

ballardw — Tue, 01 Dec 2020 20:01:35 GMT

It helps to show your code, including the ODS destination options.

I might suggest just trying the borderwidth=0 parts and not the border color settings for the suppressed borders.

Re: Gap when using bordercolor=white in proc report

Cynthia_sas — Wed, 02 Dec 2020 01:08:01 GMT

HI:
It looks like you're using PDF -- I agree with @ballardw -- using rules=none and cellspacing=0 or setting borderwidth to 0 might be a better alternative or try the Journal style to see if that gives you more what you want. There's a note in the Tech Support example that explains that bordercolor works best with RTF, which has also been my experience. It doesn't make sense to me why you would want to remove the border in that location anyway. But one way around it is to concatenate the values in both of those cells and then create one character value that is both individual values concatenated together. This is what is frequently done for demographic reports, such as the ones that have numbers formatted like 20 (15%) -- where you have the N and the PCTN together in one cell.

Cynthia