Carry observations foreward

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Carry observations foreward

I am trying to carry observations foreward in observations where "number" is three or below. I want to create a new column where observations have been carried foreward and summed, so values in "new_number" are all above three.   

 

HAVE

Age      Number 

20        10

21         2

22         5

23         1

24         1

25         5

 

 

WANT

Age      Number      New_number

20        10               10

21        2                  .

22        5                  7

23        1                  .

24        1                  .

25        5                  7

 

 

 

 


Accepted Solutions
Solution
‎03-16-2018 02:51 AM
Super User
Posts: 6,785

Re: Carry observations foreward

Posted in reply to CharlotteH

One way:

 

data want;

set have;

running_total + number;

if running_total > 3 then do;

   new_number = running_total;

   running_total = 0;

end;

drop running_total;

run;

View solution in original post


All Replies
Solution
‎03-16-2018 02:51 AM
Super User
Posts: 6,785

Re: Carry observations foreward

Posted in reply to CharlotteH

One way:

 

data want;

set have;

running_total + number;

if running_total > 3 then do;

   new_number = running_total;

   running_total = 0;

end;

drop running_total;

run;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 80 views
  • 0 likes
  • 2 in conversation