The same information in an Excel file.


$title  Correspondence from GTAP 7 aggregate regions to ISO 3166-1 alpha-3 codes

set gtap7       Regions in the GTAP 7 database /
        AUS     Australia
        NZL     New Zealand
        CHN     China
        HKG     Hong Kong
        JPN     Japan
        KOR     Korea
        TWN     Taiwan
        KHM     Cambodia
        IDN     Indonesia
        LAO     Lao People's Democratic Republic
        MMR     Myanmar
        MYS     Malaysia
        PHL     Philippines
        SGP     Singapore
        THA     Thailand
        VNM     Vietnam
        BGD     Bangladesh
        IND     India
        PAK     Pakistan
        LKA     Sri Lanka
        CAN     Canada
        USA     United States of America
        MEX     Mexico
        ARG     Argentina
        BOL     Bolivia
        BRA     Brazil
        CHL     Chile
        COL     Colombia
        ECU     Ecuador
        PRY     Paraguay
        PER     Peru
        URY     Uruguay
        VEN     Venezuela
        CRI     Costa Rica
        GTM     Guatemala
        NIC     Nicaragua
        PAN     Panama
        AUT     Austria
        BEL     Belgium
        CYP     Cyprus
        CZE     Czech Republic
        DNK     Denmark
        EST     Estonia
        FIN     Finland
        FRA     France
        DEU     Germany
        GRC     Greece
        HUN     Hungary
        IRL     Ireland
        ITA     Italy
        LVA     Latvia
        LTU     Lithuania
        LUX     Luxembourg
        MLT     Malta
        NLD     Netherlands
        POL     Poland
        PRT     Portugal
        SVK     Slovakia
        SVN     Slovenia
        ESP     Spain
        SWE     Sweden
        GBR     United Kingdom
        CHE     Switzerland
        NOR     Norway
        ALB     Albania
        BGR     Bulgaria
        BLR     Belarus
        HRV     Croatia
        ROU     Romania
        RUS     Russian Federation
        UKR     Ukraine
        KAZ     Kazakhstan
        KGZ     Kyrgyzstan
        ARM     Armenia
        AZE     Azerbaijan
        GEO     Georgia
        IRN     Iran, Islamic Republic of
        TUR     Turkey
        EGY     Egypt
        MAR     Morocco
        TUN     Tunisia
        NGA     Nigeria
        SEN     Senegal
        ETH     Ethiopia
        MDG     Madagascar
        MWI     Malawi
        MUS     Mauritius
        MOZ     Mozambique
        TZA     Tanzania
        UGA     Uganda
        ZMB     Zambia
        ZWE     Zimbabwe
        BWA     Botswana
        ZAF     South Africa

*       Aggregated regions:

        XOC     Rest of Oceania
        XEA     Rest of East Asia
        XSA     Rest of South Asia
        XSE     Rest of Southeast Asia
        XNA     Rest of North America
        XSM     Rest of South America
        XCA     Rest of Central America
        XCB     Caribbean
        XEF     Rest of EFTA
        XEE     Rest of Eastern Europe
        XER     Rest of Europe
        XSU     Rest of Former Soviet Union
        XWS     Rest of Western Asia
        XNF     Rest of North Africa
        XWF     Rest of Western Africa
        XCF     Rest of Central Africa
        XAC     Rest of South Central Africa
        XEC     Rest of Eastern Africa
        XSC     Rest of South African Customs Union /;


set     iso3 ISO 3166-1 alpha-3 codes /

*       http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3

*       Below is a complete list of the current officially assigned ISO 3166-1
*       alpha-3 codes, with country names being English short country names
*       officially used by the ISO 3166 Maintenance Agency (ISO 3166/MA):

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

*       Transitional reserved code elements are codes which were withdrawn
*       from ISO 3166-1, but maintained during a transitional period (usually
*       for at least five years) while new code elements that may have
*       replaced them are taken into use, for the sake of users who still need
*       to refer to the former entity or whose systems have not yet been
*       updated to refer to the new code. The following alpha-3 codes are
*       subject to a transitional reservation:

        BUR     "Burma",
        BYS     "Byelorussian S.S.R.",
        NTZ     "Neutral Zone",
        ROM     "Romania — Code changed to ROU on 2002-02-01",
        SCG     "Serbia and Montenegro",
        TMP     "East Timor",
        YUG     "Yugoslavia",
        ZAR     "Zaire" /;


set gtapmap(gtap7,iso3)   Mappings from GTAP7 to ISO3 /

*       Only list the aggregated regions:

