SUM statement

Reply
Super Contributor
Posts: 303

SUM statement

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

;

Respected Advisor
Posts: 4,919

Re: SUM statement

Posted in reply to desireatem

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;

PG

PG
Ask a Question
Discussion stats
  • 1 reply
  • 168 views
  • 2 likes
  • 2 in conversation