Dear statlist,
I am working on a panel data set and need to calculate growth rates of each panel ID showed in my data as D_ID. i want to calculate growth rate from 2008 to 2010, 2011 to 2013 and 2014 to 2016 for each panel ID.
The data is of the following form please help me out in calculating these growth rates. Here D_ID is panel ID and Hel_hi_hsnt is the variable for which i need to calculate growth rate. a growth rate from 2008-2010 should give a single value (AS SHOWN UNDER GROWTH WHICH IS CALCULATED MANUALLY)
d_id year hel_hi_hsnt Growth
1 2008 9
1 2009 9
1 2010 9 0
1 2011 9
1 2012 9
1 2013 9 0
1 2014 9
1 2015 9
1 2016 9 0
2 2008 9
2 2009 9
2 2010 9 0
2 2011 9
2 2012 8
2 2013 8 -12.5
2 2014 8
2 2015 8
2 2016 8
3 2008 1
3 2009 1
3 2010 1
3 2011 1
3 2012 1
3 2013 1
3 2014 1
3 2015 1
3 2016 1
end
lOOKING FORWARD FOR YOUR HELP, THANKS IN ADVANCE.
Related Posts with calculating Growth rates with a gap of 3 years in a panel data
DID - specifying control cohort and treatment cohortHi there, I am currently completing my honours thesis and have been confronted with quite an obstacl…
2sls regression with interaction between endogenous and exogenous variablesHi All, My question is like this: I am having an endogenous variable X1 and an exogenous variable X…
Regression outputHello, I am running panel data fixed effect regressions where health outcome counts (mortality &…
Conditional probabilities in StataHi, I have a data as following: hhid year cropcode 1 2019 676 1 2019 837 1 2019 829 1 202…
Linear-Log Cubic regressionHello members! For a term paper, I wanted to check whether a lin-log model or a cubic function is b…
Subscribe to:
Post Comments (Atom)
0 Response to calculating Growth rates with a gap of 3 years in a panel data
Post a Comment