*******************************
* Standardises Country Names and Matches them with their IMF Country Code
* Created by Christopher Gandrud
* Updated 29 March 2012
*******************************

*******************************************************
* Updated by Yury Bosin, University of New Mexico
* Last Updated 14 Septmber 2015
* Added ISO alpha-3 country codes, 15 July 2013
* Added ISO numerical country codes, 16 July 2013
********************************************************

* Instructions:
* Open your dataset
* Run this file: Menu -> File -> Do...
* Country name variable should be country (case sensitive)
* After running the do file all country names will be standardized
* Three new variables will be created: 
* imfcode (country three-digit numeric codes according to IMF classification), 
* iso_a3 (country three-letter codes according to ISO 3166 Alpha-3 classification), and
* iso_num (country three-digit numeric codes according to ISO 3166 classification)
* Run the do file on all datasets, then merge using either of the variables.
* ISO numeric classification seems to be the most comprehensive. 
* Check the dataset for duplicates and missing values

******************************************************************

* Feel free to update the file

********************************************************************


gen imfcode = .
replace country = "Afghanistan" if country == "Afghanistan, Rep. of."
replace country = "Afghanistan" if country == "afghanistan"
replace imfcode = 512 if country =="Afghanistan"
replace country = "Albania" if country == "albania"
replace country = "Albania" if country == "AL"
replace imfcode = 914 if country =="Albania"
replace country = "Algeria" if country == "algeria"
replace country = "Algeria" if country == "DZ"
replace imfcode = 612 if country =="Algeria"
replace country = "American Samoa" if country == "am_samoa"
replace imfcode = 859 if country =="American Samoa"
replace country = "Andorra" if country == "AD"
replace country = "Angola" if country == "angola"
replace imfcode = 614 if country =="Angola"
replace country = "Antigua and Barbuda" if country == "antigua_barb"
replace country = "Antigua and Barbuda" if country == "Antigua & Barbuda"
replace country = "Antigua and Barbuda" if country == "Antigua and Barbuba"
replace country = "Antigua and Barbuda" if country == "AntiguaandBarbuda"
replace country = "Antigua and Barbuda" if country == "antiguaandbarbuda"
replace imfcode = 311 if country =="Antigua and Barbuda"
replace country = "Argentina" if country == "argentina"
replace country = "Argentina" if country == "AR"
replace country = "Argentina" if country == "argentina"
replace country = "Argentina" if country == "argentin"
replace country = "Argentina" if country == "ARGENTINA"
replace imfcode = 213 if country =="Argentina"
replace country = "Armenia" if country == "armenia"
replace country = "Armenia" if country == "AM"
replace imfcode = 911 if country =="Armenia"
replace country = "Australia" if country == "AUSTRALIA"
replace country = "Australia" if country == "australia"
replace country = "Australia" if country == "AU"
replace imfcode = 193 if country =="Australia"
replace country = "Austria" if country == "AUSTRIA"
replace country = "Austria" if country == "austria"
replace imfcode = 122 if country =="Austria"
replace country = "Aruba" if country == "aruba"
replace imfcode = 314 if country =="Aruba"
replace country = "Azerbaijan" if country == "azerbaijan"
replace country = "Azerbaijan" if country == "Azerbajan"
replace country = "Azerbaijan" if country == "AZ"
replace imfcode = 912 if country =="Azerbaijan"
replace country = "Bahamas" if country == "bahamas"
replace country= "Bahamas" if country == "Bahamas, The"
replace country= "Bahamas" if country == "Bahamas,The"
replace country= "Bahamas" if country == " Bahamas, The "
replace imfcode = 313 if country =="Bahamas"
replace country = "Bahrain" if country == "bahrain"
replace imfcode = 419 if country =="Bahrain"
replace country = "Bangladesh" if country == "bangladesh"
replace country = "Bangladesh" if country == "BD"
replace imfcode = 513 if country =="Bangladesh"
replace country = "Barbados" if country == "barbados"
replace imfcode = 316 if country =="Barbados"
replace country = "Belarus" if country == "Belarus (Byelorussia)"
replace country = "Belarus" if country == "belarus"
replace country = "Belarus" if country == "BY"
replace imfcode = 913 if country =="Belarus"
replace country = "Belgium" if country == "belgium"
replace country = "Belgium" if country == "BELGIUM"
replace imfcode = 124 if country =="Belgium"
replace country = "Belize" if country == "belize"
replace imfcode = 339 if country =="Belize"
replace country = "Benin" if country == "benin"
replace country = "Benin" if country == "Benin (Dahomey)"
replace imfcode = 638 if country =="Benin"
replace country = "Bermuda" if country == "bermuda"
replace imfcode = 319 if country =="Bermuda"
replace country = "Bhutan" if country == "bhutan"
replace imfcode = 514 if country =="Bhutan"
replace country = "Bolivia" if country == "bolivia"
replace imfcode = 218 if country =="Bolivia"
replace country = "Bosnia and Herzegovina" if country == "bosnia_herzeg"
replace country = "Bosnia and Herzegovina" if country == "Bosnia Herzegovenia"
replace country = "Bosnia and Herzegovina" if country == "BA"
replace country = "Bosnia and Herzegovina" if country == "bosnia"
replace country = "Bosnia and Herzegovina" if country == "Bosnia"
replace country = "Bosnia and Herzegovina" if country == "Bosnia-Herz"
replace country = "Bosnia and Herzegovina" if country == "Bosnia-Herzegovina"
replace country = "Bosnia and Herzegovina" if country == "BosniaandHerzegovina"
replace country = "Bosnia and Herzegovina" if country == "bosniaandherzegovina"
replace country = "Bosnia and Herzegovina" if country == "Bosnia & Herzegovina"
replace imfcode = 963 if country == "Bosnia and Herzegovina"
replace country = "Botswana" if country == "botswana"
replace imfcode = 616 if country =="Botswana"
replace country = "Brazil" if country == "brazil"
replace country = "Brazil" if country == "BRAZIL"
replace country = "Brazil" if country == "BR"
replace imfcode = 223 if country =="Brazil"
replace country = "Brunei Darussalam" if country == "Brunei"
replace country = "Brunei Darussalam" if country == "BruneiDarussalam"
replace country = "Brunei Darussalam" if country == "brunei"
replace imfcode = 516 if country =="Brunei Darussalam"
replace country = "Bulgaria" if country == "bulgaria"
replace country = "Bulgaria" if country == "BG"
replace imfcode = 918 if country =="Bulgaria"
replace country = "Burkina Faso" if country == "Burkina Faso (Upper Volta)"
replace country = "Burkina Faso" if country == "burkina_faso"
replace country = "Burkina Faso" if country == "burkinafaso"
replace country = "Burkina Faso" if country == "BurkinaFaso"
replace country = "Burkina Faso" if country == "BF"
replace imfcode = 748 if country =="Burkina Faso"
replace country = "Burundi" if country == "burundi"
replace imfcode = 618 if country =="Burundi"
replace country = "Cambodia" if country == "cambodia"
replace country = "Cambodia" if country == "Cambodia (Kampuchea)"
replace imfcode = 522 if country =="Cambodia"
replace country = "Cameroon" if country == "cameroon"
replace imfcode = 622 if country =="Cameroon"
replace country = "Canada" if country == "canada"
replace country = "Canada" if country == "CANADA"
replace country = "Canada" if country == "CA"
replace imfcode = 156 if country =="Canada"
replace country = "Cabo Verde" if country == "C. Verde Is."
replace country = "Cabo Verde" if country == "cape_verde"
replace country = "Cabo Verde" if country == "capeverde"
replace country = "Cabo Verde" if country == "CapeVerde"
replace country = "Cabo Verde" if country == "Cape Verde"
replace imfcode = 624 if country =="Cabo Verde"
replace country = "Cayman Islands" if country == "cayman_is"
replace country = "Cayman Islands" if country == "CaymanIslands"
replace country = "Cayman Islands" if country == "caymanislands"
replace imfcode = 377 if country =="Cayman Islands"
replace country = "Central African Republic" if country == "car"
replace country = "Central African Republic" if country == "Cen African Rep"
replace country = "Central African Republic" if country == "Cent. Af. Rep."
replace country = "Central African Republic" if country == "Central African Rep."
replace country = "Central African Republic" if country == "CentralAfricanRepublic"
replace country = "Central African Republic" if country == "centralafricanrepublic"
replace imfcode = 626 if country =="Central African Republic"
replace country = "Chad" if country == "chad"
replace imfcode = 628 if country =="Chad"
replace country = "Channel Islands" if country == "Jersey, Channel Islands"
replace country = "Channel Islands" if country == "Jersey"
replace country = "Channel Islands" if country == "channel islands"
replace country = "Chile" if country == "CHILE"
replace country = "Chile" if country == "CL"
replace country = "Chile" if country == "chile"
replace imfcode = 228 if country =="Chile"
replace country = "China" if country == "PRC"
replace country = "China" if country == "China (P.R.C.)"
replace country = "China" if country == "china"
replace country = "China" if country == "CN"
replace country = "China" if country == "China, P.R."
replace imfcode = 924 if country =="China"
replace country = "Colombia" if country == "COLOMBIA"
replace country = "Colombia" if country == "CO"
replace country = "Colombia" if country == "colombia"
replace imfcode = 233 if country =="Colombia"
replace country = "Comoros" if country == "Comoro Is."
replace country = "Comoros" if country == "comoros"
replace country = "Comoros" if country == "comoroislands"
replace imfcode = 632 if country =="Comoros"
replace country = "Congo, Dem. Rep." if country == "Congo, Dem. Rep. of"
replace country = "Congo, Dem. Rep." if country == "Congo, Democratic Republic of / Za"
replace country = "Congo, Dem. Rep." if country == "Dem. Rep. of the Congo"
replace country = "Congo, Dem. Rep." if country == "Congo,Dem.Rep."
replace country = "Congo, Dem. Rep." if country == "congo__dem_"
replace country = "Congo, Dem. Rep." if country == "zairecongokinshasa"
replace country = "Congo, Dem. Rep." if country == "Congo Kinshasa"
replace country = "Congo, Dem. Rep." if country == "Congo, Kinshasa"
replace country = "Congo, Dem. Rep." if country == "Congo (Kinshasa)"
replace country = "Congo, Dem. Rep." if country == "Congo-Kinshasa"
replace country = "Congo, Dem. Rep." if country == "Congo, Dem. Rep."
replace country = "Congo, Dem. Rep." if country == " Congo, Dem. Rep."
replace country = "Congo, Dem. Rep." if country == "Congo, DR"
replace country = "Congo, Dem. Rep." if country == "zaire"
replace country = "Congo, Dem. Rep." if country == "Zaire"
replace country = "Congo, Dem. Rep." if country == "Congo, Democratic Republic of (Zaire)"
replace country = "Congo, Dem. Rep." if country == "Congo, Dem. Rep. (Zaire)"
replace country = "Congo, Dem. Rep." if country == "Congo, Democratic Republic of"
replace country = "Congo, Dem. Rep." if country == "Democratic Republic of the Congo"
replace country = "Congo, Dem. Rep." if country == "Zaire (Democ Republic Congo)"
replace country = "Congo, Dem. Rep." if country == "Congo, Dem. Rep."
replace country = "Congo, Dem. Rep." if country == "Congo (DRC)"
replace country = "Congo, Dem. Rep." if country == "Dem.Rep. of the Congo"
replace imfcode = 636 if country == "Congo, Dem. Rep."
replace country = "Congo, Rep." if country == "congo__rep_"
replace country = "Congo, Rep." if country == "Congo"
replace country = "Congo, Rep." if country == "Congo, Rep."
replace country = "Congo, Rep." if country == "Congo, Republic of the"
replace country = "Congo, Rep." if country == "CongoRep"
replace country = "Congo, Rep." if country == "CongoRep"
replace country = "Congo, Rep." if country == "Rep. of the Congo"
replace country = "Congo, Rep." if country == "congorep"
replace country = "Congo, Rep." if country == "Congo,Rep."
replace country = "Congo, Rep." if country == "Congo Brazzaville"
replace country = "Congo, Rep." if country == "Congo, Brazzaville"
replace country = "Congo, Rep." if country == "Congo (Brazzaville)"
replace country = "Congo, Rep." if country == "congobrazzaville"
replace country = "Congo, Rep." if country == "Republic of Congo"
replace country = "Congo, Rep." if country == "Congo, Rep. of"
replace country = "Congo, Rep." if country == "Congo, Republic of"
replace country = "Congo, Rep." if country == "Congo, Republic of (Brazzaville)"
replace imfcode = 634 if country =="Congo, Rep."
replace country = "Costa Rica" if country == "COSTA RICA"
replace country = "Costa Rica" if country == "costa_rica"
replace country = "Costa Rica" if country == "costarica"
replace country = "Costa Rica" if country == "CostaRica"
replace imfcode = 238 if country =="Costa Rica"
replace country = "Cote dIvoire" if country == "Cote d`Ivoire"
replace country = "Cote dIvoire" if country == "Cote d'Ivoire"
replace country = "Cote dIvoire" if country == "Coted'Ivoire"
replace country = "Cote dIvoire" if country == "Ivory Coast"
replace country = "Cote dIvoire" if country == "cote_d_ivoire"
replace country = "Cote dIvoire" if country == "CtedIvoire"
replace country = "Cote dIvoire" if country == "Cote DIvoire"
replace country = "Cote dIvoire" if country == "COTE D'IVOIRE"
replace country = "Cote dIvoire" if country == "C?te d'Ivoire"
replace country = "Cote dIvoire" if country == "Cote D?Ivoire"
replace country = "Cote dIvoire" if country == "C?te d?Ivoire"
replace country = "Cote dIvoire" if country == "C?te d'Ivoire"
replace country = "Cote dIvoire" if country == "ctedivoire"
replace country = "Cote dIvoire" if country == "Cote d'Ivoire (Ivory Coast)"
replace country = "Cote dIvoire" if country == "Ivory Coast (Cote d'Ivoire)"
replace country = "Cote dIvoire" if country == "Côte D'Ivoire"
replace imfcode = 662 if country =="Cote dIvoire"
replace country = "Croatia" if country == "croatia"
replace country = "Croatia" if country == "HR"
replace imfcode = 960 if country =="Croatia"
replace country = "Cuba" if country == "cuba"
replace imfcode = 928 if country =="Cuba"
replace country = "Cyprus" if country == "Greek Cyprus"
replace country = "Cyprus" if country == "cyprus"
replace country = "Cyprus" if country == "CY"
replace imfcode = 423 if country =="Cyprus"
replace country = "Curaçao" if country == "Curacao"
replace country = "Czechoslovakia" if country == "Czechoslovakia"
replace country = "Czech Republic" if country == "Czech Rep."
replace country = "Czech Republic" if country == "CZ"
replace country = "Czech Republic" if country == "CzechRepublic"
replace country = "Czech Republic" if country == "czech_rep"
replace country = "Czech Republic" if country == "czechrep"
replace country = "Czech Republic" if country == "czechrepublic"
replace country = "Czech Republic" if country == "Czech Republic (Czechoslovakia)"
replace imfcode = 935 if country =="Czech Republic"
replace country = "Denmark" if country == "denmark"
replace country = "Denmark" if country == "DENMARK"
replace imfcode = 128 if country =="Denmark"
replace country = "Djibouti" if country == "djibouti"
replace imfcode = 611 if country =="Djibouti"
replace country = "Dominica" if country == "dominica"
replace imfcode = 321 if country =="Dominica"
replace country = "Dominican Republic" if country == "Dom. Rep."
replace country = "Dominican Republic" if country == "DO"
replace country = "Dominican Republic" if country == "dominican_rep"
replace country = "Dominican Republic" if country == "dominicanrep"
replace country = "Dominican Republic" if country == "Dominican Rep"
replace country = "Dominican Republic" if country == "DominicanRepublic"
replace country = "Dominican Republic" if country == "dominicanrepublic"
replace imfcode = 243 if country =="Dominican Republic"
replace country = "Ecuador" if country == "ecuador"
replace country = "Ecuador" if country == "ECUADOR"
replace imfcode = 248 if country =="Ecuador"
replace country = "Egypt" if country == "egypt"
replace country = "Egypt" if country == "Egypt, Arab Rep."
replace country = "Egypt" if country == "Egypt,ArabRep."
replace country = "Egypt" if country == "EgyptArabRep"
replace country = "Egypt" if country == "egyptarabrep"
replace country = "Egypt" if country == " Egypt, Arab Rep."
replace country = "Egypt" if country == "EGYPT"
replace country = "Egypt" if country == "EG"
replace imfcode = 469 if country =="Egypt"
replace country = "El Salvador" if country == "el_salvador"
replace country = "El Salvador" if country == "elsalvador"
replace country = "El Salvador" if country == "ElSalvador"
replace country = "El Salvador" if country == "Salvador, El"
replace country = "El Salvador" if country == "SV"
replace imfcode = 253 if country =="El Salvador"
replace country = "Equatorial Guinea" if country == "equat_guinea"
replace country = "Equatorial Guinea" if country == "equatorialguinea"
replace country = "Equatorial Guinea" if country == "EquatorialGuinea"
replace country = "Equatorial Guinea" if country == "Eq. Guinea"
replace imfcode = 642 if country =="Equatorial Guinea"
replace country = "Eritrea" if country == "eritrea"
replace imfcode = 643 if country =="Eritrea"
replace country = "Estonia" if country == "estonia"
replace country = "Estonia" if country == "EE"
replace imfcode = 939 if country =="Estonia"
replace country = "Ethiopia" if country == "ethiopia"
replace country = "Ethiopia" if country == "ET"
replace country = "Ethiopia" if country == "eritreaethiopia"
replace imfcode = 644 if country =="Ethiopia"
replace country = "Faeroe Islands" if country == "faeroe_is"
replace imfcode = 816 if country =="Faeroe Islands"
replace country = "Fiji" if country == "fiji"
replace imfcode = 819 if country =="Fiji"
replace country = "Finland" if country == "finland"
replace country = "Finland" if country == "FI"
replace country = "Finland" if country == "FINLAND"
replace imfcode = 172 if country =="Finland"
replace country = "France" if country == "france"
replace country = "France" if country == "FRANCE"
replace country = "France" if country == "FR"
replace imfcode = 132 if country =="France"
replace country = "French Polynesia" if country == "french_poly"
replace country = "French Polynesia" if country == "FrenchPolynesia"
replace imfcode = 887 if country =="French Polynesia"
replace country = "Gabon" if country == "gabon"
replace imfcode = 646 if country =="Gabon"
replace country = "Gambida" if country == "gambia"
replace country = "Gambia" if country =="Gambia, The"
replace country = "Gambia" if country =="Gambia,The"
replace country = "Gambia" if country =="Gambia, The "
replace country = "Gambia" if country =="Gambia, The "
replace imfcode = 648 if country =="Gambia"
replace country = "Georgia" if country == "georgia"
replace country = "Georgia" if country == "GE"
replace imfcode = 915 if country =="Georgia"
replace country = "GDR" if country == "germany_east"
replace country = "East Germany" if country == "Germany East"
replace country = "East Germany" if country == "GDR"
replace country = "Germany" if country == "germany"
replace country = "Germany" if country == "FRG/Germany"
replace country = "Germany" if country == "Germany West"
replace country = "Germany" if country == "DE"
replace country = "Germany" if country == "German Federal Republic"
replace country = "Germany" if country == "GERMANY"
replace imfcode = 134 if country =="Germany"
replace country = "Ghana" if country == "ghana"
replace country = "Ghana" if country == "GHANA"
replace country = "Ghana" if country == "GH"
replace imfcode = 652 if country =="Ghana"
replace country = "Gibraltar" if country == "gibraltar"
replace imfcode = 823 if country == "Gibraltar"
replace country = "Greece" if country == "greece"
replace country = "Greece" if country == "GREECE"
replace imfcode = 174 if country =="Greece"
replace country = "Greenland" if country == "greenland"
replace imfcode = 326 if country =="Greenland"
replace country = "Grenada" if country == "grenada"
replace imfcode = 328 if country =="Grenada"
replace country = "Guam" if country == "guam"
replace imfcode = 829 if country =="Guam"
replace country = "Guatemala" if country == "guatemala"
replace country = "Guatemala" if country == "GT"
replace imfcode = 258 if country =="Guatemala"
replace country = "Guinea" if country == "guinea"
replace imfcode = 656 if country =="Guinea"
replace country = "Guinea Bissau" if country == "guinea_bissau"
replace country = "Guinea Bissau" if country == "guineabissau"
replace country = "Guinea Bissau" if country =="Guinea-Bissau"
replace country = "Guinea Bissau" if country =="GuineaBissau"
replace imfcode = 654 if country =="Guinea Bissau"
replace country = "Guyana" if country == "guyana"
replace imfcode = 336 if country =="Guyana"
replace country = "Haiti" if country == "haiti"
replace country = "Haiti" if country == "hati"
replace imfcode = 263 if country =="Haiti"
replace country = "Honduras" if country == "honduras"
replace imfcode = 268 if country =="Honduras"
replace country = "Hong Kong" if country == "hong_kong"
replace country = "Hong Kong" if country == "HK"
replace country = "Hong Kong" if country == "hongkong"
replace country = "Hong Kong" if country == "HONG KONG"
replace country = "Hong Kong" if country == "Hongkong"
replace country = "Hong Kong" if country == "Hong Kong, China"
replace country = "Hong Kong" if country == "HongKongChina"
replace country = "Hong Kong" if country == "hongkongchina"
replace country = "Hong Kong" if country == "Hong Kong, China"
replace country = "Hong Kong" if country == "Hong Kong SAR, China"
replace country = "Hong Kong" if country == "Hong Kong Sar, China"
replace country = "Hong Kong" if country == "HongKongSAR,China"
replace country = "Hong Kong" if country == "Hong Kong SAR"
replace country = "Hong Kong" if country == "China, P.R.: Hong Kong"
replace imfcode = 532 if country =="Hong Kong"
replace country = "Hungary" if country == "hungary"
replace country = "Hungary" if country == "HU"
replace imfcode = 944 if country =="Hungary"
replace country = "Iceland" if country == "iceland"
replace country = "Iceland" if country == "ICELAND"
replace imfcode = 176 if country =="Iceland"
replace country = "India" if country == "india"
replace country = "India" if country == "INDIA"
replace country = "India" if country == "IN"
replace imfcode = 534 if country =="India"
replace country = "Indonesia" if country == "indonesia"
replace country = "Indonesia" if country == "INDONESIA"
replace country = "Indonesia" if country == "ID"
replace imfcode = 536 if country =="Indonesia"
replace country = "Iran" if country == "Iran, Islamic Rep."
replace country = "Iran" if country == "IR"
replace country = "Iran" if country == "Iran,IslamicRep."
replace country = "Iran" if country == "Iran, Islamic Rep."
replace country = "Iran" if country == "iran"
replace country = "Iran" if country == "Iran, Islamic Rep. of"
replace country = "Iran" if country == "Iran, Islamic Republic of"
replace country = "Iran" if country == "Iran, I.R. of"
replace country = "Iran" if country == "Iran (Persia)"
replace imfcode = 429 if country =="Iran"
replace country = "Iraq" if country == "iraq"
replace country = "Iraq" if country == "IQ"
replace imfcode = 433 if country =="Iraq"
replace country = "Ireland" if country == "ireland"
replace country = "Ireland" if country == "IRELAND"
replace imfcode = 178 if country =="Ireland"
replace country = "Isle of Man" if country == "isle_of_man"
replace country = "Isle of Man" if country == "Isle Of Man"
replace imfcode = . if country =="Isle of Man"
replace country = "Israel" if country == "ISRAEL"
replace country = "Israel" if country == "IL"
replace country = "Israel" if country == "israel"
replace imfcode = 436 if country =="Israel"
replace country = "Italy" if country == "Italy/Sardinia"
replace country = "Italy" if country == "italy"
replace country = "Italy" if country == "ITALY"
replace country = "Italy" if country == "IT"
replace imfcode = 136 if country =="Italy"
replace country = "Jamaica" if country == "jamaica"
replace country = "Jamaica" if country == "JAMAICA"
replace imfcode = 343 if country =="Jamaica"
replace country = "Japan" if country == "japan"
replace country = "Japan" if country == "JAPAN"
replace country = "Japan" if country == "JP"
replace imfcode = 158 if country =="Japan"
replace country = "Jordan" if country == "jordan"
replace country = "Jordan" if country == "JORDAN"
replace country = "Jordan" if country == "JO"
replace imfcode = 439 if country =="Jordan"
replace country = "Kazakhstan" if country == "kazakhstan"
replace country = "Kazakhstan" if country == "Kazakstan"
replace country = "Kazakhstan" if country == "kazakstan"
replace imfcode = 916 if country =="Kazakhstan"
replace country = "Kenya" if country == "kenya"
replace country = "Kenya" if country == "KENYA"
replace imfcode = 664 if country =="Kenya"
replace country = "Kirabati" if country == "kiribati"
replace imfcode = 826 if country =="Kiribati"
replace country = "North Korea" if country == "PRK"
replace country = "North Korea" if country == "Korea, North"
replace country = "North Korea" if country == "Korea North"
replace country = "North Korea" if country == "Korea (North)"
replace country = "North Korea" if country == "Korea, Democratic People's Rep (N)"
replace country = "North Korea" if country == "North Korea (Democratc People's Republic of Korea)"
replace country = "North Korea" if country == "Korea, Democratic People's Republic of"
replace country = "North Korea" if country == "Korea,Dem.Rep."
replace country = "North Korea" if country == "Korea, Dem. Rep."
replace country = "North Korea" if country == "Korea, Democratic People's Republic"
replace country = "South Korea" if country == "ROK"
replace country = "South Korea" if country == "korea"
replace country = "South Korea" if country == "Korea, Republic of"
replace country = "South Korea" if country == "KoreaRep"
replace country = "South Korea" if country == "korearep"
replace country = "South Korea" if country == "Korea Republic"
replace country = "South Korea" if country == "Korea South"
replace country = "South Korea" if country == "Korea, Rep."
replace country = "South Korea" if country == "Korea,Rep."
replace country = "South Korea" if country == "Korea, Rep."
replace country = "South Korea" if country == "KR"
replace country = "South Korea" if country == "Korea, Rep. of"
replace country = "South Korea" if country == "Korea Rep"
replace country = "South Korea" if country == "Korea, South"
replace country = "South Korea" if country == "Korea (South)"
replace country = "South Korea" if country == "KOREA"
replace country = "South Korea" if country == "South Korea (Republic of Korea)"
replace country = "South Korea" if country == "KOREA REP. OF"
replace imfcode = 542 if country =="South Korea"
replace country = "Kuwait" if country == "kuwait"
replace country = "Kuwait" if country == "kuweit"
replace country = "Kuwait" if country == "Kuweit"
replace imfcode = 443 if country =="Kuwait"
replace country = "Kyrgyzstan" if country == "kyrgyz_rep"
replace country = "Kyrgyzstan" if country == "Kyrgyz Republic"
replace country = "Kyrgyzstan" if country == "KG"
replace country = "Kyrgyzstan" if country == "KyrgyzRepublic"
replace country = "Kyrgyzstan" if country == "kyrgyzrepublic"
replace country = "Kyrgyzstan" if country == "kyrgyzstan"
replace country = "Kyrgyzstan" if country == "Kyrgyzstan"
replace imfcode = 917 if country =="Kyrgyzstan"
replace country = "Laos" if country == "lao"
replace country = "Laos" if country == "Lao"
replace country = "Laos" if country == "Lao People's Dem Rep"
replace country = "Laos" if country == "laos"
replace country = "Laos" if country == "Lao PDR"
replace country = "Laos" if country == "Lao Pdr"
replace country = "Laos" if country == "LaoPDR"
replace country = "Laos" if country == "Lao P.D.R."
replace country = "Laos" if country == "Lao People?s Dem. Rep."
replace country = "Laos" if country == "Lao People's Democratic Republic"
replace imfcode = 544 if country =="Laos"
replace country = "Latvia" if country == "latvia"
replace country = "Latvia" if country == "LV"
replace imfcode = 941 if country =="Latvia"
replace country = "Lebanon" if country == "lebanon"
replace imfcode = 446 if country =="Lebanon"
replace country = "Lesotho" if country == "lesotho"
replace imfcode = 666 if country =="Lesotho"
replace country = "Liberia" if country == "liberia"
replace imfcode = 668 if country =="Liberia"
replace country = "Libya" if country == "libya"
replace imfcode = 672 if country =="Libya"
replace country = "Lithuania" if country == "lithuania"
replace country = "Lithuania" if country == "Lituania"
replace country = "Lithuania" if country == "LT"
replace imfcode = 946 if country =="Lithuania"
replace country = "Luxembourg" if country == "luxembourg"
replace country = "Luxembourg" if country == "Luxemburg"
replace imfcode = 137 if country =="Luxembourg"
replace country = "Macao" if country == "macao"
replace country= "Macao" if country=="Macao, China"
replace country= "Macao" if country=="Macau"
replace country= "Macao" if country=="Macao SAR, China"
replace country= "Macao" if country=="Macao Sar, China"
replace country= "Macao" if country=="MacaoChina"
replace country= "Macao" if country=="macaochina"
replace country= "Macao" if country=="MacaoSAR,China"
replace imfcode = 546 if country =="Macao"
replace country = "Macedonia" if country == "macedonia"
replace country = "Macedonia" if country == "Macedonia (Former Yug. Rep)"
replace country = "Macedonia" if country == "Macedonia, Former Yugoslav Republic"
replace country = "Macedonia" if country == "MK"
replace country = "Macedonia" if country == "Macedonia, FYR"
replace country = "Macedonia" if country == "Macedonia, Fyr"
replace country = "Macedonia" if country == "Macedonia,FYR"
replace country = "Macedonia" if country == "FYR Macedonia"
replace country = "Macedonia" if country == "Macedonia, FYR"
replace country = "Macedonia" if country == "Macedonia FYR"
replace country = "Macedonia" if country == "MacedoniaFYR"
replace country = "Macedonia" if country == "macedoniafyr"
replace country = "Macedonia" if country == "Macedonia, Former Yugoslav Republic of"
replace imfcode = 962 if country =="Macedonia"
replace country = "Madagascar" if country == "madagascar"
replace country = "Madagascar" if country == "Madagascar (Malagasy)"
replace imfcode = 674 if country =="Madagascar"
replace country = "Malawi" if country == "malawi"
replace imfcode = 676 if country =="Malawi"
replace country = "Malaysia" if country == "malaysia"
replace country = "Malaysia" if country == "MALAYSIA"
replace country = "Malaysia" if country == "MY"
replace imfcode = 548 if country =="Malaysia"
replace country = "Maldives" if country == "maldives"
replace imfcode = 556 if country =="Maldives"
replace country = "Mali" if country == "mali"
replace country = "Mali" if country == "ML"
replace imfcode = 678 if country =="Mali"
replace country = "Malta" if country == "malta"
replace imfcode = 181 if country =="Malta"
replace country = "Marshall Islands" if country == "marshall_is"
replace country = "Marshall Islands" if country == "MarshallIslands"
replace imfcode = 867 if country =="Marshall Islands"
replace country = "Mauritania" if country == "mauritania"
replace imfcode = 682 if country =="Mauritania"
replace country = "Mauritius" if country == "mauritius"
replace imfcode = 684 if country =="Mauritius"
replace country = "Mexico" if country == "mexico"
replace country = "Mexico" if country == "MX"
replace country = "Mexico" if country == "MEXICO"
replace imfcode = 273 if country =="Mexico"
replace country = "Micronesia" if country == "micronesia"
replace country = "Micronesia" if country == "Micronesia, Fed. Sts."
replace country = "Micronesia" if country == "Micronesia,Fed.Sts."
replace country = "Micronesia" if country == "Micronesia, Fed. Sts."
replace country = "Micronesia" if country == "Micronesia, Fed. States of"
replace country = "Micronesia" if country == "Micronesia, Fed Stat"
replace country = "Micronesia" if country == "Micronesia, Federated States"
replace country = "Micronesia" if country == "Micronesia, Federated States of"
replace country = "Micronesia" if country == "Micronesia (Federated States of)"
replace imfcode = 868 if country =="Micronesia"
replace country = "Moldova" if country == "moldova"
replace country = "Moldova" if country == "MD"
replace imfcode = 921 if country =="Moldova"
replace country = "Mongolia" if country == "mongolia"
replace imfcode = 948 if country =="Mongolia"
replace country = "Montenegro" if country == "montenegro"
replace imfcode = 943 if country =="Montenegro"
replace country = "Morocco" if country == "morocco"
replace country = "Morocco" if country == "MA"
replace imfcode = 686 if country =="Morocco"
replace country = "Mozambique" if country == "mozambique"
replace imfcode = 688 if country =="Mozambique"
replace country = "Myanmar" if country == "myanmar"
replace country = "Myanmar" if country == "burma"
replace country = "Myanmar" if country == "Myanmar (Burma)"
replace country = "Myanmar" if country == "Burma (Myanmar)"
replace country = "Myanmar" if country == "Burma"
replace imfcode = 518 if country =="Myanmar"
replace country = "Namibia" if country == "namibia"
replace imfcode = 728 if country =="Namibia"
replace country = "Nepal" if country == "nepal"
replace imfcode = 558 if country =="Nepal"
replace country = "Netherlands" if country == "netherlands"
replace country = "Netherlands" if country == "NL"
replace country = "Netherlands" if country == "Netherlands, The"
replace country = "Netherlands" if country == "NETHERLANDS"
replace imfcode = 138 if country =="Netherlands"
replace country = "Netherlands Antilles" if country == "netherlands_antilles"
replace country = "Netherlands Antilles" if country == "Netherlands Antilles (Former)"
replace imfcode = 353 if country =="Netherlands Antilles"
replace country = "New Caledonia" if country == "new_caledonia"
replace country = "New Caledonia" if country == "NewCaledonia"
replace imfcode = 839 if country =="new_caledonia"
replace country = "New Zealand" if country == "new_zealand"
replace country = "New Zealand" if country == "NZ"
replace country = "New Zealand" if country == "NewZealand"
replace country = "New Zealand" if country == "newzealand"
replace country = "New Zealand" if country == "NEW ZEALAND"
replace imfcode = 196 if country =="New Zealand"
replace country = "Nicaragua" if country == "nicaragua"
replace imfcode = 278 if country =="Nicaragua"
replace country = "Niger" if country == "niger"
replace imfcode = 692 if country =="Niger"
replace country = "Nigeria" if country == "nigeria"
replace country = "Nigeria" if country == "NIGERIA"
replace country = "Nigeria" if country == "NG"
replace imfcode = 694 if country =="Nigeria"
replace country = "Norway" if country == "norway"
replace country = "Norway" if country == "NORWAY"
replace country = "Norway" if country == "NO"
replace imfcode = 142 if country =="Norway"
replace country = "Oman" if country == "oman"
replace imfcode = 449 if country =="Oman"
replace country = "Pakistan" if country == "pakistan"
replace country = "Pakistan" if country == "PAKISTAN"
replace country = "Pakistan" if country == "PK"
replace imfcode = 564 if country =="Pakistan"
replace country = "Palau" if country == "palau"
replace imfcode = 565 if country =="Palau"
replace country = "Panama" if country == "panama"
replace imfcode = 283 if country =="Panama"
replace country = "Papua New Guinea" if country == "papua_new_g_"
replace country = "Papua New Guinea" if country == "P. N. Guinea"
replace country = "Papua New Guinea" if country == "PapuaNewGuinea"
replace country = "Papua New Guinea" if country == "papuanewguinea"
replace imfcode = 853 if country =="Papua New Guinea"
replace country = "Paraguay" if country == "paraguay"
replace country = "Paraguay" if country == "PARAGUAY"
replace imfcode = 288 if country =="Paraguay"
replace country = "Peru" if country == "peru"
replace country = "Peru" if country == "PE"
replace country = "Peru" if country == "PERU"
replace imfcode = 293 if country =="Peru"
replace country = "Philippines" if country == "philippines"
replace country = "Philippines" if country == "PH"
replace country = "Philippines" if country == "PHILIPPINES"
replace country = "Philippines" if country == "PH"
replace imfcode = 566 if country =="Philippines"
replace country = "Poland" if country == "poland"
replace country = "Poland" if country == "PL"
replace imfcode = 964 if country =="Poland"
replace country = "Portugal" if country == "portugal"
replace country = "Portugal" if country == "PORTUGAL"
replace imfcode = 182 if country =="Portugal"
replace country = "Puerto Rico" if country == "puerto_rico"
replace country = "Puerto Rico" if country == "puertorico"
replace country = "Puerto Rico" if country == "PuertoRico"
replace country = "Puerto Rico" if country == "PR"
replace imfcode = . if country =="Puerto Rico"
replace country = "Qatar" if country == "qatar"
replace imfcode = 453 if country =="Qatar"
replace country = "Romania" if country == "romania"
replace country = "Romania" if country == "RO"
replace imfcode = 968 if country =="Romania"
replace country = "Russian Federation" if country == "russia"
replace country = "Russian Federation" if country == "RU"
replace country = "Russian Federation" if country == "Russia (Soviet Union)"
replace country = "Russian Federation" if country == "Russia (USSR)"
replace country = "Russian Federation" if country == "Russia"
replace country = "Russian Federation" if country == "RussianFederation"
replace country = "Russian Federation" if country == "russianfederation"
replace imfcode = 922 if country =="Russian Federation"
replace country = "Rwanda" if country == "rwanda"
replace country = "Rwanda" if country == "RW"
replace imfcode = 714 if country =="Rwanda"
replace country = "Samoa" if country == "samoa"
replace country = "Samoa" if country == "Samoa/Western Samoa"
replace country = "Samoa" if country == "Samoa (Western Samoa)"
replace imfcode = 862 if country =="Samoa"
replace country = "San Marino" if country == "san_marino"
replace imfcode = 135 if country =="San Marino"
replace country ="Saint Lucia" if country =="St. Lucia"
replace imfcode = 342 if country =="Saint Lucia"
replace country = "Sao Tome and Principe" if country == "sao_tome_pr"
replace country = "Sao Tome and Principe" if country == "Sao Tome & Principe"
replace country = "Sao Tome and Principe" if country == "S?o Tom?Eand Principe"
replace country = "Sao Tome and Principe" if country == "SaoTomeandPrincipe"
replace country = "Sao Tome and Principe" if country == "Sao Tome"
replace country = "Sao Tome and Principe" if country == "stomp"
replace country = "Sao Tome and Principe" if country == "S?o Tom? and Principe"
replace country = "Sao Tome and Principe" if country == "São Tomé And Principe"
replace country = "Sao Tome and Principe" if country == "São Tomé and Principe"
replace country = "Sao Tome and Principe" if country == "S?o Tom? & Pr?ncipe"
replace imfcode = 716 if country =="Sao Tome and Principe"
replace country = "Saudi Arabia" if country == "saudi_arabia"
replace country = "Saudi Arabia" if country == "saudiarabia"
replace country = "Saudi Arabia" if country == "SaudiArabia"
replace country = "Saudi Arabia" if country == "SA"
replace imfcode = 456 if country =="Saudi Arabia"
replace country = "Senegal" if country == "senegal"
replace country = "Senegal" if country == "SENEGAL"
replace imfcode = 722 if country =="Senegal"
replace country = "Serbia" if country == "serbia"
replace country = "Serbia" if country == "CS"
replace country = "Serbia" if country == "CSS"
replace country = "Serbia" if country == "Yugoslavia (Serbia)"
replace country = "Serbia" if country == "Yugoslavia"
replace country = "Serbia" if country == "Serbia & Montenegro"
replace country = "Serbia" if country == "Serbia and Montenegro, Former"
replace country = "Serbia" if country == "Serbia and Montenegro"
replace country = "Serbia" if country == "Yugoslavia (Serbia and Montenegro)"
replace imfcode = 965 if country =="Serbia"
replace country = "Seychelles" if country == "seychelles"
replace imfcode = 718 if country =="Seychelles"
replace country = "Sierra Leone" if country == "sierra_leone"
replace country = "Sierra Leone" if country == "sierraleone"
replace country = "Sierra Leone" if country == "SierraLeone"
replace imfcode = 724 if country =="Sierra Leone"
replace country = "Singapore" if country == "singapore"
replace country = "Singapore" if country == "SINGAPORE"
replace country = "Singapore" if country == "SG"
replace imfcode = 576 if country =="Singapore"
replace country = "Slovak Republic" if country == "slovak_rep"
replace country = "Slovak Republic" if country == "slovakrepublic"
replace country = "Slovak Republic" if country == "SlovakRepublic"
replace country = "Slovak Republic" if country == "slovakia"
replace country = "Slovak Republic" if country == "SK"
replace country = "Slovak Republic" if country == "Slovakia"
replace imfcode = 936 if country =="Slovak Republic"
replace country = "Slovenia" if country == "slovenia"
replace country = "Slovenia" if country == "SI"
replace imfcode = 961 if country =="Slovenia"
replace country = "Solomon Islands" if country == "solomon_is"
replace country = "Solomon Islands" if country == "Solomon Is."
replace country = "Solomon Islands" if country == "SolomonIslands"
replace imfcode = 813 if country =="Solomon Islands"
replace country = "Somalia" if country == "somalia"
replace imfcode = 726 if country =="Somalia"
replace country = "South Africa" if country == "south_africa"
replace country = "South Africa" if country == "southafrica"
replace country = "South Africa" if country == "S. Africa"
replace country = "South Africa" if country == "ZA"
replace country = "South Africa" if country == "SouthAfrica"
replace country = "South Africa" if country == "SOUTH AFRICA"
replace imfcode = 199 if country =="South Africa"
replace country = "Spain" if country == "spain"
replace country = "Spain" if country == "ES"
replace country = "Spain" if country == "SPAIN"
replace imfcode = 184 if country =="Spain"
replace country = "Sri Lanka" if country == "sri_lanka"
replace country = "Sri Lanka" if country == "srilanka"
replace country = "Sri Lanka" if country == "SRI LANKA"
replace country = "Sri Lanka" if country == "Sri Lanka (Ceylon)"
replace country = "Sri Lanka" if country == "SriLanka"
replace imfcode = 524 if country =="Sri Lanka"
replace country = "Saint Kitts and Nevis" if country == "st_kitts_n"
replace country = "Saint Kitts and Nevis" if country == "Saint Kitts And Nevis"
replace country = "Saint Kitts and Nevis" if country == "St. Kitts And Nevis"
replace country = "Saint Kitts and Nevis" if country == "St.KittsandNevis"
replace country = "Saint Kitts and Nevis" if country == "StKittsandNevis"
replace country = "Saint Kitts and Nevis" if country == "stkittsandnevis"
replace country = "Saint Kitts and Nevis" if country == "St. Kitts & Nevis"
replace country = "Saint Kitts and Nevis" if country == "St. Kitts"
replace country = "Saint Kitts and Nevis" if country == "St. Kitts and Nevis"
replace imfcode = 361 if country =="Saint Kitts and Nevis"
replace country = "Saint Martin (French part)" if country == "St.Martin"
replace country = "Saint Martin (French part)" if country == "St. Martin"
replace country = "Saint Martin (French part)" if country == "Saint Martin"
replace country = "Saint Martin (French part)" if country == "saint martin"
replace country = "Saint Martin (French part)" if country == "st.martin"
replace country = "Saint Martin (French part)" if country == "St. Martin (French part)"
replace country = "Saint Lucia" if country == "st_lucia"
replace country = "Saint Lucia" if country == "St.Lucia"
replace country = "Saint Lucia" if country == "StLucia"
replace country = "Saint Lucia" if country == "stlucia"
replace country = "Saint Lucia" if country == "St.lucia"
replace imfcode = 362 if country =="Saint Lucia"
replace country = "Saint Vincent and the Grenadines" if country == "st_vincent_gr"
replace country = "Saint Vincent and the Grenadines" if country == "St. Vincent and Grenadines"
replace country = "Saint Vincent and the Grenadines" if country == "Saint Vincent and The Grenadines"
replace country = "Saint Vincent and the Grenadines" if country == "St. Vincent and the Grenadines"
replace country = "Saint Vincent and the Grenadines" if country == "St. Vincent and The Grenadines"
replace country = "Saint Vincent and the Grenadines" if country == "St. Vincent And The Grenadines"
replace country = "Saint Vincent and the Grenadines" if country == "Saint Vincent and the Grenadines"
replace country = "Saint Vincent and the Grenadines" if country == "St.VincentandtheGrenadines"
replace country = "Saint Vincent and the Grenadines" if country == "StVincentandtheGrenadines"
replace country = "Saint Vincent and the Grenadines" if country == "stvincentandthegrenadines"
replace country = "Saint Vincent and the Grenadines" if country == "St. Vincent & Grenadine"
replace imfcode = 364 if country =="Saint Vincent and the Grenadines"
replace country = "Sint Maarten (Dutch part)" if country == "Sint Maarten"
replace country = "Sudan" if country == "sudan"
replace country = "Sudan" if country == "Sudan-North"
replace imfcode = 732 if country =="Sudan"
replace country = "South Sudan" if country == "Sudan-South"
replace country = "Suriname" if country == "suriname"
replace country = "Suriname" if country == "Surinam"
replace imfcode = 366 if country =="Suriname"
replace country = "Swaziland" if country == "swaziland"
replace imfcode = 734 if country =="Swaziland"
replace country = "Sweden" if country == "sweden"
replace country = "Sweden" if country == "SWEDEN"
replace country = "Sweden" if country == "SE"
replace imfcode = 144 if country =="Sweden"
replace country = "Switzerland" if country == "switzerland"
replace country = "Switzerland" if country == "CH"
replace country = "Switzerland" if country == "SWITZERLAND"
replace imfcode = 146 if country =="Switzerland"
replace country = "Syria" if country == "syria"
replace country= "Syria" if country=="Syrian Arab Republic"
replace country= "Syria" if country=="SyrianArabRepublic"
replace country= "Syria" if country=="syrianarabrepublic"
replace imfcode = 463 if country =="Syria"
replace country = "Taiwan" if country == "taiwan"
replace country = "Taiwan" if country == "China (Taiwan)"
replace country = "Taiwan" if country == "TW"
replace country = "Taiwan" if country == "Taiwan "
replace country = "Taiwan" if country == "Taiwan, China"
replace country = "Taiwan" if country == "TaiwanChina"
replace country = "Taiwan" if country == "taiwanchina"
replace country = "Taiwan" if country == "Taiwan Province of China"
replace country = "Taiwan" if country == "TAIWAN"
replace country = "Taiwan" if country == "Taiwan, Republic of China on"
replace imfcode = 528 if country == "Taiwan"
replace country = "Tajikistan" if country == "tajikistan"
replace country = "Tajikistan" if country == "taijikistan"
replace country = "Tajikistan" if country == "Taijikistan"
replace imfcode = 923 if country =="Tajikistan"
replace country = "Tanzania" if country == "tanzania"
replace country = "Tanzania" if country == "TZ"
replace country = "Tanzania" if country == "Tanzania/Tanganyika"
replace imfcode = 738 if country =="Tanzania"
replace country = "Thailand" if country == "thailand"
replace country = "Thailand" if country == "TH"
replace country = "Thailand" if country == "THAILAND"
replace imfcode = 578 if country =="Thailand"
replace country = "Timor-Leste" if country == "Timor-Leste, Dem. Rep. of"
replace country = "Timor-Leste" if country == "East Timor"
replace country = "Timor-Leste" if country == "Timor Leste"
replace country = "Timor-Leste" if country == "East Timor (Timor-Leste)"
replace country = "Timor-Leste" if country == "East Timor (Timor-L'este)"
replace country = "Timor-Leste" if country == "East Timor (Timor L'este)"
replace imfcode = 537 if country =="Timor-Leste"
replace country = "Togo" if country == "togo"
replace imfcode = 742 if country =="Togo"
replace country = "Tonga" if country == "tonga"
replace imfcode = 866 if country =="Tonga"
replace country = "Trinidad and Tobago" if country == "trinidad_tob"
replace country = "Trinidad and Tobago" if country == "TT"
replace country = "Trinidad and Tobago" if country == "trinidadandtobago"
replace country = "Trinidad and Tobago" if country == "Trinidad-Tobago"
replace country = "Trinidad and Tobago" if country == "Trinidad"
replace country = "Trinidad and Tobago" if country == "Trinidad & Tobago"
replace country = "Trinidad and Tobago" if country == "Trinidad And Tobago"
replace country = "Trinidad and Tobago" if country == "TrinidadandTobago"
replace imfcode = 369 if country =="Trinidad and Tobago"
replace country = "Tunisia" if country == "tunisia"
replace imfcode = 744 if country =="Tunisia"
replace country = "Turkey" if country == "turkey"
replace country = "Turkey" if country == "TURKEY"
replace country = "Turkey" if country == "TR"
replace country = "Turkey" if country == "Turkey/Ottoman Empire"
replace imfcode = 186 if country =="Turkey"
replace country = "Turkmenistan" if country == "turkmenistan"
replace imfcode = 925 if country =="Turkmenistan"
replace country = "Uganda" if country == "uganda"
replace country = "Uganda" if country == "UG"
replace imfcode = 746 if country =="Uganda"
replace country = "Ukraine" if country == "ukraine"
replace country = "Ukraine" if country == "UA"
replace imfcode = 926 if country =="Ukraine"
replace country = "United Arab Emirates" if country == "uae"
replace country = "United Arab Emirates" if country == "UnitedArabEmirates"
replace country = "United Arab Emirates" if country == "UAE"
replace imfcode = 466 if country =="United Arab Emirates"
replace country = "United Kingdom" if country == "UK"
replace country = "United Kingdom" if country == "GB"
replace country = "United Kingdom" if country == "uk"
replace country = "United Kingdom" if country == "UNITED KINGDOM"
replace country = "United Kingdom" if country == "UnitedKingdom"
replace country = "United Kingdom" if country == "unitedkingdom"
replace imfcode = 112 if country =="United Kingdom"
replace country = "United States" if country == "us"
replace country = "United States" if country == "UNITED STATES"
replace country = "United States" if country == "US"
replace country = "United States" if country == "USA"
replace country = "United States" if country == "UnitedStates"
replace country = "United States" if country == "unitedstates"
replace country = "United States" if country == "United States of America"
replace imfcode = 111 if country =="United States"
replace country = "USSR" if country == "ussr"
replace country = "Uruguay" if country == "Uraguay"
replace country = "Uruguay" if country == "UY"
replace country = "Uruguay" if country == "uruguay"
replace country = "Uruguay" if country == "URUGUAY"
replace imfcode = 298 if country =="Uruguay"
replace country = "Uzbekistan" if country == "uzbekistan"
replace imfcode = 927 if country =="Uzbekistan"
replace country = "Vanuatu" if country == "vanuatu"
replace imfcode = 846 if country =="Vanuatu"
replace country = "Vatican City" if country == "Vatican"
replace country = "Vatican City" if country == "vatican"
replace country = "Vatican City" if country == "Holy See"
replace country = "Vatican City" if country == "Vatican City State"
replace country = "Venezuela" if country == "venezuela"
replace country = "Venezuela" if country == "VE"
replace country = "Venezuela" if country == "Venezuela, RB"
replace country = "Venezuela" if country == "Venezuela, Rb"
replace country = "Venezuela" if country == "VenezuelaRB"
replace country = "Venezuela" if country == "venezuelarb"
replace country = "Venezuela" if country == " Venezuela, RB "
replace country = "Venezuela" if country == "Venezuela,RB"
replace country = "Venezuela" if country == "VENEZUELA"
replace country = "Venezuela" if country == "Venezuela, R.B. de"
replace imfcode = 299 if country =="Venezuela"
replace country = "Vietnam" if country == "Viet Nam"
replace country = "Vietnam" if country == "viet_nam"
replace country = "Vietnam" if country == "VN"
replace country = "Vietnam" if country == "vietnam"
replace country = "Vietnam" if country == "Vietnam North"
replace country = "Vietnam" if country == "North Vietnam"
replace country = "Vietnam_Dem_Rep" if country == "Vietnam, Democratic Republic of"
replace country = "Vietnam" if country == "Vietnam, Socialist Republic of"
replace imfcode = 582 if country =="Vietnam"
replace country = "Virgin Islands (U.S.)" if country == "virgin_is"
replace country = "Virgin Islands (U.S.)" if country == "virgin islands (U.S.)"
replace country = "Virgin Islands (U.S.)" if country == "VirginIslands(U.S.)"
replace imfcode = . if country =="Virgin Islands (U.S.)"
replace country = "West Bank and Gaza" if country == "west_bank_g"
replace country = "West Bank and Gaza" if country == "wbankgaza"
replace country = "West Bank and Gaza" if country == "WestBankandGaza"
replace country = "West Bank and Gaza" if country == "West Bank And Gaza"
replace country = "West Bank and Gaza" if country == "Palestinian Territories"
replace country = "West Bank and Gaza" if country == "Palestine"
replace country = "West Bank and Gaza" if country == "Palestinian Authority"
replace imfcode = 487 if country =="West Bank and Gaza"
replace country = "Yemen" if country == "yemen"
replace country = "Yemen" if country =="Yemen, Rep."
replace country = "Yemen" if country =="Yemen, Rep."
replace country = "Yemen" if country =="Yemen,Rep."
replace country = "Yemen" if country =="Yemen, Rep. of"
replace country = "Yemen" if country =="Yemen, Republic of"
replace country = "Yemen" if country =="Yemen Arab Republic"
replace imfcode = 474 if country =="Yemen"
replace country = "Yugoslavia" if country == "yugoslavia"
replace country = "Yugoslavia" if country == "Yugoslavia, Federal Republic of"
replace country = "Zambia" if country == "zambia"
replace country = "Zambia" if country == "ZM"
replace imfcode = 754 if country =="Zambia"
replace country = "Zimbabwe" if country == "zimbabwe"
replace country = "Zimbabwe" if country == "ZIMBABWE"
replace country = "Zimbabwe" if country == "ZW"
replace country = "Zimbabwe" if country == "Zimbabwe (Rhodesia)"
replace imfcode = 698 if country == "Zimbabwe"

