How to forward a value for dummy variable observed in one onto the next periods

[Marija Vasilevska]

Hi everyone,

I want to create a dummy variable for each individual in my panel, that takes a value 0 or 1 in period 3 (out of 10) and to forward the same value to all the following periods.
example:
id time dummy
1 1 0
1 2 0
1 3 1
1 4 1
.
.
1 9 1
1 10 1
.


Any suggestions?

Thanks upfront

[Andrew Musau]

bys id (time): replace dummy = dummy[_n-1] if time >3

[Marija Vasilevska]

Thank you Andrew, it worked perfectly!

[Nick Cox]

This is an FAQ https://www.stata.com/support/faqs/d...issing-values/

[Marija Vasilevska]

Thanks Nick