Date:         Fri, 16 Jan 2004 16:16:23 -0500
Reply-To:     Quentin McMullen <quentin_mcmullen@BROWN.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Quentin McMullen <quentin_mcmullen@BROWN.EDU>
Subject:      Re: Proc Report line highlighting

Sorry folks, please ignore my question.

If I had been keeping up on my SAS-L required reading, I would have gotten
the answer from Don Stanley's post a couple days ago.

Looks like I just mucked up the case or something when I tried to get this
to work.  Changing my if statement to:
    if (mod(count,2) and _break_ ne '_RBREAK_') then do;

gets it to work.

--Q.

On Fri, 16 Jan 2004 14:57:03 -0500, Quentin McMullen
<quentin_mcmullen@BROWN.EDU> wrote:

>Hi All,
>
>Below example shows simple highlighting of alternate rows (thanks to SAS-L
>archives posts by Pass, Haworth etc.).
>
>The 5th row of the table holds the totals.  I want to force this row to be
>background=white, even if thought the 4th row is also background=white.
>
>I guess I want to change the compute block to something like "if (mod
>(count,2)) and NOT last then do;".  Anyone wanna share an easy way for
>doing this?  I had thought _break_ might hold the answer but didn't get
>too far.  In this case I know I could change to "if NOT (mod(count,2))",
>but can't count on there always being an even number of rows.
>
>data a;
>  do id='Joseph','John','Joe','Judy';
>    score=10;
>    output;
>  end;
>run;
>
>ods rtf file='c:\junk\me.rtf' style=minimal;
>proc report data=a nowd;
>  column id score;
>  define id / group;
>  define score /analysis;
>  compute id;
>    count++1;
>    if (mod(count,2)) then do;
>      CALL DEFINE(_ROW_, "STYLE","STYLE=[BACKGROUND=ligr]");
>    end;
>  endcomp;
>  rbreak after / summarize;
>  compute after;
>    id="Total:";
>  endcomp;
>run;
>ods rtf close;
>
>Happy Friday,
>--Quentin