Adding values if cell above is not empty

[Jere RG]

Hi everyone,

How can I create a variable Y that sums the values of variable X that follow a missing observation?

Example:

X	Y
.	.
.	.
1	1
1	2
.	.
.	.
1	1
1	2
1	3
1	4
1	5
.	.
.	.
1	1
1	2
1	3

Thanks!

[Sarah Edgington]

try something like

gen want=0 if x==.
replace want=want[_n-1]+x if x!=.

[Jere RG]

Thanks so much, Sarah!
It worked like a charm!