Date: Thu, 18 Apr 2002 12:35:07 -0400
Reply-To: vijaya vellanki <i_vijaya@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: vijaya vellanki <i_vijaya@HOTMAIL.COM>
Subject: Proc Report Q
Content-Type: text/plain; format=flowed
Hi all:
I am missing the multiple rows of " E , F , G" using the below code.
following is the report I got.
A B C D
------------------------------------------------
10 20 30 40
E F G
---------------------------------
55 65 75
A B C D
------------------------------------------------
99 20 30 40
E F G
---------------------------------
50 60 70
data test;
input A B C D E $ F $ G $;
cards;
10 20 30 40 50 60 70
10 20 30 40 55 65 75
99 20 30 40 50 60 70
;
run;
options nocenter;
proc report nowd noheader;
col ( a b c d e f g);
define a / order ;
define b / order ;
define c / order ;
define d / order ;
define e / display noprint;
define f / display noprint;
define g / display noprint;
compute g;
if _break_ eq ' ' then do;
holde=e;
holdg=g;
holdf=f;
end;
endcomp;
compute before a;
/*line @1 '------------------------------------------------';*/
line @1 ' A B C D ';
line @1 '------------------------------------------------';
endcomp;
compute after a;
line @16 ' E F G';
line @16 '---------------------------------';
line @25 holde $8.+3 holdf $8. +3 holdg $8.;
endcomp;
break after a/skip;
run;
I need to get the above report as below using proc report.
A B C D
------------------------------------------------
10 20 30 40
E F G
---------------------------------
50 60 70
55 65 75
A B C D
------------------------------------------------
99 20 30 40
E F G
---------------------------------
50 60 70
Appreciate your help..
thanks,
Vijaya
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
