BookmarkSubscribeRSS Feed
thanikondharish
Fluorite | Level 6

I have one dataset like see below

data have ;

input number ;

cards ;

4

4

8

2

7

9

5

7

;

 

How to sum upto 20 and again start with record value like see below example

number                   sum

2                               2

4                               6

4                               10

8                                18

2                                20

7                                7------------------------again start with record value

9                                16

5                                 5----------------------again start with record value

7                                 12

;

1 REPLY 1
VDD
Ammonite | Level 13 VDD
Ammonite | Level 13
data have ;
input number ;
cards ;
2 
4
4
8
2
7
9
5
7
;
data want;
	retain mysum;
	set have;
	if (mysum + number) > 20 then mysum = number;
	else mysum + number;

run;
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
  • 1 reply
  • 628 views
  • 0 likes
  • 2 in conversation