Dear Statalist Users,
I have an unbalanced panel dataset (please see below for an example of it) at the country and region level. To make my estimations, I would like to use sampling weights based on population (variable is popsum). However, I am confused about weighting by regional population (region variable is GADM1). I also want to be representative at the country level. If you can help me, I would be really appreciated!. Thanks a lot.
I have an unbalanced panel dataset (please see below for an example of it) at the country and region level. To make my estimations, I would like to use sampling weights based on population (variable is popsum). However, I am confused about weighting by regional population (region variable is GADM1). I also want to be representative at the country level. If you can help me, I would be really appreciated!. Thanks a lot.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str32 ctr_n double yr str26 GADM_1 double popsum "Angola" 2008 "Bengo" 399066.9681739124 "Angola" 2008 "Benguela" 1750680.72545104 "Angola" 2008 "Bie" 1810768.505870287 "Angola" 2008 "Cabinda" 103504.0285288887 "Angola" 2008 "Cuando Cubango" 655880.7027948858 "Angola" 2008 "Cuanza Norte" 794142.0497772275 "Angola" 2008 "Cuanza Sul" 1275821.430968955 "Angola" 2008 "Cunene" 431611.3839743704 "Angola" 2008 "Huambo" 2031918.29815634 "Angola" 2008 "Huila" 926986.3941745292 "Angola" 2008 "Lunda Norte" 512446.6660378085 "Angola" 2008 "Lunda Sul" 428728.1190773548 "Angola" 2008 "Malanje" 826627.52619847 "Angola" 2008 "Moxico" 182704.0635139552 "Angola" 2008 "Namibe" 186623.091236378 "Angola" 2008 "Uige" 3299137.073285381 "Angola" 2008 "Zaire" 209232.5944868613 "Angola" 2012 "Bengo" 399066.9681739124 "Angola" 2012 "Benguela" 1750680.72545104 "Angola" 2012 "Bie" 1810768.505870287 "Angola" 2012 "Cabinda" 103504.0285288887 "Angola" 2012 "Cuando Cubango" 655880.7027948858 "Angola" 2012 "Cuanza Norte" 794142.0497772275 "Angola" 2012 "Cuanza Sul" 1275821.430968955 "Angola" 2012 "Cunene" 431611.3839743704 "Angola" 2012 "Huambo" 2031918.29815634 "Angola" 2012 "Huila" 926986.3941745292 "Angola" 2012 "Lunda Norte" 512446.6660378085 "Angola" 2012 "Lunda Sul" 428728.1190773548 "Angola" 2012 "Malanje" 826627.52619847 "Angola" 2012 "Moxico" 182704.0635139552 "Angola" 2012 "Namibe" 186623.091236378 "Angola" 2012 "Uige" 3299137.073285381 "Angola" 2012 "Zaire" 209232.5944868613 "Benin" 2011 "Alibori" 522785.0506763104 "Benin" 2011 "Atacora" 602927.9644219093 "Benin" 2011 "Atlantique" 704952.795367986 "Benin" 2011 "Borgou" 714350.0203907415 "Benin" 2011 "Collines" 546141.1636683047 "Benin" 2011 "Donga" 343665.0975708478 "Benin" 2011 "Kouffo" 521832.6289235056 "Benin" 2011 "Littoral-Benin" 777203.9873330593 "Benin" 2011 "Mono" 365461.337759614 "Benin" 2011 "Oueme" 720078.1099822819 "Benin" 2011 "Plateau" 403650.0395380855 "Benin" 2011 "Zou" 618352.4107817113 "Benin" 2015 "Alibori" 522785.0506763104 "Benin" 2015 "Atacora" 602927.9644219093 "Benin" 2015 "Atlantique" 704952.795367986 "Benin" 2015 "Borgou" 714350.0203907415 "Benin" 2015 "Collines" 546141.1636683047 "Benin" 2015 "Donga" 343665.0975708478 "Benin" 2015 "Kouffo" 521832.6289235056 "Benin" 2015 "Littoral-Benin" 777203.9873330593 "Benin" 2015 "Mono" 365461.337759614 "Benin" 2015 "Oueme" 720078.1099822819 "Benin" 2015 "Plateau" 403650.0395380855 "Benin" 2015 "Zou" 618352.4107817113 "Botswana" 2004 "Central-Botswana" 515493.0342170898 "Botswana" 2004 "Chobe" 17736.31771118881 "Botswana" 2004 "Francistown" 66605.98749461025 "Botswana" 2004 "Ghanzi" 32147.08740629984 "Botswana" 2004 "Kgatleng" 71265.54468881711 "Botswana" 2004 "Kweneng" 223043.8781267465 "Botswana" 2004 "Lobatse" 28856.54783844948 "Botswana" 2004 "North-East" 62827.68343884125 "Botswana" 2004 "North-West" 121711.3444880068 "Botswana" 2004 "South-East" 120947.4081462249 "Botswana" 2004 "Southern-Botswana" 182290.5798051131 "Botswana" 2009 "Central-Botswana" 515493.0342170898 "Botswana" 2009 "Chobe" 17736.31771118881 "Botswana" 2009 "Francistown" 66605.98749461025 "Botswana" 2009 "Ghanzi" 32147.08740629984 "Botswana" 2009 "Kgatleng" 71265.54468881711 "Botswana" 2009 "Kweneng" 223043.8781267465 "Botswana" 2009 "Lobatse" 28856.54783844948 "Botswana" 2009 "South-East" 120947.4081462249 "Botswana" 2009 "Southern-Botswana" 182290.5798051131 "Botswana" 2014 "Central-Botswana" 515493.0342170898 "Botswana" 2014 "Chobe" 17736.31771118881 "Botswana" 2014 "Francistown" 66605.98749461025 "Botswana" 2014 "Gaborone" 116781.9854996055 "Botswana" 2014 "Ghanzi" 32147.08740629984 "Botswana" 2014 "Jwaneng" 355.6244935877621 "Botswana" 2014 "Kgatleng" 71265.54468881711 "Botswana" 2014 "Kweneng" 223043.8781267465 "Botswana" 2014 "Lobatse" 28856.54783844948 "Botswana" 2014 "North-East" 62827.68343884125 "Botswana" 2014 "North-West" 121711.3444880068 "Botswana" 2014 "Selibe Phikwe" 38406.5001706779 "Botswana" 2014 "South-East" 120947.4081462249 "Botswana" 2014 "Southern-Botswana" 182290.5798051131 "Burkina Faso" 2007 "Boucle du Mouhoun" 1273860.094291959 "Burkina Faso" 2007 "Cascades" 398663.5881445836 "Burkina Faso" 2007 "Centre-Burkina" 1194422.57654345 "Burkina Faso" 2007 "Centre-Est" 947886.9298630431 "Burkina Faso" 2007 "Centre-Nord" 1028096.707689695 "Burkina Faso" 2007 "Centre-Ouest" 1044063.543696973 "Burkina Faso" 2007 "Centre-Sud" 565243.7835180927 "Burkina Faso" 2007 "Est-Burkina" 978348.1954663554 end
Comment