set more off clear cd "C:\Users\Martin\Dropbox\Aid Paper\_JDE revision\aid_years_data" use aggregate_years, clear keep if year==2005 drop year rename donor donorname rename recipient recipientname foreach x in donor recipient { drop if `x'name=="Africa, regional" drop if `x'name=="America, regional" drop if `x'name=="Asia, regional" drop if `x'name=="Bilateral, unspecified" drop if `x'name=="Central Asia, regional" drop if `x'name=="Europe, regional" drop if `x'name=="Far East Asia, regional" drop if `x'name=="Middle East, regional" drop if `x'name=="North & Central America, regional" drop if `x'name=="North of Sahara, regional" drop if `x'name=="Oceania, regional" drop if `x'name=="South & Central Asia, regional" drop if `x'name=="South America, regional" drop if `x'name=="South Asia, regional" drop if `x'name=="South of Sahara, regional" drop if `x'name=="States Ex-Yugoslavia" drop if `x'name=="West Indies, regional" replace `x'name="Antigua and Barbuda" if `x'name=="Antigua And Barbuda" replace `x'name="Antigua and Barbuda" if `x'name=="Antigua & Barbuda" replace `x'name="Bahamas" if `x'name=="Bahamas, The" replace `x'name="Bahrain" if `x'name=="Bahrain, Kingdom of" replace `x'name="Bolivia" if `x'name=="Bolivia (Plurinational State of)" replace `x'name="Bosnia and Herzegovina" if `x'name=="Bosnia" replace `x'name="Bosnia and Herzegovina" if `x'name=="Bosnia-Hercegovenia" replace `x'name="Bosnia and Herzegovina" if `x'name=="Bosnia-Herzegovina" replace `x'name="Brunei" if `x'name=="Brunei Darussalam" replace `x'name="Cape Verde" if `x'name=="Cape Verde Is" replace `x'name="Central African Republic" if `x'name=="Cen. African Rep." replace `x'name="Central African Republic" if `x'name=="Central African Rep." replace `x'name="Central African Republic" if `x'name=="Central African Rep" replace `x'name="China" if `x'name=="China P Rep" replace `x'name="China" if `x'name=="China, P.R.: Mainland" replace `x'name="Cocos (Keeling) Islands" if `x'name=="Cocos Islands" replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Congo (D. R.)" replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Congo, Dem. Rep." replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Congo Kinshasa" replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Congo (Kinshasa)" replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Zaire/Congo Dem Rep" replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Congo, Democratic Republic of" replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Congo (Democratic Republic of the)" replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Democratic Republic of the Congo" replace `x'name="Congo, the Democratic Republic of the" if `x'name=="Democratic Republic of Congo (Zaire)" replace `x'name="Congo" if `x'name=="Congo, Rep." replace `x'name="Congo" if `x'name=="Congo (Republic)" replace `x'name="Congo" if `x'name=="Congo, Republic of" replace `x'name="Congo" if `x'name=="Congo Brazzaville" replace `x'name="Congo" if `x'name=="Congo (Brazzaville)" replace `x'name="Cook Islands" if `x'name=="Cook Is" replace `x'name="Côte d'Ivoire" if `x'name=="Ivory Coast" replace `x'name="Côte d'Ivoire" if `x'name=="Cote D’Ivoire" replace `x'name="Côte d'Ivoire" if `x'name=="Cote D'Ivoire" replace `x'name="Côte d'Ivoire" if `x'name=="Cote d`Ivoire" replace `x'name="Côte d'Ivoire" if `x'name=="Cote d'Ivoire" replace `x'name="Côte d'Ivoire" if `x'name=="Cote dIvoire" replace `x'name="Côte d'Ivoire" if `x'name=="Côte d' Ivoire" replace `x'name="Côte d'Ivoire" if `x'name=="Cote dIvoire (IvoryCoast)" replace `x'name="Cyprus" if `x'name=="Cyprus (old)" replace `x'name="Czech Republic" if `x'name=="Czech Rep" replace `x'name="Dominican Republic" if `x'name=="Dominican Rep" replace `x'name="Dominican Republic" if `x'name=="Dominican Rep." replace `x'name="Egypt" if `x'name=="Egypt, Arab Rep." replace `x'name="Ethiopia" if `x'name=="Ethiopia (new)" replace `x'name="Falkland Islands (Malvinas)" if `x'name=="Falkland Islands" replace `x'name="Falkland Islands (Malvinas)" if `x'name=="Falkland Islands (Islas Malvinas)" replace `x'name="Faroe Islands" if `x'name=="Faeroe Islands" replace `x'name="French Guiana" if `x'name=="Guiana, French" replace `x'name="French Polynesia" if `x'name=="French Territories: French Polynesia" replace `x'name="Gambia" if `x'name=="Gambia The" replace `x'name="Gambia" if `x'name=="Gambia, The" replace `x'name="Guinea-Bissau" if `x'name=="Guinea Bissau" replace `x'name="Hong Kong" if `x'name=="Hong Kong, China" replace `x'name="Hong Kong" if `x'name=="Hong Kong (China)" replace `x'name="Hong Kong" if `x'name=="Hong Kong Sar, China" replace `x'name="Hong Kong" if `x'name=="Hong Kong SAR, China" replace `x'name="Hong Kong" if `x'name=="Hong Kong, China (SAR)" replace `x'name="Hong Kong" if `x'name=="China, P.R.: Hong Kong" replace `x'name="Hong Kong" if `x'name=="China, Hong Kong Special Administrative Region" replace `x'name="Iran, Islamic Republic of" if `x'name=="Iran" replace `x'name="Iran, Islamic Republic of" if `x'name=="Iran Islam Rep" replace `x'name="Iran, Islamic Republic of" if `x'name=="Iran, Islamic Rep." replace `x'name="Iran, Islamic Republic of" if `x'name=="Iran (Islamic Republic of)" replace `x'name="Korea, Republic of" if `x'name=="Korea (Republic of)" replace `x'name="Korea, Republic of" if `x'name=="Republic of Korea" replace `x'name="Korea, Republic of" if `x'name=="Korea, Rep." replace `x'name="Korea, Republic of" if `x'name=="Korea" replace `x'name="Korea, Republic of" if `x'name=="Korea Rep" replace `x'name="Korea, Republic of" if `x'name=="South Korea" replace `x'name="Korea, Republic of" if `x'name=="Korea South" replace `x'name="Korea, Republic of" if `x'name=="Korea, South" replace `x'name="Korea, Democratic People's Republic of" if `x'name=="North Korea" replace `x'name="Korea, Democratic People's Republic of" if `x'name=="Korea North" replace `x'name="Korea, Democratic People's Republic of" if `x'name=="Korea, North" replace `x'name="Korea, Democratic People's Republic of" if `x'name=="Korea, Dem. Rep." replace `x'name="Korea, Democratic People's Republic of" if `x'name=="Korea Dem P Rep" replace `x'name="Korea, Democratic People's Republic of" if `x'name=="Korea, Democratic People's Rep. of" replace `x'name="Korea, Democratic People's Republic of" if `x'name=="Korea (Democratic People's Rep. of)" replace `x'name="Korea, Democratic People's Republic of" if `x'name=="Democratic People's Republic of Korea" replace `x'name="Kyrgyzstan" if `x'name=="Kyrgyz Republic" replace `x'name="Lao People's Democratic Republic" if `x'name=="Lao P Dem Rep" replace `x'name="Lao People's Democratic Republic" if `x'name=="Lao, P.D.R." replace `x'name="Lao People's Democratic Republic" if `x'name=="Lao PDR" replace `x'name="Lao People's Democratic Republic" if `x'name=="Laos" replace `x'name="Lao People's Democratic Republic" if `x'name=="Lao" replace `x'name="Libyan Arab Jamahiriya" if `x'name=="Libya" replace `x'name="Libyan Arab Jamahiriya" if `x'name=="Libyan Arab Jamah" replace `x'name="Macao" if `x'name=="Macau" replace `x'name="Macao" if `x'name=="Macao, China" replace `x'name="Macao" if `x'name=="China, P.R.: Macao" replace `x'name="Macao" if `x'name=="Macao Sar, China" replace `x'name="Macao" if `x'name=="Macao SAR, China" replace `x'name="Macao" if `x'name=="China, Macao Special Administrative Region" replace `x'name="Macedonia, the former Yugoslav Republic of" if `x'name=="Macedonia" replace `x'name="Macedonia, the former Yugoslav Republic of" if `x'name=="Macedonia FRY" replace `x'name="Macedonia, the former Yugoslav Republic of" if `x'name=="Macedonia, FYR" replace `x'name="Macedonia, the former Yugoslav Republic of" if `x'name=="Macedonia, TFYR" replace `x'name="Macedonia, the former Yugoslav Republic of" if `x'name=="The former Yugoslav Republic of Macedonia" replace `x'name="Marshall Islands" if `x'name=="Marshall Is" replace `x'name="Micronesia, Federated States of" if `x'name=="Micronesia" replace `x'name="Micronesia, Federated States of" if `x'name=="Micronesia, Fed. States" replace `x'name="Micronesia, Federated States of" if `x'name=="Micronesia Fed States" replace `x'name="Micronesia, Federated States of" if `x'name=="Micronesia, Fed. Sts." replace `x'name="Micronesia, Federated States of" if `x'name=="Micronesia (Federated States of)" replace `x'name="Moldova, Republic of" if `x'name=="Moldova" replace `x'name="Moldova, Republic of" if `x'name=="Moldova Rep" replace `x'name="Moldova, Republic of" if `x'name=="Moldova, Rep." replace `x'name="Moldova, Republic of" if `x'name=="Republic of Moldova" replace `x'name="Moldova, Republic of" if `x'name=="Moldova (Republic of)" replace `x'name="Monaco" if `x'name=="Monaco " replace `x'name="Montenegro" if `x'name=="Montenegro, Republic of" replace `x'name="Myanmar" if `x'name=="Myanmar (Burma)" replace `x'name="Myanmar" if `x'name=="Burma (Myanmar)" replace `x'name="Nauru" if `x'name=="Naura" replace `x'name="New Caledonia" if `x'name=="French Territories: New Caledonia" replace `x'name="Northern Mariana Islands" if `x'name=="Northern Mariana Is" replace `x'name="Pakistan" if `x'name=="Pakistan (old)" replace `x'name="Palestinian Territory, Occupied" if `x'name=="Palestine" replace `x'name="Palestinian Territory, Occupied" if `x'name=="Palestinian Adm. Areas" replace `x'name="Palestinian Territory, Occupied" if `x'name=="Palestinian Territory" replace `x'name="Palestinian Territory, Occupied" if `x'name=="West Bank Gaza" replace `x'name="Palestinian Territory, Occupied" if `x'name=="West Bank and Gaza" replace `x'name="Palestinian Territory, Occupied" if `x'name=="Palestine (West Bank)" replace `x'name="Palestinian Territory, Occupied" if `x'name=="West Bank & Gaza Strip" replace `x'name="Palestinian Territory, Occupied" if `x'name=="West Bank and Gaza Strip" replace `x'name="Palestinian Territory, Occupied" if `x'name=="Occupied Palestinian Territory" replace `x'name="Réunion" if `x'name=="R?nion" replace `x'name="Réunion" if `x'name=="Reunion" replace `x'name="Russian Federation" if `x'name=="Russia" replace `x'name="Russian Federation" if `x'name=="Russia (Soviet Union)" replace `x'name="Serbia" if `x'name=="Serbia, Republic of" replace `x'name="Slovakia" if `x'name=="Slovak Republic" replace `x'name="Solomon Islands" if `x'name=="Solomon Is" replace `x'name="Sri Lanka" if `x'name=="Sri Lanka (Ceylon)" replace `x'name="Saint Helena, Ascension and Tristan da Cunha" if `x'name=="St Helena" replace `x'name="Saint Helena, Ascension and Tristan da Cunha" if `x'name=="St. Helena" replace `x'name="Saint Helena, Ascension and Tristan da Cunha" if `x'name=="Saint Helena" replace `x'name="Saint Kitts and Nevis" if `x'name=="St. Kitts-Nevis" replace `x'name="Saint Kitts and Nevis" if `x'name=="St. Kitts & Nevis" replace `x'name="Saint Kitts and Nevis" if `x'name=="St. Kitts and Nevis" replace `x'name="Saint Kitts and Nevis" if `x'name=="St. Kitts And Nevis" replace `x'name="Saint Lucia" if `x'name=="St Lucia" replace `x'name="Saint Lucia" if `x'name=="St. Lucia" replace `x'name="Saint Martin (French part)" if `x'name=="St. Martin (French part)" replace `x'name="Saint Vincent and the Grenadines" if `x'name=="Saint Vincent/Grenadines" replace `x'name="Saint Vincent and the Grenadines" if `x'name=="St.Vincent & Grenadines" replace `x'name="Saint Vincent and the Grenadines" if `x'name=="St Vincent and The Grenadines" replace `x'name="Saint Vincent and the Grenadines" if `x'name=="St. Vincent and the Grenadines" replace `x'name="Saint Vincent and the Grenadines" if `x'name=="St. Vincent And The Grenadines" replace `x'name="Sao Tome and Principe" if `x'name=="Sao Tome" replace `x'name="Sao Tome and Principe" if `x'name=="Sao Tome & Principe" replace `x'name="Sao Tome and Principe" if `x'name=="Sao Tome et Principe" replace `x'name="Sao Tome and Principe" if `x'name=="São Tomé and Principe" replace `x'name="Sao Tome and Principe" if `x'name=="Sao Tome And Principe" replace `x'name="Sudan" if `x'name=="Sudan*" replace `x'name="Sudan" if `x'name=="Sudan and South Sudan" replace `x'name="Syrian Arab Republic" if `x'name=="Syria" replace `x'name="Syrian Arab Republic" if `x'name=="Syrian Arab Rep" replace `x'name="Taiwan, Province of China" if `x'name=="Taiwan" replace `x'name="Taiwan, Province of China" if `x'name=="Taiwan (China)" replace `x'name="Taiwan, Province of China" if `x'name=="Taiwan, China" replace `x'name="Taiwan, Province of China" if `x'name=="Taiwan Province of China" replace `x'name="Tanzania, United Republic of" if `x'name=="Tanzania" replace `x'name="Tanzania, United Republic of" if `x'name=="Tanzania Uni Rep" replace `x'name="Tanzania, United Republic of" if `x'name=="United Republic of Tanzania" replace `x'name="Tanzania, United Republic of" if `x'name=="Tanzania (United Republic of)" replace `x'name="Timor-Leste" if `x'name=="East Timor" replace `x'name="Timor-Leste" if `x'name=="Timor Leste" replace `x'name="Timor-Leste" if `x'name=="Timor-Leste (East Timor)" replace `x'name="Trinidad and Tobago" if `x'name=="Trinidad" replace `x'name="Trinidad and Tobago" if `x'name=="Trinidad &Tobago" replace `x'name="Trinidad and Tobago" if `x'name=="Trinidad And Tobago" replace `x'name="Turkey" if `x'name=="Turkey/Ottoman Empire" replace `x'name="Turks and Caicos Islands" if `x'name=="Turks and Caicos Is" replace `x'name="United Kingdom" if `x'name=="Great Britain" replace `x'name="United Arab Emirates" if `x'name=="UAE" replace `x'name="United States" if `x'name=="USA" replace `x'name="United States" if `x'name=="United States of America" replace `x'name="Venezuela, Bolivarian Republic of" if `x'name=="Venezuela" replace `x'name="Venezuela, Bolivarian Republic of" if `x'name=="Venezuela, RB" replace `x'name="Venezuela, Bolivarian Republic of" if `x'name=="Venezuela, Republica Bolivariana de" replace `x'name="Venezuela, Bolivarian Republic of" if `x'name=="Venezuela (Bolivarian Republic of)" replace `x'name="Viet Nam" if `x'name=="Vietnam" replace `x'name="Virgin Islands, British" if `x'name=="British Virgin Islands" replace `x'name="Virgin Islands, U.S." if `x'name=="Virgin Is (US)" replace `x'name="Virgin Islands, U.S." if `x'name=="US Virgin Islands" replace `x'name="Virgin Islands, U.S." if `x'name=="Virgin Islands (U.S.)" replace `x'name="Virgin Islands, U.S." if `x'name=="Virgin Islands, U.S." replace `x'name="Wallis and Futuna" if `x'name=="Wallis & Futuna" replace `x'name="Wallis and Futuna" if `x'name=="Wallis and Futuna Islands" replace `x'name="Yemen" if `x'name=="Yemen, Rep." replace `x'name="Yemen" if `x'name=="Yemen, Republic of" } merge 1:1 donorname recipientname using indicatordataworking_extended list donorname recipientname if _merge==1 drop if _merge==1 drop _merge replace aid_multilateral=0 if aid_all==. replace aid_ngo=0 if aid_all==. replace aid_government=0 if aid_all==. replace aid_publicprivatepartnership=0 if aid_all==. replace aid_tobedefined=0 if aid_all==. replace aid_all=0 if aid_all==. gen logpop02=ln(pop02) gen loggdp_cap02=ln(gdp_cap02) generate migrantshare=migrants/donorpop00 generate logoilreserves02=ln(oilreserves02+1) generate logexports05=ln(exports05+1) egen disasterdeathsaggr=rowtotal(disasterdeaths97- disasterdeaths99 disasterdeaths00- disasterdeaths05) gen logdisasterdeathsaggr=ln(disasterdeathsaggr+1) egen militaryexpmean=rowmean(militaryexp97-militaryexp05) gen distance=log(dist) *1 east asia and pacific, 2 europe and central asia, 3 latin america and caribbean, 4 middle east and north africa, 5 south asia, 6 sub-saharan africa, 7 western europe, 8 north america, 9 oceania gen regionid=. replace regionid=1 if recipientname=="American Samoa" | recipientname=="Cambodia" | recipientname=="China" | recipientname=="Fiji" | recipientname=="Indonesia" | recipientname=="Kiribati" | recipientname=="Korea, Democratic People's Republic of" | recipientname=="Korea, Republic of" | recipientname=="Lao People's Democratic Republic" | recipientname=="Malaysia" | recipientname=="Marshall Islands" | recipientname=="Micronesia, Federated States of" | recipientname=="Mongolia" | recipientname=="Myanmar" | recipientname=="Palau" | recipientname=="Papua New Guinea" | recipientname=="Philippines" | recipientname=="Samoa" | recipientname=="Solomon Islands" | recipientname=="Thailand" | recipientname=="Timor-Leste" | recipientname=="Tuvalu" | recipientname=="Tonga" | recipientname=="Vanuatu" | recipientname=="Viet Nam" | recipientname=="Brunei Darussalam" | recipientname=="Hong Kong" | recipientname=="Japan" | recipientname=="Macao" | recipientname=="Singapore" | recipientname=="Taiwan, Province of China" | recipientname=="Nauru" replace regionid=2 if recipientname=="Albania" | recipientname=="Armenia" | recipientname=="Azerbaijan" | recipientname=="Belarus" | recipientname=="Bosnia and Herzegovina" | recipientname=="Bulgaria" | recipientname=="Georgia" | recipientname=="Kazakhstan" | recipientname=="Kyrgyzstan" | recipientname=="Latvia" | recipientname=="Lithuania" | recipientname=="Macedonia, the former Yugoslav Republic of" | recipientname=="Moldova, Republic of" | recipientname=="Montenegro" | recipientname=="Romania" | recipientname=="Russian Federation" | recipientname=="Serbia" | recipientname=="Tajikistan" | recipientname=="Turkey" | recipientname=="Turkmenistan" | recipientname=="Ukraine" | recipientname=="Uzbekistan" replace regionid=3 if recipientname=="Antigua and Barbuda" | recipientname=="Argentina" | recipientname=="Belize" | recipientname=="Bolivia" | recipientname=="Brazil" | recipientname=="Chile" | recipientname=="Colombia" | recipientname=="Costa Rica" | recipientname=="Cuba" | recipientname=="Dominica" | recipientname=="Dominican Republic" | recipientname=="Ecuador" | recipientname=="El Salvador" | recipientname=="Grenada" | recipientname=="Guatemala" | recipientname=="Guyana" | recipientname=="Haiti" | recipientname=="Honduras" | recipientname=="Jamaica" | recipientname=="Mexico" | recipientname=="Nicaragua" | recipientname=="Panama" | recipientname=="Paraguay" | recipientname=="Peru" | recipientname=="Saint Lucia" | recipientname=="Saint Vincent and the Grenadines" | recipientname=="Suriname" | recipientname=="Uruguay" | recipientname=="Venezuela, Bolivarian Republic of" replace regionid=3 if recipientname=="Aruba" | recipientname=="Anguilla" | recipientname=="Bahamas" | recipientname=="Barbados" | recipientname=="Bermuda" | recipientname=="Cayman Islands Falkland Islands (Malvinas)" | recipientname=="French Guiana" | recipientname=="Guadeloupe" | recipientname=="Martinique" | recipientname=="Montserrat Netherlands Antilles" | recipientname=="Saint Barthélemy" | recipientname=="Saint Kitts and Nevis" | recipientname=="Saint Martin (French part)" | recipientname=="South Georgia and the South Sandwich Islands" | recipientname==" Trinidad and Tobago" | recipientname=="Turks and Caicos Islands" | recipientname=="Virgin Islands, British" | recipientname=="Virgin Islands, U.S." | recipientname=="Puerto Rico" replace regionid=4 if recipientname=="Algeria" | recipientname=="Djibouti" | recipientname=="Egypt" | recipientname=="Iran, Islamic Republic of" | recipientname=="Iraq" | recipientname=="Jordan" | recipientname=="Lebanon" | recipientname=="Libyan Arab Jamahiriya" | recipientname=="Morocco" | recipientname=="Syrian Arab Republic" | recipientname=="Tunisia" | recipientname=="Palestinian Territory, Occupied" | recipientname=="Yemen" | recipientname=="Bahrain" | recipientname=="Kuwait" | recipientname=="Oman" | recipientname=="Qatar" | recipientname=="Saudi Arabia" | recipientname=="United Arab Emirates" | recipientname=="Western Sahara" | recipientname=="Israel" replace regionid=5 if recipientname=="Afghanistan" | recipientname=="Bangladesh" | recipientname=="Bhutan" | recipientname=="India" | recipientname=="Maldives" | recipientname=="Nepal" | recipientname=="Pakistan" | recipientname=="Sri Lanka" | recipientname=="British Indian Ocean Territory" replace regionid=6 if recipientname=="Angola" | recipientname=="Benin" | recipientname=="Botswana" | recipientname=="Burkina Faso" | recipientname=="Burundi" | recipientname=="Cameroon" | recipientname=="Cape Verde" | recipientname=="Central African Republic" | recipientname=="Chad" | recipientname=="Comoros" | recipientname=="Congo" | recipientname=="Congo, the Democratic Republic of the" | recipientname=="Côte d'Ivoire" | recipientname=="Eritrea" | recipientname=="Ethiopia" | recipientname=="Gabon" | recipientname=="Gambia" | recipientname=="Ghana" | recipientname=="Guinea" | recipientname=="Guinea-Bissau" | recipientname=="Kenya" | recipientname=="Lesotho" | recipientname=="Liberia" replace regionid=6 if recipientname=="Madagascar" | recipientname=="Malawi" | recipientname=="Mali" | recipientname=="Mauritania" | recipientname=="Mauritius" | recipientname=="Mozambique" | recipientname=="Namibia" | recipientname=="Niger" | recipientname=="Nigeria" | recipientname=="Rwanda" | recipientname=="Sao Tome and Principe" | recipientname=="Senegal" | recipientname=="Seychelles" | recipientname=="Sierra Leone" | recipientname=="Somalia" | recipientname=="South Africa" | recipientname=="Sudan" | recipientname=="Swaziland" | recipientname=="Tanzania, United Republic of" | recipientname=="Togo" | recipientname=="Uganda" | recipientname=="Zambia" | recipientname=="Zimbabwe" | recipientname=="Equatorial Guinea" | recipientname=="Saint Helena, Ascension and Tristan da Cunha" | recipientname=="Réunion" | recipientname=="Mayotte" replace regionid=7 if recipientname=="Andorra" | recipientname=="Austria" | recipientname=="Belgium" | recipientname=="Denmark" | recipientname=="Finland" | recipientname=="France" | recipientname=="Faroe Islands" | recipientname=="Germany" | recipientname=="Gibraltar Greenland" | recipientname=="Iceland" | recipientname=="Ireland Italy" | recipientname=="Isle of Man" | recipientname=="Jersey" | recipientname=="Liechtenstein" | recipientname=="Luxembourg" | recipientname=="Malta" | recipientname=="Monaco" | recipientname=="Netherlands" | recipientname=="Norway" | recipientname=="Portugal" | recipientname=="San Marino" | recipientname=="Holy See (Vatican City State)" | recipientname=="Spain" | recipientname=="Sweden" | recipientname=="Switzerland" | recipientname=="United Kingdom Åland Islands" | recipientname=="Svalbard and Jan Mayen" | recipientname=="Croatia" | recipientname=="Cyprus" | recipientname=="Czech Republic" | recipientname=="Estonia" | recipientname=="Greece" | recipientname=="Guernsey" | recipientname=="Hungary" | recipientname=="Poland" | recipientname=="Slovakia" | recipientname=="Slovenia" replace regionid=8 if recipientname=="Saint Pierre and Miquelon" | recipientname=="United States" | recipientname=="Canada" replace regionid=9 if recipientname=="Christmas Island" | recipientname=="Cocos (Keeling) Islands" | recipientname=="Cook Islands Australia" | recipientname=="New Zealand" | recipientname=="Heard Island and McDonald Islands" | recipientname=="New Caledonia" | recipientname=="Niue" | recipientname=="Norfolk Island" | recipientname=="Pitcairn" | recipientname=="Tokelau" | recipientname=="Wallis and Futuna French Polynesia" | recipientname=="Guam" | recipientname=="Northern Mariana Islands" gen continentid=regionid recode continentid (9=1) (7=2) egen donorid=group(donorname) egen aid_sum=rowtotal(aid_government aid_ngo aid_multilateral) generate aid_govshare=aid_government/aid_sum gen aid_nongov=aid_ngo+aid_multilateral bysort recipientname: egen recipient_aid_sum=total(aid_sum) foreach x in aid_sum aid_nongov aid_government { replace `x'=ln(`x'+1) } save raw2005, replace label var aid_govshare "Share of State-to-state Aid" label var aid_government "State-to-state Aid" label var aid_nongov "State-to-nonstate Aid" label var loggdp_cap02 "GDP per Capita" label var logpop02 "Population Size" label var corruption02 "Control of Corruption" label var humanrightsphys02 "Human Rights Score" label var pwrlpop02 "Powerless Population" label var militaryexpmean "Military Expenditure" label var logexports05 "Exports" label var col45 "Colonial Relationship" label var distance "Distance" label var logdisasterdeathsaggr "Natural Disaster Deaths" label var migrantshare "Migrants" label var logoilreserves02 "Crude Oil Reserves" preserve xi: glm aid_govshare loggdp_cap02 logpop02 corruption02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) keep if e(sample)==1 foreach x in loggdp_cap02 logpop02 corruption02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 { sum `x' scalar sd_`x'=r(sd) replace `x'=(`x'-r(mean))/r(sd) } xi: glm aid_govshare loggdp_cap02 logpop02 corruption02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) predict yhat cor aid_govshare yhat scalar r2=r(rho)^2 drop yhat testparm loggdp_cap02 logpop02 corruption02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 estadd scalar chi2=r(chi2), replace estadd scalar p=r(p), replace estadd scalar sd_corruption02 mfx, varlist(loggdp_cap02 logpop02 corruption02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02) estadd scalar r2 est store reg1 restore preserve xi: glm aid_govshare loggdp_cap02 logpop02 humanrightsphys02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) keep if e(sample)==1 foreach x in loggdp_cap02 logpop02 humanrightsphys02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 { sum `x' scalar sd_`x'=r(sd) replace `x'=(`x'-r(mean))/r(sd) } xi: glm aid_govshare loggdp_cap02 logpop02 humanrightsphys02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) predict yhat cor aid_govshare yhat scalar r2=r(rho)^2 drop yhat testparm loggdp_cap02 logpop02 humanrightsphys02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 estadd scalar chi2=r(chi2), replace estadd scalar p=r(p), replace estadd scalar sd_humanrightsphys02 mfx, varlist(loggdp_cap02 logpop02 humanrightsphys02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02) estadd scalar r2 est store reg2 restore preserve xi: glm aid_govshare loggdp_cap02 logpop02 pwrlpop02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) keep if e(sample)==1 foreach x in loggdp_cap02 logpop02 pwrlpop02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 { sum `x' scalar sd_`x'=r(sd) replace `x'=(`x'-r(mean))/r(sd) } xi: glm aid_govshare loggdp_cap02 logpop02 pwrlpop02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) predict yhat cor aid_govshare yhat scalar r2=r(rho)^2 drop yhat testparm loggdp_cap02 logpop02 pwrlpop02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 estadd scalar chi2=r(chi2), replace estadd scalar p=r(p), replace estadd scalar sd_pwrlpop02 mfx, varlist(loggdp_cap02 logpop02 pwrlpop02 logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02) estadd scalar r2 est store reg3 restore preserve xi: glm aid_govshare loggdp_cap02 logpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) keep if e(sample)==1 foreach x in loggdp_cap02 logpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 { sum `x' scalar sd_`x'=r(sd) replace `x'=(`x'-r(mean))/r(sd) } xi: glm aid_govshare loggdp_cap02 logpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) predict yhat cor aid_govshare yhat scalar r2=r(rho)^2 drop yhat testparm loggdp_cap02 logpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 estadd scalar chi2=r(chi2), replace estadd scalar p=r(p), replace estadd scalar sd_militaryexpmean mfx, varlist(loggdp_cap02 logpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02) estadd scalar r2 est store reg4 restore preserve xi: glm aid_govshare loggdp_cap02 logpop02 corruption02 humanrightsphys02 pwrlpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) keep if e(sample)==1 foreach x in loggdp_cap02 logpop02 corruption02 humanrightsphys02 pwrlpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 { sum `x' scalar sd_`x'=r(sd) replace `x'=(`x'-r(mean))/r(sd) } xi: glm aid_govshare loggdp_cap02 logpop02 corruption02 humanrightsphys02 pwrlpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 i.donorid i.continentid if recipient_aid_sum>0, family(binomial) link(logit) vce(cluster donorid) predict yhat cor aid_govshare yhat scalar r2=r(rho)^2 drop yhat testparm loggdp_cap02 logpop02 corruption02 humanrightsphys02 pwrlpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02 estadd scalar chi2=r(chi2), replace estadd scalar p=r(p), replace estadd scalar sd_corruption02 estadd scalar sd_humanrightsphys02 estadd scalar sd_pwrlpop02 estadd scalar sd_militaryexpmean mfx, varlist(loggdp_cap02 logpop02 corruption02 humanrightsphys02 pwrlpop02 militaryexpmean logexports05 col45 distance logdisasterdeathsaggr migrantshare logoilreserves02) estadd scalar r2 est store reg5 restore esttab reg1 reg2 reg3 reg4 reg5 using table1_raw2005_paper, rtf label se margin star(* .10 ** .05 *** .01) stats(sd_corruption02 sd_humanrightsphys02 sd_pwrlpop02 sd_militaryexpmean N r2 chi2 p,fmt(0 3)) b(3) keep(corruption02 humanrightsphys02 pwrlpop02 militaryexpmean loggdp_cap02 logpop02 logdisasterdeathsaggr logoilreserves02 logexports05 col45 distance migrantshare) order(corruption02 humanrightsphys02 pwrlpop02 militaryexpmean loggdp_cap02 logpop02 logdisasterdeathsaggr logoilreserves02 logexports05 col45 distance migrantshare) no gaps onecell compress replace