********************************************************
gen str iso_a3=""
*********************************************************

replace iso_a3 ="AFG" if country =="Afghanistan"
replace iso_a3 ="ALA" if country =="Åland Islands"
replace iso_a3 ="ALB" if country =="Albania"
replace iso_a3 ="" if country =="Alderney"
replace iso_a3 ="DZA" if country =="Algeria"
replace iso_a3 ="ASM" if country =="American Samoa"
replace iso_a3 ="AND" if country =="Andorra"
replace iso_a3 ="AGO" if country =="Angola"
replace iso_a3 ="AIA" if country =="Anguilla"
replace iso_a3 ="ATA" if country =="Antarctica"
replace iso_a3 ="ATG" if country =="Antigua and Barbuda"
replace iso_a3 ="ARG" if country =="Argentina"
replace iso_a3 ="ARM" if country =="Armenia"
replace iso_a3 ="ABW" if country =="Aruba"
replace iso_a3 ="" if country =="Ascension Island"
replace iso_a3 ="AUS" if country =="Australia"
replace iso_a3 ="AUT" if country =="Austria"
replace iso_a3 ="AZE" if country =="Azerbaijan"
replace iso_a3 ="BHS" if country =="Bahamas"
replace iso_a3 ="BHR" if country =="Bahrain"
replace iso_a3 ="BGD" if country =="Bangladesh"
replace iso_a3 ="BRB" if country =="Barbados"
replace iso_a3 ="BLR" if country =="Belarus"
replace iso_a3 ="BEL" if country =="Belgium"
replace iso_a3 ="BLZ" if country =="Belize"
replace iso_a3 ="BEN" if country =="Benin"
replace iso_a3 ="BMU" if country =="Bermuda"
replace iso_a3 ="BTN" if country =="Bhutan"
replace iso_a3 ="BOL" if country =="Bolivia"
replace iso_a3 ="BES" if country =="Bonaire St. Eustatius and Saba"
replace iso_a3 ="BIH" if country =="Bosnia and Herzegovina"
replace iso_a3 ="BWA" if country =="Botswana"
replace iso_a3 ="BVT" if country =="Bouvet Island"
replace iso_a3 ="BRA" if country =="Brazil"
replace iso_a3 ="IOT" if country =="British Indian Ocean Territory"
replace iso_a3 ="BRN" if country =="Brunei Darussalam"
replace iso_a3 ="BGR" if country =="Bulgaria"
replace iso_a3 ="BFA" if country =="Burkina Faso"
replace iso_a3 ="BDI" if country =="Burundi"
replace iso_a3 ="KHM" if country =="Cambodia"
replace iso_a3 ="CMR" if country =="Cameroon"
replace iso_a3 ="CAN" if country =="Canada"
replace iso_a3 ="CPV" if country =="Cabo Verde"
replace iso_a3 ="CYM" if country =="Cayman Islands"
replace iso_a3 ="CAF" if country =="Central African Republic"
replace iso_a3 ="TCD" if country =="Chad"
replace iso_a3 ="CHI" if country =="Channel Islands"
replace iso_a3 ="CHL" if country =="Chile"
replace iso_a3 ="CHN" if country =="China"
replace iso_a3 ="CXR" if country =="Christmas Island"
replace iso_a3 ="CCK" if country =="Cocos Islands"
replace iso_a3 ="COL" if country =="Colombia"
replace iso_a3 ="COM" if country =="Comoros"
replace iso_a3 ="COG" if country =="Congo, Rep."
replace iso_a3 ="COD" if country =="Congo, Dem. Rep."
replace iso_a3 ="COK" if country =="Cook Islands"
replace iso_a3 ="CRI" if country =="Costa Rica"
replace iso_a3 ="CIV" if country =="Cote dIvoire"
replace iso_a3 ="HRV" if country =="Croatia"
replace iso_a3 ="CUB" if country =="Cuba"
replace iso_a3 ="CUW" if country =="Curaçao"
replace iso_a3 ="CYP" if country =="Cyprus"
replace iso_a3 ="CZE" if country =="Czech Republic"
replace iso_a3 ="DNK" if country =="Denmark"
replace iso_a3 ="DJI" if country =="Djibouti"
replace iso_a3 ="DMA" if country =="Dominica"
replace iso_a3 ="DOM" if country =="Dominican Republic"
replace iso_a3 ="ECU" if country =="Ecuador"
replace iso_a3 ="EGY" if country =="Egypt"
replace iso_a3 ="SLV" if country =="El Salvador"
replace iso_a3 ="GNQ" if country =="Equatorial Guinea"
replace iso_a3 ="ERI" if country =="Eritrea"
replace iso_a3 ="EST" if country =="Estonia"
replace iso_a3 ="ETH" if country =="Ethiopia"
replace iso_a3 ="FRO" if country =="Faeroe Islands"
replace iso_a3 ="FLK" if country =="Falkland Islands"
replace iso_a3 ="FJI" if country =="Fiji"
replace iso_a3 ="FIN" if country =="Finland"
replace iso_a3 ="FRA" if country =="France"
replace iso_a3 ="GUF" if country =="French Guiana"
replace iso_a3 ="PYF" if country =="French Polynesia"
replace iso_a3 ="ATF" if country =="French Southern Territories"
replace iso_a3 ="GAB" if country =="Gabon"
replace iso_a3 ="GMB" if country =="Gambia"
replace iso_a3 ="GEO" if country =="Georgia"
replace iso_a3 ="DEU" if country =="Germany"
replace iso_a3 ="GHA" if country =="Ghana"
replace iso_a3 ="GIB" if country =="Gibraltar"
replace iso_a3 ="GRC" if country =="Greece"
replace iso_a3 ="GRL" if country =="Greenland"
replace iso_a3 ="GRD" if country =="Grenada"
replace iso_a3 ="GLP" if country =="Guadeloupe"
replace iso_a3 ="GUM" if country =="Guam"
replace iso_a3 ="GTM" if country =="Guatemala"
replace iso_a3 ="GGY" if country =="Guernsey"
replace iso_a3 ="GIN" if country =="Guinea"
replace iso_a3 ="GNB" if country =="Guinea Bissau"
replace iso_a3 ="GUY" if country =="Guyana"
replace iso_a3 ="HTI" if country =="Haiti"
replace iso_a3 ="HMD" if country =="Heard Island and Mcdonald Islands"
replace iso_a3 ="HND" if country =="Honduras"
replace iso_a3 ="HKG" if country =="Hong Kong"
replace iso_a3 ="HUN" if country =="Hungary"
replace iso_a3 ="ISL" if country =="Iceland"
replace iso_a3 ="IND" if country =="India"
replace iso_a3 ="IDN" if country =="Indonesia"
replace iso_a3 ="IRN" if country =="Iran"
replace iso_a3 ="IRQ" if country =="Iraq"
replace iso_a3 ="IRL" if country =="Ireland"
replace iso_a3 ="IMN" if country =="Isle of Man"
replace iso_a3 ="ISR" if country =="Israel"
replace iso_a3 ="ITA" if country =="Italy"
replace iso_a3 ="JAM" if country =="Jamaica"
replace iso_a3 ="JPN" if country =="Japan"
replace iso_a3 ="JEY" if country =="Jersey"
replace iso_a3 ="JOR" if country =="Jordan"
replace iso_a3 ="KAZ" if country =="Kazakhstan"
replace iso_a3 ="KEN" if country =="Kenya"
replace iso_a3 ="KIR" if country =="Kiribati"
replace iso_a3 ="KSV" if country =="Kosovo"
replace iso_a3 ="PRK" if country =="North Korea"
replace iso_a3 ="KOR" if country =="South Korea"
replace iso_a3 ="KWT" if country =="Kuwait"
replace iso_a3 ="KGZ" if country =="Kyrgyzstan"
replace iso_a3 ="LAO" if country =="Laos"
replace iso_a3 ="LVA" if country =="Latvia"
replace iso_a3 ="LBN" if country =="Lebanon"
replace iso_a3 ="LSO" if country =="Lesotho"
replace iso_a3 ="LBR" if country =="Liberia"
replace iso_a3 ="LBY" if country =="Libya"
replace iso_a3 ="LIE" if country =="Liechtenstein"
replace iso_a3 ="LTU" if country =="Lithuania"
replace iso_a3 ="LUX" if country =="Luxembourg"
replace iso_a3 ="MAC" if country =="Macao"
replace iso_a3 ="MKD" if country =="Macedonia"
replace iso_a3 ="MDG" if country =="Madagascar"
replace iso_a3 ="MWI" if country =="Malawi"
replace iso_a3 ="MYS" if country =="Malaysia"
replace iso_a3 ="MDV" if country =="Maldives"
replace iso_a3 ="MLI" if country =="Mali"
replace iso_a3 ="MLT" if country =="Malta"
replace iso_a3 ="MHL" if country =="Marshall Islands"
replace iso_a3 ="MTQ" if country =="Martinique"
replace iso_a3 ="MRT" if country =="Mauritania"
replace iso_a3 ="MUS" if country =="Mauritius"
replace iso_a3 ="MYT" if country =="Mayotte"
replace iso_a3 ="MEX" if country =="Mexico"
replace iso_a3 ="FSM" if country =="Micronesia"
replace iso_a3 ="MDA" if country =="Moldova"
replace iso_a3 ="MCO" if country =="Monaco"
replace iso_a3 ="MNG" if country =="Mongolia"
replace iso_a3 ="MNE" if country =="Montenegro"
replace iso_a3 ="MSR" if country =="Montserrat"
replace iso_a3 ="MAR" if country =="Morocco"
replace iso_a3 ="MOZ" if country =="Mozambique"
replace iso_a3 ="MMR" if country =="Myanmar"
replace iso_a3 ="NAM" if country =="Namibia"
replace iso_a3 ="NRU" if country =="Nauru"
replace iso_a3 ="NPL" if country =="Nepal"
replace iso_a3 ="NLD" if country =="Netherlands"
replace iso_a3 ="ANT" if country =="Netherlands Antilles"
replace iso_a3 ="NCL" if country =="New Caledonia"
replace iso_a3 ="NZL" if country =="New Zealand"
replace iso_a3 ="NIC" if country =="Nicaragua"
replace iso_a3 ="NER" if country =="Niger"
replace iso_a3 ="NGA" if country =="Nigeria"
replace iso_a3 ="NIU" if country =="Niue"
replace iso_a3 ="NFK" if country =="Norfolk Island"
replace iso_a3 ="MNP" if country =="Northern Mariana Islands"
replace iso_a3 ="NOR" if country =="Norway"
replace iso_a3 ="OMN" if country =="Oman"
replace iso_a3 ="PAK" if country =="Pakistan"
replace iso_a3 ="PLW" if country =="Palau"
replace iso_a3 ="PSE" if country =="Palestinian Territories"
replace iso_a3 ="PAN" if country =="Panama"
replace iso_a3 ="PNG" if country =="Papua New Guinea"
replace iso_a3 ="PRY" if country =="Paraguay"
replace iso_a3 ="PER" if country =="Peru"
replace iso_a3 ="PHL" if country =="Philippines"
replace iso_a3 ="PCN" if country =="Pitcairn"
replace iso_a3 ="POL" if country =="Poland"
replace iso_a3 ="PRT" if country =="Portugal"
replace iso_a3 ="PRI" if country =="Puerto Rico"
replace iso_a3 ="QAT" if country =="Qatar"
replace iso_a3 ="REU" if country =="Réunion"
replace iso_a3 ="ROU" if country =="Romania"
replace iso_a3 ="RUS" if country =="Russian Federation"
replace iso_a3 ="RWA" if country =="Rwanda"
replace iso_a3 ="BLM" if country =="Saint Barthélemy"
replace iso_a3 ="SHN" if country =="Saint Helena"
replace iso_a3 ="KNA" if country =="Saint Kitts and Nevis"
replace iso_a3 ="LCA" if country =="Saint Lucia"
replace iso_a3 ="MAF" if country =="Saint Martin (French part)"
replace iso_a3 ="SPM" if country =="Saint Pierre and Miquelon"
replace iso_a3 ="VCT" if country =="Saint Vincent and the Grenadines"
replace iso_a3 ="WSM" if country =="Samoa"
replace iso_a3 ="SMR" if country =="San Marino"
replace iso_a3 ="STP" if country =="Sao Tome and Principe"
replace iso_a3 ="SAU" if country =="Saudi Arabia"
replace iso_a3 ="SEN" if country =="Senegal"
replace iso_a3 ="SRB" if country =="Serbia"
replace iso_a3 ="SYC" if country =="Seychelles"
replace iso_a3 ="SLE" if country =="Sierra Leone"
replace iso_a3 ="SGP" if country =="Singapore"
replace iso_a3 ="SXM" if country =="Sint Maarten (Dutch part)"
replace iso_a3 ="SVK" if country =="Slovak Republic"
replace iso_a3 ="SVN" if country =="Slovenia"
replace iso_a3 ="SLB" if country =="Solomon Islands"
replace iso_a3 ="SOM" if country =="Somalia"
replace iso_a3 ="ZAF" if country =="South Africa"
replace iso_a3 ="SGS" if country =="South Georgia and The South Sandwich Islands"
replace iso_a3 ="SSD" if country =="South Sudan"
replace iso_a3 ="ESP" if country =="Spain"
replace iso_a3 ="LKA" if country =="Sri Lanka"
replace iso_a3 ="SDN" if country =="Sudan"
replace iso_a3 ="SUR" if country =="Suriname"
replace iso_a3 ="SJM" if country =="Svalbard and Jan Mayen"
replace iso_a3 ="SWZ" if country =="Swaziland"
replace iso_a3 ="SWE" if country =="Sweden"
replace iso_a3 ="CHE" if country =="Switzerland"
replace iso_a3 ="SYR" if country =="Syria"
replace iso_a3 ="TWN" if country =="Taiwan"
replace iso_a3 ="TJK" if country =="Tajikistan"
replace iso_a3 ="TZA" if country =="Tanzania"
replace iso_a3 ="THA" if country =="Thailand"
replace iso_a3 ="TLS" if country =="Timor-Leste"
replace iso_a3 ="TGO" if country =="Togo"
replace iso_a3 ="TKL" if country =="Tokelau"
replace iso_a3 ="TON" if country =="Tonga"
replace iso_a3 ="TTO" if country =="Trinidad and Tobago"
replace iso_a3 ="TUN" if country =="Tunisia"
replace iso_a3 ="TUR" if country =="Turkey"
replace iso_a3 ="TKM" if country =="Turkmenistan"
replace iso_a3 ="TCA" if country =="Turks and Caicos Islands"
replace iso_a3 ="TUV" if country =="Tuvalu"
replace iso_a3 ="UGA" if country =="Uganda"
replace iso_a3 ="UKR" if country =="Ukraine"
replace iso_a3 ="ARE" if country =="United Arab Emirates"
replace iso_a3 ="GBR" if country =="United Kingdom"
replace iso_a3 ="USA" if country =="United States"
replace iso_a3 ="UMI" if country =="United States Minor Outlying Islands"
replace iso_a3 ="URY" if country =="Uruguay"
replace iso_a3 ="UZB" if country =="Uzbekistan"
replace iso_a3 ="VUT" if country =="Vanuatu"
replace iso_a3 ="VAT" if country =="Vatican City"
replace iso_a3 ="VEN" if country =="Venezuela"
replace iso_a3 ="VNM" if country =="Vietnam"
replace iso_a3 ="VGB" if country =="Virgin Islands (British)"
replace iso_a3 ="VIR" if country =="Virgin Islands (U.S.)"
replace iso_a3 ="WLF" if country =="Wallis and Futuna"
replace iso_a3 ="PSE" if country =="West Bank and Gaza"
replace iso_a3 ="YEM" if country =="Yemen"
replace iso_a3 ="ZMB" if country =="Zambia"
replace iso_a3 ="ZWE" if country =="Zimbabwe"

