DATA Step, Macro, Functions and more

proc report column statement

Reply
Occasional Contributor
Posts: 12

proc report column statement

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,

未命名.png

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;

Super Contributor
Posts: 271

Re: proc report column statement

try to add just = center and increase cell width

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

Occasional Contributor
Posts: 12

Re: proc report column statement

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.

Super User
Posts: 23,228

Re: proc report column statement


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?

Super User
Posts: 10,681

Re: proc report column statement

Try style cellpadding=


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

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