$eolcom !
        XOC.(   !       Rest of Oceania
                ASM     ! - American Samoa
                COK     ! - Cook Islands
                FJI     ! - Fiji
                PYF     ! - French Polynesia
                GUM     ! - Guam
                KIR     ! - Kiribati
                MHL     ! - Marshall Islands
                FSM     ! - Micronesia, Federated States of
                NRU     ! - Nauru
                NCL     ! - New Caledonia
                NFK     ! - Norfolk Island
                MNP     ! - Northern Mariana Islands
                NIU     ! - Niue
                PLW     ! - Palau
                PNG     ! - Papua New Guinea
                WSM     ! - Samoa
                SLB     ! - Solomon Islands
                TKL     ! - Tokelau
                TON     ! - Tonga
                TUV     ! - Tuvalu
                VUT     ! - Vanuatu
                WLF     ! - Island of Wallis and Futuna
        ),
        XEA.(   !       Rest of East Asia
                MAC     ! - Macau
                MNG     ! - Mongolia
                PRK     ! - Korea, Democratic Republic of
        ),
        XSE.(   !       Rest of Southeast Asia
                BRN     ! - Brunei Darassalam
                TLS     ! - Timor Leste
        ),
        XSA.(   !       Rest of South Asia
                AFG     ! - Afghanistan
                BTN     ! - Bhutan
                MDV     ! - Maldives
                NPL     ! - Nepal
        )
        XNA.(   ! Rest of North America
                BMU     ! - Bermuda
                GRL     ! - Greenland
                SPM     ! - Saint Pierre and Miquelon
        )
        XSM.(   ! Rest of South America
                FLK     ! - Falkland Islands (Malvinas)
                GUF     ! - French Guiana
                GUY     ! - Guyana
                SUR     ! - Suriname
        ),
        XCA.(   ! Rest of Central America
                BLZ     ! - Belize
                SLV     ! - El Salvador
                HND     ! - Honduras
        ),
        XCB.(   ! Caribbean
                VCT     ! - Saint Vincent and the Grenadines
                TTO     ! - Trinidad and Tobago
                TCA     ! - Turks and Caicos
                ATG     ! - Antigua & Barbuda
                ABW     ! - Aruba
                BHS     ! - Bahamas
                BRB     ! - Barbados
                CYM     ! - Cayman Islands
                CUB     ! - Cuba
                DMA     ! - Dominica
                DOM     ! - Dominican Republic
                GRD     ! - Grenada
                GLP     ! - Guadeloupe
                HTI     ! - Haiti
                JAM     ! - Jamaica
                MTQ     ! - Martinique
                MSR     ! - Montserrat
                ANT     ! - Netherlands Antilles
                PRI     ! - Puerto Rico
                KNA     ! - Saint Kitts and Nevis
                AIA     ! - Anguilla
                LCA     ! - Saint Lucia
                VGB     ! - Virgin Islands, British
                VIR     ! - Virgin Islands, U.S.
        ),
        XEF.(   ! Rest of EFTA
                ISL     ! - Iceland
                LIE     ! - Liechtenstein
        ),
        XEE.(   ! Rest of Eastern Europe
                MDA     ! - Moldova, Republic of
        ),
        XER.(   ! Rest of Europe
                AND     ! - Andorra
                BIH     ! - Bosnia and Herzegovina
                FRO     ! - Faroe Islands
                GIB     ! - Gibraltar
                MKD     ! - Macedonia, the former Yugoslav Republic of
                MCO     ! - Monaco
                SMR     ! - San Marino
                SCG     ! - Serbia and Montenegro
        ),
        XSU.(   ! Rest of Former Soviet Union
                TJK     ! - Tajikistan
                TKM     ! - Turkmenistan
                UZB     ! - Uzbekistan
        ),
        XWS.(   ! Rest of Western Asia
                BHR     ! - Bahrain
                IRQ     ! - Iraq
                ISR     ! - Israel
                JOR     ! - Jordan
                KWT     ! - Kuwait
                LBN     ! - Lebanon
                PSE     ! - Palestinian Territory, Occupied
                OMN     ! - Oman
                QAT     ! - Qatar
                SAU     ! - Saudi Arabia
                SYR     ! - Syrian Arab Republic
                ARE     ! - United Arab Emirates
                YEM     ! - Yemen
        ),
        XNF.(   ! Rest of North Africa
                DZA     ! - Algeria
                LBY     ! - Libyan Arab Jamahiriya
        ),
        XWF.(   ! Rest of Western Africa
                BEN     ! - Benin
                BFA     ! - Burkina Faso
                CPV     ! - Cape Verde
                CIV     ! - Cote d'Ivoire
                GMB     ! - Gambia
                GHA     ! - Ghana
                GIN     ! - Guinea
                GNB     ! - Guinea-Bissau
                LBR     ! - Liberia
                MLI     ! - Mali
                MRT     ! - Mauritania
                NER     ! - Niger
                SHN     ! - Saint Helena
                SLE     ! - Sierra Leone
                TGO     ! - Togo
        ),
        XCF.(   ! Rest of Central Africa
                CMR     ! - Cameroon
                CAF     ! - Central African Republic
                TCD     ! - Chad
                COG     ! - Congo
                GNQ     ! - Equatorial Guinea
                GAB     ! - Gabon
                STP     ! - Sao Tome and Principe
        ),
        XAC.(   ! Rest of South Central Africa
                AGO     ! - Angola
                COD     ! - Congo, Democratic Republic of the
        ),
        XEC.(   ! Rest of Eastern Africa
                BDI     ! - Burundi
                COM     ! - Comoros
                DJI     ! - Djibouti
                ERI     ! - Eritrea
                KEN     ! - Kenya
                MYT     ! - Mayotte
                REU     ! - Reunion
                RWA     ! - Rwanda
                SYC     ! - Seychelles
                SOM     ! - Somalia
                SDN     ! - Sudan
        ),
        XSC.(   ! Rest of South African Customs Union
                LSO     ! - Lesotho
                NAM     ! - Namibia
                SWZ     ! - Swaziland
        ) /;

*       Include GTAP regions which are explicitly ISO3:

gtapmap(gtap7,iso3)$sameas(gtap7,iso3) = yes;

PARAMETER       bug(iso3)       Regions mapped more than once (bugs);
bug(iso3) = max(0, sum(gtapmap(gtap7,iso3),1)-1);
abort$card(bug) bug;