BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
desireatem
Pyrite | Level 9

data CP;

input t ;

cards;

2

3

2

4

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

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 ;

1

1

1

1


to

data AA;

input t m;

cards ;

1  1+2

1   1+2(2)

1  1+3(2)

1  1+4(2)


Thanks


1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

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

View solution in original post

5 REPLIES 5
art297
Opal | Level 21

data CP;

  input t;

  recnum=_n_;

cards;

2

2

3

2

4

;

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 ;

1

1

1

1

;

desireatem
Pyrite | Level 9

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

art297
Opal | Level 21

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

desireatem
Pyrite | Level 9

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

The SAS System

      
1454
2246
3339
42211
52113

desireatem
Pyrite | Level 9

you are correct. Thanks

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1372 views
  • 1 like
  • 2 in conversation