Dear Statalist Users,
I am tyring to take a lag of a variable (i.e., ref_elg and its t-1, t-2, t-3, and t-4). However, the problem is that I have to take the lags at the regional level for each country. Plus, I do not have a balanced panel. Regions are GADM1. When I tried the following code, it does not work in the way I wanted. I would be really appreciated if you can help me.
sort ctr_n GADM_1
by ctr_n GADM_1: gen nlag1 = ref_elg[_n-1]
by ctr_n GADM_1: gen nlag2 = ref_elg[_n-2]
by ctr_n GADM_1: gen nlag3 = ref_elg[_n-3]
by ctr_n GADM_1: gen nlag4 = ref_elg[_n-4]
Thank you very much.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str32 ctr_n double yr str26 GADM_1 float ref_elg "Angola" 2008 "Bengo" 0 "Angola" 2008 "Benguela" 0 "Angola" 2008 "Bie" 0 "Angola" 2008 "Cabinda" 0 "Angola" 2008 "Cuando Cubango" 0 "Angola" 2008 "Cuanza Norte" 0 "Angola" 2008 "Cuanza Sul" 0 "Angola" 2008 "Cunene" 0 "Angola" 2008 "Huambo" 0 "Angola" 2008 "Huila" 0 "Angola" 2008 "Lunda Norte" 0 "Angola" 2008 "Lunda Sul" 0 "Angola" 2008 "Malanje" 0 "Angola" 2008 "Moxico" 0 "Angola" 2008 "Namibe" 0 "Angola" 2008 "Uige" 0 "Angola" 2008 "Zaire" 0 "Angola" 2012 "Bengo" . "Angola" 2012 "Benguela" . "Angola" 2012 "Bie" . "Angola" 2012 "Cabinda" . "Angola" 2012 "Cuando Cubango" . "Angola" 2012 "Cuanza Norte" . "Angola" 2012 "Cuanza Sul" . "Angola" 2012 "Cunene" . "Angola" 2012 "Huambo" . "Angola" 2012 "Huila" . "Angola" 2012 "Lunda Norte" . "Angola" 2012 "Lunda Sul" . "Angola" 2012 "Malanje" . "Angola" 2012 "Moxico" . "Angola" 2012 "Namibe" . "Angola" 2012 "Uige" . "Angola" 2012 "Zaire" . "Benin" 2011 "Alibori" . "Benin" 2011 "Atacora" . "Benin" 2011 "Atlantique" . "Benin" 2011 "Borgou" . "Benin" 2011 "Collines" . "Benin" 2011 "Donga" . "Benin" 2011 "Kouffo" . "Benin" 2011 "Littoral-Benin" . "Benin" 2011 "Mono" . "Benin" 2011 "Oueme" . "Benin" 2011 "Plateau" . "Benin" 2011 "Zou" . "Benin" 2015 "Alibori" . "Benin" 2015 "Atacora" . "Benin" 2015 "Atlantique" . "Benin" 2015 "Borgou" . "Benin" 2015 "Collines" . "Benin" 2015 "Donga" . "Benin" 2015 "Kouffo" . "Benin" 2015 "Littoral-Benin" . "Benin" 2015 "Mono" . "Benin" 2015 "Oueme" . "Benin" 2015 "Plateau" . "Benin" 2015 "Zou" . "Botswana" 2004 "Central-Botswana" . "Botswana" 2004 "Chobe" . "Botswana" 2004 "Francistown" . "Botswana" 2004 "Ghanzi" . "Botswana" 2004 "Kgatleng" . "Botswana" 2004 "Kweneng" . "Botswana" 2004 "Lobatse" . "Botswana" 2004 "North-East" . "Botswana" 2004 "North-West" . "Botswana" 2004 "South-East" . "Botswana" 2004 "Southern-Botswana" . "Botswana" 2009 "Central-Botswana" . "Botswana" 2009 "Chobe" . "Botswana" 2009 "Francistown" . "Botswana" 2009 "Ghanzi" . "Botswana" 2009 "Kgatleng" . "Botswana" 2009 "Kweneng" . "Botswana" 2009 "Lobatse" . "Botswana" 2009 "South-East" . "Botswana" 2009 "Southern-Botswana" . "Botswana" 2014 "Central-Botswana" .010533023 "Botswana" 2014 "Chobe" 0 "Botswana" 2014 "Francistown" 0 "Botswana" 2014 "Gaborone" 0 "Botswana" 2014 "Ghanzi" 0 "Botswana" 2014 "Jwaneng" 0 "Botswana" 2014 "Kgatleng" 0 "Botswana" 2014 "Kweneng" 0 "Botswana" 2014 "Lobatse" 0 "Botswana" 2014 "North-East" 0 "Botswana" 2014 "North-West" 0 "Botswana" 2014 "Selibe Phikwe" 0 "Botswana" 2014 "South-East" 0 "Botswana" 2014 "Southern-Botswana" 0 "Burkina Faso" 2007 "Boucle du Mouhoun" 0 "Burkina Faso" 2007 "Cascades" 0 "Burkina Faso" 2007 "Centre-Burkina" 0 "Burkina Faso" 2007 "Centre-Est" 0 "Burkina Faso" 2007 "Centre-Nord" 0 "Burkina Faso" 2007 "Centre-Ouest" 0 "Burkina Faso" 2007 "Centre-Sud" 0 "Burkina Faso" 2007 "Est-Burkina" 0 end
Comment