*************************************************************
gen iso_num=.
format %03.0f iso_num
*************************************************************

replace iso_num = 004 if country=="Afghanistan"
replace iso_num = 248 if country=="Åland Islands"
replace iso_num = 008 if country=="Albania"
replace iso_num = . if country=="Alderney"
replace iso_num = 012 if country=="Algeria"
replace iso_num = 016 if country=="American Samoa"
replace iso_num = 020 if country=="Andorra"
replace iso_num = 024 if country=="Angola"
replace iso_num = 660 if country=="Anguilla"
replace iso_num = 010 if country=="Antarctica"
replace iso_num = 028 if country=="Antigua and Barbuda"
replace iso_num = 032 if country=="Argentina"
replace iso_num = 051 if country=="Armenia"
replace iso_num = 533 if country=="Aruba"
replace iso_num = . if country=="Ascension Island"
replace iso_num = 036 if country=="Australia"
replace iso_num = 040 if country=="Austria"
replace iso_num = 031 if country=="Azerbaijan"
replace iso_num = 044 if country=="Bahamas"
replace iso_num = 048 if country=="Bahrain"
replace iso_num = 050 if country=="Bangladesh"
replace iso_num = 052 if country=="Barbados"
replace iso_num = 112 if country=="Belarus"
replace iso_num = 056 if country=="Belgium"
replace iso_num = 084 if country=="Belize"
replace iso_num = 204 if country=="Benin"
replace iso_num = 060 if country=="Bermuda"
replace iso_num = 064 if country=="Bhutan"
replace iso_num = 068 if country=="Bolivia"
replace iso_num = 535 if country=="Bonaire St. Eustatius and Saba"
replace iso_num = 070 if country=="Bosnia and Herzegovina"
replace iso_num = 072 if country=="Botswana"
replace iso_num = 074 if country=="Bouvet Island"
replace iso_num = 076 if country=="Brazil"
replace iso_num = 086 if country=="British Indian Ocean Territory"
replace iso_num = 096 if country=="Brunei Darussalam"
replace iso_num = 100 if country=="Bulgaria"
replace iso_num = 854 if country=="Burkina Faso"
replace iso_num = 108 if country=="Burundi"
replace iso_num = 116 if country=="Cambodia"
replace iso_num = 120 if country=="Cameroon"
replace iso_num = 124 if country=="Canada"
replace iso_num = 132 if country=="Cabo Verde"
replace iso_num = 136 if country=="Cayman Islands"
replace iso_num = 140 if country=="Central African Republic"
replace iso_num = 148 if country=="Chad"
replace iso_num = 830 if country=="Channel Islands"
replace iso_num = 152 if country=="Chile"
replace iso_num = 156 if country=="China"
replace iso_num = 162 if country=="Christmas Island"
replace iso_num = 166 if country=="Cocos Islands"
replace iso_num = 170 if country=="Colombia"
replace iso_num = 174 if country=="Comoros"
replace iso_num = 178 if country=="Congo, Rep."
replace iso_num = 180 if country=="Congo, Dem. Rep."
replace iso_num = 184 if country=="Cook Islands"
replace iso_num = 188 if country=="Costa Rica"
replace iso_num = 384 if country=="Cote dIvoire"
replace iso_num = 191 if country=="Croatia"
replace iso_num = 192 if country=="Cuba"
replace iso_num = 531 if country=="Curaçao"
replace iso_num = 196 if country=="Cyprus"
replace iso_num = 203 if country=="Czech Republic"
replace iso_num = 208 if country=="Denmark"
replace iso_num = 262 if country=="Djibouti"
replace iso_num = 212 if country=="Dominica"
replace iso_num = 214 if country=="Dominican Republic"
replace iso_num = 218 if country=="Ecuador"
replace iso_num = 818 if country=="Egypt"
replace iso_num = 222 if country=="El Salvador"
replace iso_num = 226 if country=="Equatorial Guinea"
replace iso_num = 232 if country=="Eritrea"
replace iso_num = 233 if country=="Estonia"
replace iso_num = 231 if country=="Ethiopia"
replace iso_num = 234 if country=="Faeroe Islands"
replace iso_num = 238 if country=="Falkland Islands"
replace iso_num = 242 if country=="Fiji"
replace iso_num = 246 if country=="Finland"
replace iso_num = 250 if country=="France"
replace iso_num = 254 if country=="French Guiana"
replace iso_num = 258 if country=="French Polynesia"
replace iso_num = 260 if country=="French Southern Territories"
replace iso_num = 266 if country=="Gabon"
replace iso_num = 270 if country=="Gambia"
replace iso_num = 268 if country=="Georgia"
replace iso_num = 276 if country=="Germany"
replace iso_num = 288 if country=="Ghana"
replace iso_num = 292 if country=="Gibraltar"
replace iso_num = 300 if country=="Greece"
replace iso_num = 304 if country=="Greenland"
replace iso_num = 308 if country=="Grenada"
replace iso_num = 312 if country=="Guadeloupe"
replace iso_num = 316 if country=="Guam"
replace iso_num = 320 if country=="Guatemala"
replace iso_num = . if country=="Guernsey"
replace iso_num = 324 if country=="Guinea"
replace iso_num = 624 if country=="Guinea Bissau"
replace iso_num = 328 if country=="Guyana"
replace iso_num = 332 if country=="Haiti"
replace iso_num = 334 if country=="Heard Island and Mcdonald Islands"
replace iso_num = 340 if country=="Honduras"
replace iso_num = 344 if country=="Hong Kong"
replace iso_num = 348 if country=="Hungary"
replace iso_num = 352 if country=="Iceland"
replace iso_num = 356 if country=="India"
replace iso_num = 360 if country=="Indonesia"
replace iso_num = 364 if country=="Iran"
replace iso_num = 368 if country=="Iraq"
replace iso_num = 372 if country=="Ireland"
replace iso_num = 833 if country=="Isle of Man"
replace iso_num = 376 if country=="Israel"
replace iso_num = 380 if country=="Italy"
replace iso_num = 388 if country=="Jamaica"
replace iso_num = 392 if country=="Japan"
replace iso_num = . if country=="Jersey"
replace iso_num = 400 if country=="Jordan"
replace iso_num = 398 if country=="Kazakhstan"
replace iso_num = 404 if country=="Kenya"
replace iso_num = 296 if country=="Kiribati"
replace iso_num = 408 if country=="North Korea"
replace iso_num = 410 if country=="South Korea"
replace iso_num = 414 if country=="Kuwait"
replace iso_num = 417 if country=="Kyrgyzstan"
replace iso_num = 418 if country=="Laos"
replace iso_num = 428 if country=="Latvia"
replace iso_num = 422 if country=="Lebanon"
replace iso_num = 426 if country=="Lesotho"
replace iso_num = 430 if country=="Liberia"
replace iso_num = 434 if country=="Libya"
replace iso_num = 438 if country=="Liechtenstein"
replace iso_num = 440 if country=="Lithuania"
replace iso_num = 442 if country=="Luxembourg"
replace iso_num = 446 if country=="Macao"
replace iso_num = 807 if country=="Macedonia"
replace iso_num = 450 if country=="Madagascar"
replace iso_num = 454 if country=="Malawi"
replace iso_num = 458 if country=="Malaysia"
replace iso_num = 462 if country=="Maldives"
replace iso_num = 466 if country=="Mali"
replace iso_num = 470 if country=="Malta"
replace iso_num = 584 if country=="Marshall Islands"
replace iso_num = 474 if country=="Martinique"
replace iso_num = 478 if country=="Mauritania"
replace iso_num = 480 if country=="Mauritius"
replace iso_num = 175 if country=="Mayotte"
replace iso_num = 484 if country=="Mexico"
replace iso_num = 583 if country=="Micronesia"
replace iso_num = 498 if country=="Moldova"
replace iso_num = 492 if country=="Monaco"
replace iso_num = 496 if country=="Mongolia"
replace iso_num = 499 if country=="Montenegro"
replace iso_num = 500 if country=="Montserrat"
replace iso_num = 504 if country=="Morocco"
replace iso_num = 508 if country=="Mozambique"
replace iso_num = 104 if country=="Myanmar"
replace iso_num = 516 if country=="Namibia"
replace iso_num = 520 if country=="Nauru"
replace iso_num = 524 if country=="Nepal"
replace iso_num = 528 if country=="Netherlands"
replace iso_num = 530 if country=="Netherlands Antilles"
replace iso_num = 540 if country=="New Caledonia"
replace iso_num = 554 if country=="New Zealand"
replace iso_num = 558 if country=="Nicaragua"
replace iso_num = 562 if country=="Niger"
replace iso_num = 566 if country=="Nigeria"
replace iso_num = 570 if country=="Niue"
replace iso_num = 574 if country=="Norfolk Island"
replace iso_num = 580 if country=="Northern Mariana Islands"
replace iso_num = 578 if country=="Norway"
replace iso_num = 512 if country=="Oman"
replace iso_num = 586 if country=="Pakistan"
replace iso_num = 585 if country=="Palau"
replace iso_num = 275 if country=="Palestinian Territories"
replace iso_num = 591 if country=="Panama"
replace iso_num = 598 if country=="Papua New Guinea"
replace iso_num = 600 if country=="Paraguay"
replace iso_num = 604 if country=="Peru"
replace iso_num = 608 if country=="Philippines"
replace iso_num = 612 if country=="Pitcairn"
replace iso_num = 616 if country=="Poland"
replace iso_num = 620 if country=="Portugal"
replace iso_num = 630 if country=="Puerto Rico"
replace iso_num = 634 if country=="Qatar"
replace iso_num = 638 if country=="Réunion"
replace iso_num = 642 if country=="Romania"
replace iso_num = 643 if country=="Russian Federation"
replace iso_num = 646 if country=="Rwanda"
replace iso_num = 652 if country=="Saint Barthélemy"
replace iso_num = 654 if country=="Saint Helena"
replace iso_num = 659 if country=="Saint Kitts and Nevis"
replace iso_num = 662 if country=="Saint Lucia"
replace iso_num = 663 if country=="Saint Martin (French part)"
replace iso_num = 666 if country=="Saint Pierre and Miquelon"
replace iso_num = 670 if country=="Saint Vincent and the Grenadines"
replace iso_num = 882 if country=="Samoa"
replace iso_num = 674 if country=="San Marino"
replace iso_num = 678 if country=="Sao Tome and Principe"
replace iso_num = 682 if country=="Saudi Arabia"
replace iso_num = 686 if country=="Senegal"
replace iso_num = 688 if country=="Serbia"
replace iso_num = 690 if country=="Seychelles"
replace iso_num = 694 if country=="Sierra Leone"
replace iso_num = 702 if country=="Singapore"
replace iso_num = 534 if country=="Sint Maarten (Dutch part)"
replace iso_num = 703 if country=="Slovak Republic"
replace iso_num = 705 if country=="Slovenia"
replace iso_num = 090 if country=="Solomon Islands"
replace iso_num = 706 if country=="Somalia"
replace iso_num = 710 if country=="South Africa"
replace iso_num = 239 if country=="South Georgia and The South Sandwich Islands"
replace iso_num = 728 if country=="South Sudan"
replace iso_num = 724 if country=="Spain"
replace iso_num = 144 if country=="Sri Lanka"
replace iso_num = 736 if country=="Sudan"
replace iso_num = 740 if country=="Suriname"
replace iso_num = 744 if country=="Svalbard and Jan Mayen"
replace iso_num = 748 if country=="Swaziland"
replace iso_num = 752 if country=="Sweden"
replace iso_num = 756 if country=="Switzerland"
replace iso_num = 760 if country=="Syria"
replace iso_num = 158 if country=="Taiwan"
replace iso_num = 762 if country=="Tajikistan"
replace iso_num = 834 if country=="Tanzania"
replace iso_num = 764 if country=="Thailand"
replace iso_num = 626 if country=="Timor-Leste"
replace iso_num = 768 if country=="Togo"
replace iso_num = 772 if country=="Tokelau"
replace iso_num = 776 if country=="Tonga"
replace iso_num = 780 if country=="Trinidad and Tobago"
replace iso_num = 788 if country=="Tunisia"
replace iso_num = 792 if country=="Turkey"
replace iso_num = 795 if country=="Turkmenistan"
replace iso_num = 796 if country=="Turks and Caicos Islands"
replace iso_num = 798 if country=="Tuvalu"
replace iso_num = 800 if country=="Uganda"
replace iso_num = 804 if country=="Ukraine"
replace iso_num = 784 if country=="United Arab Emirates"
replace iso_num = 826 if country=="United Kingdom"
replace iso_num = 840 if country=="United States"
replace iso_num = 581 if country=="United States Minor Outlying Islands"
replace iso_num = 858 if country=="Uruguay"
replace iso_num = 860 if country=="Uzbekistan"
replace iso_num = 548 if country=="Vanuatu"
replace iso_num = 336 if country=="Vatican City"
replace iso_num = 862 if country=="Venezuela"
replace iso_num = 704 if country=="Vietnam"
replace iso_num = 092 if country=="Virgin Islands (British)"
replace iso_num = 850 if country=="Virgin Islands (U.S.)"
replace iso_num = 876 if country=="Wallis and Futuna"
replace iso_num = 275 if country=="West Bank and Gaza"
replace iso_num = 887 if country=="Yemen"
replace iso_num = 894 if country=="Zambia"
replace iso_num = 716 if country=="Zimbabwe"