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
Error downloading updates - error extracting contentsHi all, I tried to update Stata (update all), and Stata issued an error message. error extracting …
Help with matchitHello, I'm trying to merge two datasets with -matchit- based on venture names and want to keep addi…
Generating a variable using several other variablesI have a variable in my dataset called fbnone, representing if respondents to a survey have no fring…
rdrobust type mismatchDear Statalists, I am running a RDD with the rdrobust command and always after calculating the outp…
problem with parsing numeric and string arguments in ado filehello, I want to write an ado file in which I have one numeric argument, one string argument, and on…
Subscribe to:
Post Comments (Atom)
0 Response to calculating Growth rates with a gap of 3 years in a panel data
Post a Comment