topic Re: How to sum element from n and below in SAS Programming

How to sum element from n and below

desireatem — Fri, 10 Jan 2014 00:49:42 GMT

data CP;

input t ;

cards;

I want to create variable sum where sum add the number from n and below like this:

2 Sum=2+2+3+2+4

2 Sum= 2+3+2+4

3 Sum= 3+2+4

2 Sum= 2+4

4 Sum=4

2) And how Do I do this. I want to add 2, 2(2) t the terms in t as I go dowm. Creating variable m.

data AA;

input t;

cards ;

data AA;

input t m;

cards ;

1 1+2

1 1+2(2)

1 1+3(2)

1 1+4(2)

Thanks

Re: How to sum element from n and below

art297 — Fri, 10 Jan 2014 01:11:06 GMT

data CP;

input t;

recnum=_n_;

cards;

;

proc sort data=cp out=aa;

by descending recnum;

run;

data aa;

set aa;

sum+t;

run;

proc sort data=aa (drop=recnum);

by descending sum;

run;

data bb;

input t;

m=t+_n_*2;

cards ;

;

Re: How to sum element from n and below

desireatem — Fri, 10 Jan 2014 01:22:26 GMT

Thanks thanks a lot can I do I preserve the order?

Re: How to sum element from n and below

art297 — Fri, 10 Jan 2014 01:25:24 GMT

I'm confused! I thought the code I suggested DID preserve the order in both cases.

Re: How to sum element from n and below

desireatem — Fri, 10 Jan 2014 01:26:39 GMT

The second code is good, this is the output of the first

The SAS System

1	4	5	4
2	2	4	6
3	3	3	9
4	2	2	11
5	2	1	13

Re: How to sum element from n and below

desireatem — Fri, 10 Jan 2014 01:29:28 GMT

you are correct. Thanks