Recursive Function for Panel Data
Dear Readers,
I want to create a recursive variable for a panel data set. The model is an autoregressive model AR(4) with fixed effects. The first thing I do is estimate the coefficients and simulate iid N(0,1) errors.
Next, I want to generate a new variable, y_star(t) based on 4 initial conditions (the previous 4 observations in y_t), the regression coefficients and the simulated error. Then, y_star(t+1) is based now on y_star(t), 3 of the initial conditions and the simulated error; ystar(t+2) is based on ystar(t+1) and ystar(t),... and so on.
I have written how the function should look like. I first replace y_star by the first 4 non-missing values of the gdp_growth variable. Note that the initial conditions do not start the same years for all countries in the dataset, and therefore the first forecasted value, ystar_t, starts at different years for different countries (so I cannot do something similar as the Fibonacci example posted in Statalist earlier).
I'm copying the code I've written and also, I'm attaching a version of the dataset with the variables needed. I will then expand this code to a Monte Carlo Simulation.
Any help on how to properly construct my code is greatly appreciated.
The output from dataex is below:
I want to create a recursive variable for a panel data set. The model is an autoregressive model AR(4) with fixed effects. The first thing I do is estimate the coefficients and simulate iid N(0,1) errors.
Next, I want to generate a new variable, y_star(t) based on 4 initial conditions (the previous 4 observations in y_t), the regression coefficients and the simulated error. Then, y_star(t+1) is based now on y_star(t), 3 of the initial conditions and the simulated error; ystar(t+2) is based on ystar(t+1) and ystar(t),... and so on.
I have written how the function should look like. I first replace y_star by the first 4 non-missing values of the gdp_growth variable. Note that the initial conditions do not start the same years for all countries in the dataset, and therefore the first forecasted value, ystar_t, starts at different years for different countries (so I cannot do something similar as the Fibonacci example posted in Statalist earlier).
I'm copying the code I've written and also, I'm attaching a version of the dataset with the variables needed. I will then expand this code to a Monte Carlo Simulation.
Any help on how to properly construct my code is greatly appreciated.
Code:
* Set the initial conditions in ystar as sequnce of past observed yt-j to construct the the forecasts.
bys id: gen y_star=.
sort id year
by id: replace y_star= gdp_growth_wb if (year==y_ini | year==y_ini+1 | year==y_ini+2 | year==y_ini+3) /* Set Y_star to initial cond for ea country */
*** THIS IS WHERE MONTECARLO STARTS***
* Fixed effects regression.
*reg gdp_growth_wb L(1/4).gdp_growth_wb L(1/4).ba i.id
reg gdp_growth_wb L(1/4).gdp_growth_wb i.id
matrix B1= e(b)
mat li B1
predict g_hat,xb
gen e_hat= gdp_growth_wb - g_hat
gen flag=e(sample)
* Generate the "wild" errors for the forecasts
gen eta=rnormal()
gen e_star=e_hat*eta
levelsof id, local(codes)
set more off
capture noisily replace y_star= _b[_cons] + _b[L.gdp_growth_wb]*L.y_star + ///
_b[L2.gdp_growth_wb]*L2.y_star + _b[L3.gdp_growth_wb]*L3.y_star + ///
_b[L4.gdp_growth_wb]*L4.y_star + e_star if (id==1 & Dini4forward==1)
forvalues cc= 2(1)150 {
capture noisily replace y_star= _b[_cons] + _b[`cc'.id] + _b[L.gdp_growth_wb]*L.y_star + ///
_b[L2.gdp_growth_wb]*L2.y_star + _b[L3.gdp_growth_wb]*L3.y_star + ///
_b[L4.gdp_growth_wb]*L4.y_star + e_star if (id==`cc' & Dini4forward==1)
}
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str46 countryname float year str12 ccode float(gdp_growth_wb id y_ini y_end y_ini4forward Dy_ini Dy_end Dini4forward) "Angola" 1970 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1971 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1972 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1973 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1974 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1975 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1976 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1977 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1978 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1979 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1980 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1981 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1982 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1983 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1984 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1985 "AGO" . 1 1986 2005 1990 0 0 0 "Angola" 1986 "AGO" 2.8 1 1986 2005 1990 1 0 0 "Angola" 1987 "AGO" 7.9 1 1986 2005 1990 0 0 0 "Angola" 1988 "AGO" 5.6 1 1986 2005 1990 0 0 0 "Angola" 1989 "AGO" .4 1 1986 2005 1990 0 0 0 "Angola" 1990 "AGO" -.3 1 1986 2005 1990 0 0 1 "Angola" 1991 "AGO" -1.2 1 1986 2005 1990 0 0 1 "Angola" 1992 "AGO" -6.9 1 1986 2005 1990 0 0 1 "Angola" 1993 "AGO" . 1 1986 2005 1990 0 0 1 "Angola" 1994 "AGO" 3.5 1 1986 2005 1990 0 0 1 "Angola" 1995 "AGO" 10.4 1 1986 2005 1990 0 0 1 "Angola" 1996 "AGO" 11.2 1 1986 2005 1990 0 0 1 "Angola" 1997 "AGO" 7.9 1 1986 2005 1990 0 0 1 "Angola" 1998 "AGO" 6.804762 1 1986 2005 1990 0 0 1 "Angola" 1999 "AGO" 3.2398 1 1986 2005 1990 0 0 1 "Angola" 2000 "AGO" 3.012076 1 1986 2005 1990 0 0 1 "Angola" 2001 "AGO" 4.2209654 1 1986 2005 1990 0 0 1 "Angola" 2002 "AGO" 13.821793 1 1986 2005 1990 0 0 1 "Angola" 2003 "AGO" 5.24757 1 1986 2005 1990 0 0 1 "Angola" 2004 "AGO" 10.879465 1 1986 2005 1990 0 0 1 "Angola" 2005 "AGO" 18.261475 1 1986 2005 1990 0 1 1 "Angola" 2006 "AGO" . 1 1986 2005 1990 0 0 1 "Angola" 2007 "AGO" . 1 1986 2005 1990 0 0 1 "Angola" 2008 "AGO" 13.817145 1 1986 2005 1990 0 0 1 "Angola" 2009 "AGO" 2.41287 1 1986 2005 1990 0 0 1 "Angola" 2010 "AGO" 3.407655 1 1986 2005 1990 0 0 1 "Angola" 2011 "AGO" 3.918597 1 1986 2005 1990 0 0 1 "Albania" 1970 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1971 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1972 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1973 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1974 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1975 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1976 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1977 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1978 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1979 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1980 "ALB" . 2 1981 2011 1985 0 0 0 "Albania" 1981 "ALB" 5.745635 2 1981 2011 1985 1 0 0 "Albania" 1982 "ALB" 2.948597 2 1981 2011 1985 0 0 0 "Albania" 1983 "ALB" 1.1049383 2 1981 2011 1985 0 0 0 "Albania" 1984 "ALB" -1.2515967 2 1981 2011 1985 0 0 0 "Albania" 1985 "ALB" 1.780644 2 1981 2011 1985 0 0 1 "Albania" 1986 "ALB" 5.637243 2 1981 2011 1985 0 0 1 "Albania" 1987 "ALB" -.7878426 2 1981 2011 1985 0 0 1 "Albania" 1988 "ALB" -1.4200397 2 1981 2011 1985 0 0 1 "Albania" 1989 "ALB" 9.836549 2 1981 2011 1985 0 0 1 "Albania" 1990 "ALB" -9.57564 2 1981 2011 1985 0 0 1 "Albania" 1991 "ALB" . 2 1981 2011 1985 0 0 1 "Albania" 1992 "ALB" -7.2 2 1981 2011 1985 0 0 1 "Albania" 1993 "ALB" 9.6 2 1981 2011 1985 0 0 1 "Albania" 1994 "ALB" 8.3 2 1981 2011 1985 0 0 1 "Albania" 1995 "ALB" 13.3 2 1981 2011 1985 0 0 1 "Albania" 1996 "ALB" 9.1 2 1981 2011 1985 0 0 1 "Albania" 1997 "ALB" -10.2 2 1981 2011 1985 0 0 1 "Albania" 1998 "ALB" 12.7 2 1981 2011 1985 0 0 1 "Albania" 1999 "ALB" 10.1 2 1981 2011 1985 0 0 1 "Albania" 2000 "ALB" 7.3 2 1981 2011 1985 0 0 1 "Albania" 2001 "ALB" 7 2 1981 2011 1985 0 0 1 "Albania" 2002 "ALB" 2.9 2 1981 2011 1985 0 0 1 "Albania" 2003 "ALB" 5.7 2 1981 2011 1985 0 0 1 "Albania" 2004 "ALB" 5.9 2 1981 2011 1985 0 0 1 "Albania" 2005 "ALB" 5.499912 2 1981 2011 1985 0 0 1 "Albania" 2006 "ALB" 5.00001 2 1981 2011 1985 0 0 1 "Albania" 2007 "ALB" 5.900104 2 1981 2011 1985 0 0 1 "Albania" 2008 "ALB" 7.536299 2 1981 2011 1985 0 0 1 "Albania" 2009 "ALB" 3.354239 2 1981 2011 1985 0 0 1 "Albania" 2010 "ALB" 3.7069056 2 1981 2011 1985 0 0 1 "Albania" 2011 "ALB" 2.5453594 2 1981 2011 1985 0 1 1 "Argentina" 1970 "ARG" 3.045643 3 1970 2011 1974 1 0 0 "Argentina" 1971 "ARG" 5.658131 3 1970 2011 1974 0 0 0 "Argentina" 1972 "ARG" 1.6284165 3 1970 2011 1974 0 0 0 "Argentina" 1973 "ARG" 2.811754 3 1970 2011 1974 0 0 0 "Argentina" 1974 "ARG" 5.533804 3 1970 2011 1974 0 0 1 "Argentina" 1975 "ARG" -.028412104 3 1970 2011 1974 0 0 1 "Argentina" 1976 "ARG" -2.0182514 3 1970 2011 1974 0 0 1 "Argentina" 1977 "ARG" 6.934148 3 1970 2011 1974 0 0 1 "Argentina" 1978 "ARG" -4.506125 3 1970 2011 1974 0 0 1 "Argentina" 1979 "ARG" 10.222763 3 1970 2011 1974 0 0 1 "Argentina" 1980 "ARG" 4.1517625 3 1970 2011 1974 0 0 1 "Argentina" 1981 "ARG" -5.689528 3 1970 2011 1974 0 0 1 "Argentina" 1982 "ARG" -4.957179 3 1970 2011 1974 0 0 1 "Argentina" 1983 "ARG" 3.8751235 3 1970 2011 1974 0 0 1 "Argentina" 1984 "ARG" 2.2117734 3 1970 2011 1974 0 0 1 "Argentina" 1985 "ARG" -7.586677 3 1970 2011 1974 0 0 1 "Argentina" 1986 "ARG" 7.87578 3 1970 2011 1974 0 0 1 "Argentina" 1987 "ARG" 2.909993 3 1970 2011 1974 0 0 1 "Argentina" 1988 "ARG" -2.556905 3 1970 2011 1974 0 0 1 "Argentina" 1989 "ARG" -7.49619 3 1970 2011 1974 0 0 1 "Argentina" 1990 "ARG" -2.398959 3 1970 2011 1974 0 0 1 "Argentina" 1991 "ARG" 12.66971 3 1970 2011 1974 0 0 1 "Argentina" 1992 "ARG" 11.940775 3 1970 2011 1974 0 0 1 "Argentina" 1993 "ARG" 5.906919 3 1970 2011 1974 0 0 1 "Argentina" 1994 "ARG" 5.836201 3 1970 2011 1974 0 0 1 "Argentina" 1995 "ARG" -2.8452096 3 1970 2011 1974 0 0 1 "Argentina" 1996 "ARG" 5.52669 3 1970 2011 1974 0 0 1 "Argentina" 1997 "ARG" 8.111047 3 1970 2011 1974 0 0 1 "Argentina" 1998 "ARG" 3.850179 3 1970 2011 1974 0 0 1 "Argentina" 1999 "ARG" -3.385457 3 1970 2011 1974 0 0 1 "Argentina" 2000 "ARG" -.7889989 3 1970 2011 1974 0 0 1 "Argentina" 2001 "ARG" -4.4088397 3 1970 2011 1974 0 0 1 "Argentina" 2002 "ARG" -10.894485 3 1970 2011 1974 0 0 1 "Argentina" 2003 "ARG" 8.837041 3 1970 2011 1974 0 0 1 "Argentina" 2004 "ARG" 9.029573 3 1970 2011 1974 0 0 1 "Argentina" 2005 "ARG" 9.198489 3 1970 2011 1974 0 0 1 "Argentina" 2006 "ARG" 8.402868 3 1970 2011 1974 0 0 1 "Argentina" 2007 "ARG" 7.965573 3 1970 2011 1974 0 0 1 "Argentina" 2008 "ARG" 3.0749454 3 1970 2011 1974 0 0 1 "Argentina" 2009 "ARG" .05002446 3 1970 2011 1974 0 0 1 "Argentina" 2010 "ARG" 9.451578 3 1970 2011 1974 0 0 1 "Argentina" 2011 "ARG" 8.386452 3 1970 2011 1974 0 1 1 "Armenia" 1970 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1971 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1972 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1973 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1974 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1975 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1976 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1977 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1978 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1979 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1980 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1981 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1982 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1983 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1984 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1985 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1986 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1987 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1988 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1989 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1990 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1991 "ARM" -11.7 4 1993 2008 1997 0 0 0 "Armenia" 1992 "ARM" . 4 1993 2008 1997 0 0 0 "Armenia" 1993 "ARM" -8.799999 4 1993 2008 1997 1 0 0 "Armenia" 1994 "ARM" 5.400003 4 1993 2008 1997 0 0 0 "Armenia" 1995 "ARM" 6.899998 4 1993 2008 1997 0 0 0 "Armenia" 1996 "ARM" 5.865401 4 1993 2008 1997 0 0 0 "Armenia" 1997 "ARM" 3.32108 4 1993 2008 1997 0 0 1 "Armenia" 1998 "ARM" 7.3 4 1993 2008 1997 0 0 1 "Armenia" 1999 "ARM" 3.3 4 1993 2008 1997 0 0 1 "Armenia" 2000 "ARM" 5.9 4 1993 2008 1997 0 0 1 "Armenia" 2001 "ARM" 9.556642 4 1993 2008 1997 0 0 1 "Armenia" 2002 "ARM" 13.1863 4 1993 2008 1997 0 0 1 "Armenia" 2003 "ARM" 14.040795 4 1993 2008 1997 0 0 1 "Armenia" 2004 "ARM" 10.467842 4 1993 2008 1997 0 0 1 "Armenia" 2005 "ARM" 13.86571 4 1993 2008 1997 0 0 1 "Armenia" 2006 "ARM" 13.198004 4 1993 2008 1997 0 0 1 "Armenia" 2007 "ARM" 13.749202 4 1993 2008 1997 0 0 1 "Armenia" 2008 "ARM" 6.9 4 1993 2008 1997 0 1 1 "Armenia" 2009 "ARM" . 4 1993 2008 1997 0 0 1 "Armenia" 2010 "ARM" 2.2 4 1993 2008 1997 0 0 1 "Armenia" 2011 "ARM" 4.7 4 1993 2008 1997 0 0 1 "Panama" 1970 "PAN" 6.386746 111 1970 2011 1974 1 0 0 "Panama" 1971 "PAN" 9.645884 111 1970 2011 1974 0 0 0 "Panama" 1972 "PAN" 4.58028 111 1970 2011 1974 0 0 0 "Panama" 1973 "PAN" 5.405918 111 1970 2011 1974 0 0 0 "Panama" 1974 "PAN" 2.441506 111 1970 2011 1974 0 0 1 "Panama" 1975 "PAN" 1.5908294 111 1970 2011 1974 0 0 1 "Panama" 1976 "PAN" 1.6436394 111 1970 2011 1974 0 0 1 "Panama" 1977 "PAN" 1.1554474 111 1970 2011 1974 0 0 1 "Panama" 1978 "PAN" 9.739919 111 1970 2011 1974 0 0 1 "Panama" 1979 "PAN" 4.5078807 111 1970 2011 1974 0 0 1 "Panama" 1980 "PAN" 1.0984995 111 1970 2011 1974 0 0 1 "Panama" 1981 "PAN" 9.206809 111 1970 2011 1974 0 0 1 "Panama" 1982 "PAN" 5.348457 111 1970 2011 1974 0 0 1 "Panama" 1983 "PAN" -4.4913635 111 1970 2011 1974 0 0 1 "Panama" 1984 "PAN" 2.7094734 111 1970 2011 1974 0 0 1 "Panama" 1985 "PAN" 4.942234 111 1970 2011 1974 0 0 1 "Panama" 1986 "PAN" 3.567788 111 1970 2011 1974 0 0 1 "Panama" 1987 "PAN" -1.809055 111 1970 2011 1974 0 0 1 "Panama" 1988 "PAN" -13.379844 111 1970 2011 1974 0 0 1 "Panama" 1989 "PAN" 1.5622468 111 1970 2011 1974 0 0 1 "Panama" 1990 "PAN" 8.098992 111 1970 2011 1974 0 0 1 "Panama" 1991 "PAN" 9.419006 111 1970 2011 1974 0 0 1 "Panama" 1992 "PAN" 8.20168 111 1970 2011 1974 0 0 1 "Panama" 1993 "PAN" 5.455743 111 1970 2011 1974 0 0 1 "Panama" 1994 "PAN" 2.850148 111 1970 2011 1974 0 0 1 "Panama" 1995 "PAN" 1.7516786 111 1970 2011 1974 0 0 1 "Panama" 1996 "PAN" 2.810584 111 1970 2011 1974 0 0 1 "Panama" 1997 "PAN" 6.46099 111 1970 2011 1974 0 0 1 "Panama" 1998 "PAN" 7.341502 111 1970 2011 1974 0 0 1 "Panama" 1999 "PAN" 3.9172065 111 1970 2011 1974 0 0 1 "Panama" 2000 "PAN" 2.7153735 111 1970 2011 1974 0 0 1 "Panama" 2001 "PAN" .57427293 111 1970 2011 1974 0 0 1 "Panama" 2002 "PAN" 2.2288873 111 1970 2011 1974 0 0 1 "Panama" 2003 "PAN" 4.2057633 111 1970 2011 1974 0 0 1 "Panama" 2004 "PAN" 7.52208 111 1970 2011 1974 0 0 1 "Panama" 2005 "PAN" 7.191279 111 1970 2011 1974 0 0 1 "Panama" 2006 "PAN" 8.527761 111 1970 2011 1974 0 0 1 "Panama" 2007 "PAN" 12.11266 111 1970 2011 1974 0 0 1 "Panama" 2008 "PAN" 9.146904 111 1970 2011 1974 0 0 1 "Panama" 2009 "PAN" 3.974165 111 1970 2011 1974 0 0 1 "Panama" 2010 "PAN" 5.851874 111 1970 2011 1974 0 0 1 "Panama" 2011 "PAN" 10.770195 111 1970 2011 1974 0 1 1 "Peru" 1970 "PER" 5.836876 112 1970 2011 1974 1 0 0 "Peru" 1971 "PER" 4.1808863 112 1970 2011 1974 0 0 0 "Peru" 1972 "PER" 2.869776 112 1970 2011 1974 0 0 0 "Peru" 1973 "PER" 5.37567 112 1970 2011 1974 0 0 0 "Peru" 1974 "PER" 9.250073 112 1970 2011 1974 0 0 1 "Peru" 1975 "PER" 3.401564 112 1970 2011 1974 0 0 1 "Peru" 1976 "PER" 1.960723 112 1970 2011 1974 0 0 1 "Peru" 1977 "PER" .4029166 112 1970 2011 1974 0 0 1 "Peru" 1978 "PER" .28273636 112 1970 2011 1974 0 0 1 "Peru" 1979 "PER" 5.796397 112 1970 2011 1974 0 0 1 "Peru" 1980 "PER" 6.126499 112 1970 2011 1974 0 0 1 "Peru" 1981 "PER" 5.552042 112 1970 2011 1974 0 0 1 "Peru" 1982 "PER" -.22272344 112 1970 2011 1974 0 0 1 "Peru" 1983 "PER" -10.408086 112 1970 2011 1974 0 0 1 "Peru" 1984 "PER" 3.6082866 112 1970 2011 1974 0 0 1 "Peru" 1985 "PER" 2.061132 112 1970 2011 1974 0 0 1 "Peru" 1986 "PER" 9.425962 112 1970 2011 1974 0 0 1 "Peru" 1987 "PER" 9.726147 112 1970 2011 1974 0 0 1 "Peru" 1988 "PER" -9.441274 112 1970 2011 1974 0 0 1 "Peru" 1989 "PER" -12.31204 112 1970 2011 1974 0 0 1 "Peru" 1990 "PER" -4.982563 112 1970 2011 1974 0 0 1 "Peru" 1991 "PER" 2.219259 112 1970 2011 1974 0 0 1 "Peru" 1992 "PER" -.5405091 112 1970 2011 1974 0 0 1 "Peru" 1993 "PER" 5.243577 112 1970 2011 1974 0 0 1 "Peru" 1994 "PER" 12.308128 112 1970 2011 1974 0 0 1 "Peru" 1995 "PER" 7.411635 112 1970 2011 1974 0 0 1 "Peru" 1996 "PER" 2.7991176 112 1970 2011 1974 0 0 1 "Peru" 1997 "PER" 6.476802 112 1970 2011 1974 0 0 1 "Peru" 1998 "PER" -.39171025 112 1970 2011 1974 0 0 1 "Peru" 1999 "PER" 1.494863 112 1970 2011 1974 0 0 1 "Peru" 2000 "PER" 2.694311 112 1970 2011 1974 0 0 1 "Peru" 2001 "PER" .6178311 112 1970 2011 1974 0 0 1 "Peru" 2002 "PER" 5.453764 112 1970 2011 1974 0 0 1 "Peru" 2003 "PER" 4.1648507 112 1970 2011 1974 0 0 1 "Peru" 2004 "PER" 4.958278 112 1970 2011 1974 0 0 1 "Peru" 2005 "PER" 6.285172 112 1970 2011 1974 0 0 1 "Peru" 2006 "PER" 7.528817 112 1970 2011 1974 0 0 1 "Peru" 2007 "PER" 8.518442 112 1970 2011 1974 0 0 1 "Peru" 2008 "PER" 9.143148 112 1970 2011 1974 0 0 1 "Peru" 2009 "PER" 1.0492324 112 1970 2011 1974 0 0 1 "Peru" 2010 "PER" 8.450747 112 1970 2011 1974 0 0 1 "Peru" 2011 "PER" 6.452216 112 1970 2011 1974 0 1 1 "Philippines" 1970 "PHL" 3.764605 113 1970 2011 1974 1 0 0 "Philippines" 1971 "PHL" 5.428631 113 1970 2011 1974 0 0 0 "Philippines" 1972 "PHL" 5.446791 113 1970 2011 1974 0 0 0 "Philippines" 1973 "PHL" 8.920647 113 1970 2011 1974 0 0 0 "Philippines" 1974 "PHL" 3.558115 113 1970 2011 1974 0 0 1 "Philippines" 1975 "PHL" 5.564774 113 1970 2011 1974 0 0 1 "Philippines" 1976 "PHL" 8.80663 113 1970 2011 1974 0 0 1 "Philippines" 1977 "PHL" 5.602056 113 1970 2011 1974 0 0 1 "Philippines" 1978 "PHL" 5.172103 113 1970 2011 1974 0 0 1 "Philippines" 1979 "PHL" 5.639676 113 1970 2011 1974 0 0 1 "Philippines" 1980 "PHL" 5.148911 113 1970 2011 1974 0 0 1 "Philippines" 1981 "PHL" 3.423269 113 1970 2011 1974 0 0 1 "Philippines" 1982 "PHL" 3.6193275 113 1970 2011 1974 0 0 1 "Philippines" 1983 "PHL" 1.8746165 113 1970 2011 1974 0 0 1 "Philippines" 1984 "PHL" -7.323683 113 1970 2011 1974 0 0 1 "Philippines" 1985 "PHL" -7.306609 113 1970 2011 1974 0 0 1 "Philippines" 1986 "PHL" 3.416783 113 1970 2011 1974 0 0 1 "Philippines" 1987 "PHL" 4.311635 113 1970 2011 1974 0 0 1 "Philippines" 1988 "PHL" 6.752544 113 1970 2011 1974 0 0 1 "Philippines" 1989 "PHL" 6.205311 113 1970 2011 1974 0 0 1 "Philippines" 1990 "PHL" 3.036966 113 1970 2011 1974 0 0 1 "Philippines" 1991 "PHL" -.5783346 113 1970 2011 1974 0 0 1 "Philippines" 1992 "PHL" .337603 113 1970 2011 1974 0 0 1 "Philippines" 1993 "PHL" 2.1163073 113 1970 2011 1974 0 0 1 "Philippines" 1994 "PHL" 4.3876233 113 1970 2011 1974 0 0 1 "Philippines" 1995 "PHL" 4.6786923 113 1970 2011 1974 0 0 1 "Philippines" 1996 "PHL" 5.845873 113 1970 2011 1974 0 0 1 "Philippines" 1997 "PHL" 5.185362 113 1970 2011 1974 0 0 1 "Philippines" 1998 "PHL" -.5767222 113 1970 2011 1974 0 0 1 "Philippines" 1999 "PHL" 3.081927 113 1970 2011 1974 0 0 1 "Philippines" 2000 "PHL" 4.4112124 113 1970 2011 1974 0 0 1 "Philippines" 2001 "PHL" 2.8939924 113 1970 2011 1974 0 0 1 "Philippines" 2002 "PHL" 3.645898 113 1970 2011 1974 0 0 1 "Philippines" 2003 "PHL" 4.970364 113 1970 2011 1974 0 0 1 "Philippines" 2004 "PHL" 6.697637 113 1970 2011 1974 0 0 1 "Philippines" 2005 "PHL" 4.777663 113 1970 2011 1974 0 0 1 "Philippines" 2006 "PHL" 5.242953 113 1970 2011 1974 0 0 1 "Philippines" 2007 "PHL" 6.616669 113 1970 2011 1974 0 0 1 "Philippines" 2008 "PHL" 4.152757 113 1970 2011 1974 0 0 1 "Philippines" 2009 "PHL" 1.1483305 113 1970 2011 1974 0 0 1 "Philippines" 2010 "PHL" 7.632264 113 1970 2011 1974 0 0 1 "Philippines" 2011 "PHL" 3.659755 113 1970 2011 1974 0 1 1 "Zimbabwe" 1970 "ZWE" . 150 1971 2002 1975 0 0 0 "Zimbabwe" 1971 "ZWE" 8.917586 150 1971 2002 1975 1 0 0 "Zimbabwe" 1972 "ZWE" 8.329775 150 1971 2002 1975 0 0 0 "Zimbabwe" 1973 "ZWE" 2.6047146 150 1971 2002 1975 0 0 0 "Zimbabwe" 1974 "ZWE" 6.625154 150 1971 2002 1975 0 0 0 "Zimbabwe" 1975 "ZWE" -1.9312233 150 1971 2002 1975 0 0 1 "Zimbabwe" 1976 "ZWE" .4648389 150 1971 2002 1975 0 0 1 "Zimbabwe" 1977 "ZWE" -6.860703 150 1971 2002 1975 0 0 1 "Zimbabwe" 1978 "ZWE" -2.7069225 150 1971 2002 1975 0 0 1 "Zimbabwe" 1979 "ZWE" 3.2970355 150 1971 2002 1975 0 0 1 "Zimbabwe" 1980 "ZWE" 14.420684 150 1971 2002 1975 0 0 1 "Zimbabwe" 1981 "ZWE" 12.525425 150 1971 2002 1975 0 0 1 "Zimbabwe" 1982 "ZWE" 2.634297 150 1971 2002 1975 0 0 1 "Zimbabwe" 1983 "ZWE" 1.5853055 150 1971 2002 1975 0 0 1 "Zimbabwe" 1984 "ZWE" -1.90736 150 1971 2002 1975 0 0 1 "Zimbabwe" 1985 "ZWE" 6.944388 150 1971 2002 1975 0 0 1 "Zimbabwe" 1986 "ZWE" 2.099029 150 1971 2002 1975 0 0 1 "Zimbabwe" 1987 "ZWE" 1.1507372 150 1971 2002 1975 0 0 1 "Zimbabwe" 1988 "ZWE" 7.552374 150 1971 2002 1975 0 0 1 "Zimbabwe" 1989 "ZWE" 5.199767 150 1971 2002 1975 0 0 1 "Zimbabwe" 1990 "ZWE" 6.988553 150 1971 2002 1975 0 0 1 "Zimbabwe" 1991 "ZWE" 5.531782 150 1971 2002 1975 0 0 1 "Zimbabwe" 1992 "ZWE" -9.01557 150 1971 2002 1975 0 0 1 "Zimbabwe" 1993 "ZWE" 1.0514585 150 1971 2002 1975 0 0 1 "Zimbabwe" 1994 "ZWE" 9.235199 150 1971 2002 1975 0 0 1 "Zimbabwe" 1995 "ZWE" .15802576 150 1971 2002 1975 0 0 1 "Zimbabwe" 1996 "ZWE" 10.360697 150 1971 2002 1975 0 0 1 "Zimbabwe" 1997 "ZWE" 2.680594 150 1971 2002 1975 0 0 1 "Zimbabwe" 1998 "ZWE" 2.885212 150 1971 2002 1975 0 0 1 "Zimbabwe" 1999 "ZWE" -.8178209 150 1971 2002 1975 0 0 1 "Zimbabwe" 2000 "ZWE" -3.0591896 150 1971 2002 1975 0 0 1 "Zimbabwe" 2001 "ZWE" 1.439615 150 1971 2002 1975 0 0 1 "Zimbabwe" 2002 "ZWE" -8.894023 150 1971 2002 1975 0 1 1 "Zimbabwe" 2003 "ZWE" . 150 1971 2002 1975 0 0 1 "Zimbabwe" 2004 "ZWE" -5.807539 150 1971 2002 1975 0 0 1 "Zimbabwe" 2005 "ZWE" -5.711084 150 1971 2002 1975 0 0 1 "Zimbabwe" 2006 "ZWE" -3.461495 150 1971 2002 1975 0 0 1 "Zimbabwe" 2007 "ZWE" -3.653327 150 1971 2002 1975 0 0 1 "Zimbabwe" 2008 "ZWE" . 150 1971 2002 1975 0 0 1 "Zimbabwe" 2009 "ZWE" 5.984391 150 1971 2002 1975 0 0 1 "Zimbabwe" 2010 "ZWE" 11.37592 150 1971 2002 1975 0 0 1 "Zimbabwe" 2011 "ZWE" 11.905408 150 1971 2002 1975 0 0 1 end format %ty year
