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
Plot of Interaction TermI am trying to use margins and marginsplot to plot the effect of X1 in a regression as follows: Y=a…
How to set up a time-dependent Cox model in Stata?Hello everyone, I need to conduct an analysis, but the exposure can occur after the origin time. I h…
tvgc - time-varying granger causalityHow can I solve this error in Stata? tvgc_cv(): 3499 mm_quantile() not found <istmt>: - funct…
Three-tier Multi-Level Model: violation of the assumptions of normality and heteroscedasticity Dear colleagues, I am working with educational data. To do so, I am using the classic three-level h…
Geocoding in StataI have address variable (~700k observations) and I would like to get latitude and longitude of the a…
Subscribe to:
Post Comments (Atom)
0 Response to calculating Growth rates with a gap of 3 years in a panel data
Post a Comment