Hello everyone,
I would like to replace the missing values (leftceo) by the last given observation-year, to calculate the tenure of a CEO.
This means in my case that the three missing values should be replaced by "2020".
I tried the following command: "bysort gvkey_year: replace leftceo=max(YEAR) if missing(leftceo)". Unfortunately Stata states that it is an invalid syntax.
Could someone help me, please?
Thanks in advance!
Array
Related Posts with How do I fill in missing values using the highest/last observation-year?
How Can I Assign Specific Values to a Subsample According to a Percentage Distribution?- How exactly does Stata calculate derivatives via the margins command for nonlinear functions?
- ROC - lower score is higher risk
- Marginal effects graph blank after using fixed effects
- Change date abbreviation in multible observations
Subscribe to:
Post Comments (Atom)
0 Response to How do I fill in missing values using the highest/last observation-year?
Post a Comment