topic proc report column statement in SAS Programming

proc report column statement

Takamini — Fri, 08 Sep 2017 02:13:12 GMT

How do I prevent two column overlap?
This caused the detail are not able to read.

As the below picture, the "D" from first column overlapping the word from second column,

This is the program how I report this:

PROC REPORT DATA=data NOWD
COLWIDTH=8 SPACING=2
CENTER
HEADSKIP
SPLIT= '|'
LS=256
contents="Report";
COLUMNS A B;
DEFINE A /left style=[cellwidth=20mm] 'A';
DEFINE B /left style=[cellwidth=20mm] 'B';
RUN;

Re: proc report column statement

RahulG — Fri, 08 Sep 2017 02:50:11 GMT

try to add just = center and increase cell width

DEFINE A /left style={just = center cellwidth=40mm} 'A';

Re: proc report column statement

Takamini — Fri, 08 Sep 2017 02:57:54 GMT

Thank you, but this code only align the name of column to left and the contents still over lap.

In fact, I set up 140mm for my real data.

The code was just example.

Re: proc report column statement

Reeza — Fri, 08 Sep 2017 03:34:17 GMT

@Takamini wrote:

Thank you, but this code only align the name of column to left and the contents still over lap.

In fact, I set up 140mm for my real data.

The code was just example.

Ok, can you provide data and code we can use to replicate the issue then?

You should be able to increase the width and have the contents not overlap or are you looking for different functionality?

Re: proc report column statement

Ksharp — Fri, 08 Sep 2017 13:17:57 GMT

Try style cellpadding=


DEFINE A /left style=[cellwidth=20mm  cellpadding=100px  ] 'A';