/*nuts3 is an existing string variable that holds nuts-3 codes*/ /*adm is is a string variable that will hold ISO codes (with 201/202 for 2A/2B*/ /*depname is a string varible that holds the name of the respective departement*/ /*Author: Kai Arzheimer, http://www.politik.uni-mainz.de/kai.arzheimer/*/ /*Feel free to modify as necessary*/ gen adm="" gen depname="" replace adm = "01" if nuts3 == "fr711" replace depname = "Ain " if nuts3 == "fr711" replace adm = "02" if nuts3 == "fr221" replace depname = "Aisne " if nuts3 == "fr221" replace adm = "03" if nuts3 == "fr721" replace depname = "Allier " if nuts3 == "fr721" replace adm = "04" if nuts3 == "fr821" replace depname = "Alpes-de-Haute-Provence " if nuts3 == "fr821" replace adm = "06" if nuts3 == "fr823" replace depname = "Alpes-Maritimes " if nuts3 == "fr823" replace adm = "07" if nuts3 == "fr712" replace depname = "Ardèche " if nuts3 == "fr712" replace adm = "08" if nuts3 == "fr211" replace depname = "Ardennes " if nuts3 == "fr211" replace adm = "09" if nuts3 == "fr621" replace depname = "Ariège " if nuts3 == "fr621" replace adm = "10" if nuts3 == "fr212" replace depname = "Aube " if nuts3 == "fr212" replace adm = "11" if nuts3 == "fr811" replace depname = "Aude " if nuts3 == "fr811" replace adm = "12" if nuts3 == "fr622" replace depname = "Aveyron " if nuts3 == "fr622" replace adm = "67" if nuts3 == "fr421" replace depname = "Bas-Rhin " if nuts3 == "fr421" replace adm = "13" if nuts3 == "fr824" replace depname = "Bouches-du-Rhône " if nuts3 == "fr824" replace adm = "14" if nuts3 == "fr251" replace depname = "Calvados " if nuts3 == "fr251" replace adm = "15" if nuts3 == "fr722" replace depname = "Cantal " if nuts3 == "fr722" replace adm = "16" if nuts3 == "fr531" replace depname = "Charente " if nuts3 == "fr531" replace adm = "17" if nuts3 == "fr532" replace depname = "Charente-Maritime " if nuts3 == "fr532" replace adm = "18" if nuts3 == "fr241" replace depname = "Cher " if nuts3 == "fr241" replace adm = "19" if nuts3 == "fr631" replace depname = "Corrèze " if nuts3 == "fr631" replace adm = "201" if nuts3 == "fr831" replace depname = "Corse-du-Sud " if nuts3 == "fr831" replace adm = "21" if nuts3 == "fr261" replace depname = "Côte-d'Or " if nuts3 == "fr261" replace adm = "22" if nuts3 == "fr521" replace depname = "Côtes-d'Armor " if nuts3 == "fr521" replace adm = "23" if nuts3 == "fr632" replace depname = "Creuse " if nuts3 == "fr632" replace adm = "79" if nuts3 == "fr533" replace depname = "Deux-Sèvres " if nuts3 == "fr533" replace adm = "24" if nuts3 == "fr611" replace depname = "Dordogne " if nuts3 == "fr611" replace adm = "25" if nuts3 == "fr431" replace depname = "Doubs " if nuts3 == "fr431" replace adm = "26" if nuts3 == "fr713" replace depname = "Drôme " if nuts3 == "fr713" replace adm = "91" if nuts3 == "fr104" replace depname = "Essonne " if nuts3 == "fr104" replace adm = "27" if nuts3 == "fr231" replace depname = "Eure " if nuts3 == "fr231" replace adm = "28" if nuts3 == "fr242" replace depname = "Eure-et-Loir " if nuts3 == "fr242" replace adm = "29" if nuts3 == "fr522" replace depname = "Finistère " if nuts3 == "fr522" replace adm = "30" if nuts3 == "fr812" replace depname = "Gard " if nuts3 == "fr812" replace adm = "32" if nuts3 == "fr624" replace depname = "Gers " if nuts3 == "fr624" replace adm = "33" if nuts3 == "fr612" replace depname = "Gironde " if nuts3 == "fr612" replace adm = "202" if nuts3 == "fr832" replace depname = "Haute-Corse " if nuts3 == "fr832" replace adm = "31" if nuts3 == "fr623" replace depname = "Haute-Garonne " if nuts3 == "fr623" replace adm = "43" if nuts3 == "fr723" replace depname = "Haute-Loire " if nuts3 == "fr723" replace adm = "52" if nuts3 == "fr214" replace depname = "Haute-Marne " if nuts3 == "fr214" replace adm = "05" if nuts3 == "fr822" replace depname = "Hautes-Alpes " if nuts3 == "fr822" replace adm = "70" if nuts3 == "fr433" replace depname = "Haute-Saône " if nuts3 == "fr433" replace adm = "74" if nuts3 == "fr718" replace depname = "Haute-Savoie " if nuts3 == "fr718" replace adm = "65" if nuts3 == "fr626" replace depname = "Hautes-Pyrénées " if nuts3 == "fr626" replace adm = "87" if nuts3 == "fr633" replace depname = "Haute-Vienne " if nuts3 == "fr633" replace adm = "68" if nuts3 == "fr422" replace depname = "Haut-Rhin " if nuts3 == "fr422" replace adm = "92" if nuts3 == "fr105" replace depname = "Hauts-de-Seine " if nuts3 == "fr105" replace adm = "34" if nuts3 == "fr813" replace depname = "Hérault " if nuts3 == "fr813" replace adm = "35" if nuts3 == "fr523" replace depname = "Ille-et-Vilaine " if nuts3 == "fr523" replace adm = "36" if nuts3 == "fr243" replace depname = "Indre " if nuts3 == "fr243" replace adm = "37" if nuts3 == "fr244" replace depname = "Indre-et-Loire " if nuts3 == "fr244" replace adm = "38" if nuts3 == "fr714" replace depname = "Isère " if nuts3 == "fr714" replace adm = "39" if nuts3 == "fr432" replace depname = "Jura " if nuts3 == "fr432" replace adm = "40" if nuts3 == "fr613" replace depname = "Landes " if nuts3 == "fr613" replace adm = "42" if nuts3 == "fr715" replace depname = "Loire " if nuts3 == "fr715" replace adm = "44" if nuts3 == "fr511" replace depname = "Loire-Atlantique " if nuts3 == "fr511" replace adm = "45" if nuts3 == "fr246" replace depname = "Loiret " if nuts3 == "fr246" replace adm = "41" if nuts3 == "fr245" replace depname = "Loir-et-Cher " if nuts3 == "fr245" replace adm = "46" if nuts3 == "fr625" replace depname = "Lot " if nuts3 == "fr625" replace adm = "47" if nuts3 == "fr614" replace depname = "Lot-et-Garonne " if nuts3 == "fr614" replace adm = "48" if nuts3 == "fr814" replace depname = "Lozère " if nuts3 == "fr814" replace adm = "49" if nuts3 == "fr512" replace depname = "Maine-et-Loire " if nuts3 == "fr512" replace adm = "50" if nuts3 == "fr252" replace depname = "Manche " if nuts3 == "fr252" replace adm = "51" if nuts3 == "fr213" replace depname = "Marne " if nuts3 == "fr213" replace adm = "53" if nuts3 == "fr513" replace depname = "Mayenne " if nuts3 == "fr513" replace adm = "54" if nuts3 == "fr411" replace depname = "Meurthe-et-Moselle " if nuts3 == "fr411" replace adm = "55" if nuts3 == "fr412" replace depname = "Meuse " if nuts3 == "fr412" replace adm = "56" if nuts3 == "fr524" replace depname = "Morbihan " if nuts3 == "fr524" replace adm = "57" if nuts3 == "fr413" replace depname = "Moselle " if nuts3 == "fr413" replace adm = "58" if nuts3 == "fr262" replace depname = "Nièvre " if nuts3 == "fr262" replace adm = "59" if nuts3 == "fr301" replace depname = "Nord " if nuts3 == "fr301" replace adm = "60" if nuts3 == "fr222" replace depname = "Oise " if nuts3 == "fr222" replace adm = "61" if nuts3 == "fr253" replace depname = "Orne " if nuts3 == "fr253" replace adm = "62" if nuts3 == "fr302" replace depname = "Pas-de-Calais " if nuts3 == "fr302" replace adm = "63" if nuts3 == "fr724" replace depname = "Puy-de-Dôme " if nuts3 == "fr724" replace adm = "64" if nuts3 == "fr615" replace depname = "Pyrénées-Atlantiques " if nuts3 == "fr615" replace adm = "66" if nuts3 == "fr815" replace depname = "Pyrénées-Orientales " if nuts3 == "fr815" replace adm = "69" if nuts3 == "fr716" replace depname = "Rhône " if nuts3 == "fr716" replace adm = "71" if nuts3 == "fr263" replace depname = "Saône-et-Loire " if nuts3 == "fr263" replace adm = "72" if nuts3 == "fr514" replace depname = "Sarthe " if nuts3 == "fr514" replace adm = "73" if nuts3 == "fr717" replace depname = "Savoie " if nuts3 == "fr717" replace adm = "77" if nuts3 == "fr102" replace depname = "Seine-et-Marne " if nuts3 == "fr102" replace adm = "76" if nuts3 == "fr232" replace depname = "Seine-Maritime " if nuts3 == "fr232" replace adm = "93" if nuts3 == "fr106" replace depname = "Seine-Saint-Denis " if nuts3 == "fr106" replace adm = "80" if nuts3 == "fr223" replace depname = "Somme " if nuts3 == "fr223" replace adm = "81" if nuts3 == "fr627" replace depname = "Tarn " if nuts3 == "fr627" replace adm = "82" if nuts3 == "fr628" replace depname = "Tarn-et-Garonne " if nuts3 == "fr628" replace adm = "90" if nuts3 == "fr434" replace depname = "Territoire de Belfort " if nuts3 == "fr434" replace adm = "94" if nuts3 == "fr107" replace depname = "Val-de-Marne " if nuts3 == "fr107" replace adm = "95" if nuts3 == "fr108" replace depname = "Val-d'Oise " if nuts3 == "fr108" replace adm = "83" if nuts3 == "fr825" replace depname = "Var " if nuts3 == "fr825" replace adm = "84" if nuts3 == "fr826" replace depname = "Vaucluse " if nuts3 == "fr826" replace adm = "85" if nuts3 == "fr515" replace depname = "Vendée " if nuts3 == "fr515" replace adm = "86" if nuts3 == "fr534" replace depname = "Vienne " if nuts3 == "fr534" replace adm = "75" if nuts3 == "fr101" replace depname = "Ville de Paris " if nuts3 == "fr101" replace adm = "88" if nuts3 == "fr414" replace depname = "Vosges " if nuts3 == "fr414" replace adm = "89" if nuts3 == "fr264" replace depname = "Yonne " if nuts3 == "fr264" replace adm = "78" if nuts3 == "fr103" replace depname = "Yvelines " if nuts3 == "fr103"