I have one dataset like see below
data have ;
input number ;
cards ;
2
4
8
7
9
5
;
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
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;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Save the date!
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.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!