[River Huang]

I think this does it, if I understand the problem correctly:

I think that I need to add

gen C_tenure = cum_tenure*ceo_weight_this_year/365
collapse C_tenure, by(firm year)

to obtain the firm-year level of CEOs' tenure. Thanks again, Clyde.