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