I am using Italian administrative longitudinal data for 10 years. Since I would like to understand how household income has evolved in my dataset over time, I thought to resort to the Moving Average. My Idea was therefore to take the average household income in each year and then generating the MA. However, I have a lot of problems. I am not able to use the AC function, even if I have installed the user-created command "PANELAUTO". Furthermore, when I use the tsgraph, nothing appears in the graph. Is there anyone who could help me?
I post here an example of the dataset at my disposal:
Code:
input long ID str8 ID_hh float(year hh_income) 1 "01" 2006 16590.01 1 "01" 2007 17380.10 1 "01" 2008 17600.91 1 "01" 2009 18111.36 1 "01" 2010 20217.31 1 "01" 2011 20300.63 1 "01" 2012 23567.38 1 "01" 2013 22698.79 1 "01" 2014 23009.00 1 "01" 2015 23090.34 1 "01" 2016 23250.55 2 "01" 2006 16590.01 2 "01" 2007 17380.10 2 "01" 2008 17600.91 2 "01" 2009 18111.36 2 "01" 2010 20217.31 2 "01" 2011 20300.63 2 "01" 2012 23567.38 3 "02" 2008 28656.31 3 "02" 2009 29360.20 3 "02" 2010 26003.27 3 "02" 2011 25322.36 3 "02" 2012 25210.16 3 "02" 2013 24200.56 3 "02" 2014 25300.36 end
Thank you a lot in advance,
Andrea
0 Response to problems with moving average - panel data
Post a Comment