DATA Step, Macro, Functions and more

PROC REPORT Header horizontal line

Reply
Frequent Contributor
Posts: 76

PROC REPORT Header horizontal line

[ Edited ]

Hi everyone,

It's John again for PROC REPORT horizontal line in the header.

I'm using 9.3.

Does anyone have a suggestion on how to get rid of the horizontal lines in the red box as below?

Here is the output:

example2.png

 

Here is my code:

DATA have; LENGTH A1-A7 $1; RUN;

PROC REPORT DATA=have NOWD;
TITLE "EXAMPLE";
COLUMN (A1 ('Area 1' ("Group 1" ('Sub-G1' A2) ('Sub-G2' A3)) ("Group 2" ('Sub-G1' A4) ('Sub-G2' A5)) ("Group 3" ('Sub-G1' A6) ('Sub-G2' A7))));
DEFINE A1 /Style=[cellwidth=30mm] "Variable";
DEFINE A2 /Style=[cellwidth=20mm] "count";
DEFINE A3 /Style=[cellwidth=20mm] "count";
DEFINE A4 /Style=[cellwidth=20mm] "count";
DEFINE A5 /Style=[cellwidth=20mm] "count";
DEFINE A6 /Style=[cellwidth=20mm] "count";
DEFINE A7 /Style=[cellwidth=20mm] "count";
RUN;

 

PROC Star
Posts: 1,760

Re: PROC REPORT Header horizontal line

Posted in reply to JohnChen_TW

Not an answer to your question, but proc tabulate would create the output you want.

Super User
Posts: 10,046

Re: PROC REPORT Header horizontal line

Posted in reply to JohnChen_TW
An alternative is using PROC TABULATE


Ask a Question
Discussion stats
  • 2 replies
  • 101 views
  • 0 likes
  • 3 in conversation