Hi everyone,
I have a variable called MHI which takes on a value between 0 and 100, it was only recorded in the survey every two years from 2000 to 2010 and then again in 2015. There are also some missing observations for some individuals where for example they have only answered in years 2000, 2004 and 2010.
I'm trying to create a variable dMHI that measures the change in MHI from it's last value, but I can't seem to figure out how to do it.
The years run from 1997 to 2016 and the panel is in long format.
Does anyone have any tips?
Apologies if this isn't clear enough - my first post.
Thank you in advance
Related Posts with Creating change variable with unbalanced panel
How to merge two datasets (string and integer values in ID)Dear all, I have two datasets: household and individual data. Usually, it is quite straightforward t…
Tagging neighborhood houses within timeframeI have a dataset with property ID, longitude, latitude, listing date and closing date (sale of prope…
doubt regarding standard deviation using egen functionI have tried to find row wise sd for a set of variables from i_a_0 to i_c_1 syntax: egen rowsd2 = ro…
Too many predictors when using Time fixed effects for panel dataHello, I am running an xtreg-fe cluster(panelvar) on monthly data. I employ time-fixed effects too. …
Missing values when I run regression analysisHi, I am running the following program Regression analysis for predictors of ICU admission(icu) aga…
Subscribe to:
Post Comments (Atom)
0 Response to Creating change variable with unbalanced panel
Post a Comment