PROC REPORT Header horizontal line

JohnChen_TW — Fri, 08 Sep 2017 02:05:18 GMT

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;

Re: PROC REPORT Header horizontal line

ChrisNZ — Fri, 08 Sep 2017 04:12:50 GMT

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

Re: PROC REPORT Header horizontal line

Ksharp — Fri, 08 Sep 2017 13:19:27 GMT

An alternative is using PROC TABULATE

topic Re: PROC REPORT Header horizontal line in SAS Programming

PROC REPORT Header horizontal line

Re: PROC REPORT Header horizontal line

Re: PROC REPORT Header horizontal line