Dear community,

I have a problem with my panel data. It feels like it should be pretty easy to solve, but it doesn't work out for me.
My panel is grouped by companies and years. I also have data about CEOs and corporate culture of the companies. I want to use the value for corporate culture in the year where the new CEO first appeared for all following years. I managed to generate a new variable that indicates what year that was. Now I need to generate a new variable that uses the culture value of year X for all observations for the company with that CEO.

Does anybody have an idea how to do this? Help would be much appreciated!!