SUM statement

desireatem — Sat, 11 Jan 2014 03:07:09 GMT

data CP;

input time A B;

cards;

1 . .

2 0 .1

2 .4 .7

3 .3 .5

5 .9 0

6 .3 .33

;

I want to create a third and fourth variable calle Asum and Bsum

where Asum= .+0+.4+.3+.9+.3

data CP;

input time A B Asum Bsum;

cards;

1 . . .+0+.4+.3+.9+.3 .+.1+.7+.5+0+.33

2 0 .1 0+.4+.3+.9+.3 1+.7+.5+0+.33

2 .4 .7 .4+.3+.9+.3 .7+.5+0+.33

3 .3 .5 .3+.9+.3 .5+0+.33

5 .9 0 .9+.3 0+.33

6 .3 .33 .3 .33

;

Re: SUM statement

PGStats — Sat, 11 Jan 2014 04:49:02 GMT

data CP;
input time A B;
cards;
1 .   .
2 0 .1
2 .4 .7
3   .3 .5
5   .9   0
6    .3 .33
;

data CPn;
set CP;
n = _n_;
run;

proc sort data=CPn; by descending n; run;

data want;
set CPn;
Asum + A;
Bsum + B;
run;

proc sort data=want out=want(drop=n); by n; run;