Date:         Fri, 21 Apr 2006 06:15:50 GMT
Reply-To:     LWn <lars.wahlgren.pleasenospam@STAT.LU.SE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         LWn <lars.wahlgren.pleasenospam@STAT.LU.SE>
Organization: Telia Internet
Subject:      Re: Cumulative Sum
Comments: To: sas-l@uga.edu

<nevin.krishna@gmail.com> skrev i meddelandet
news:1145589873.715595.272310@v46g2000cwv.googlegroups.com...
> hi mindy,
>
> data new;
>  set test;
>    by group var;
>      retain cusum 0;
>    if first.var then do;
>       cusum=0;
>    end;
>      cusum+number;
>    if last.var;
> run;
> proc print data=new;
> run;
>

You actually don't even need the retain statement.
Test this:

data new;
  set test;
    by group var;
    if first.var then cusum=0;
    cusum+number;
*    if last.var;
run;

/ LWn