Hello everyone,

I was hoping someone could help me. I am trying to create a variable that would count each "1" until the following "0", as demonstrated in the example "newvar". This "newvar" is the variable I am trying to create, unsuccessfully... I am not sure if it is possible to reset the "sum" variable for each zero.

Expectation:
gov1change newvar
0
1 1
1 2
1 3
1 4
0
1 1
1 2
1 3
1 4
1 5
1 6
1 7
0
1 1
1 2
1 3
1 4
1 5
0

However, what I have is a variable called "gov1cum":

gen gov1cum = .
replace gov1cum = sum(inrange( gov1change[_n], 0,1)) if gov1change!=0


gov1change gov1cum
0
1 1
1 2
1 3
1 4
0
1 5
1 6
1 7
1 8
1 9
1 10
1 11
0
1 12
1 13
1 14
1 15
1 16
0


I would be very happy if someone could tell me if its possible to create such a variable... Thank you very, very much.
Cat