topic Re: Cumulative Sum over Row in SAS Programming

Cumulative Sum over Row

MarkusB — Tue, 18 Feb 2020 18:10:55 GMT

Hi,

I have quite a simple question. My data is:

v1	v2	v3
100	200	250

Now, I want to calculate the cumulative sum over the row to get:

c1	c2	c3
100	300	550

How do I do that?

Any help would be greatly appreciated!

Re: Cumulative Sum over Row

PaigeMiller — Tue, 18 Feb 2020 18:16:00 GMT

You can use ARRAYs.

data want;
    set have;
    array v v1-v3;
    array c c1-c3;
    do i=1 to dim(v);
        if i=1 then c(i)=v(i);
        else c(i)=sum(c(i-1),v(i));
    end;
run;

Re: Cumulative Sum over Row

novinosrin — Tue, 18 Feb 2020 18:14:23 GMT


data have;
input v1	v2	v3;
cards;
100	200	250
;

data want;
 set have;
 array t v:;
 do _n_=2 to dim(t);
  t(_n_)=sum(t(_n_),t(_n_-1));
 end;
run;

Re: Cumulative Sum over Row

MarkusB — Mon, 24 Feb 2020 09:02:38 GMT

Great, thank you all for the solutions!