PROC REPORT Header horizontal line

[JohnChen_TW]

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:

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;

[ChrisNZ]

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

[Ksharp]

An alternative is using PROC TABULATE