********************************************************************************************************************************************************************************************************************************* **********************************************************Auslandsaufenthalte in der Berufsausbildung – Befragung von beruflichen Schulen 2017*********************************************************************************** ********************************************************************************************************************************************************************************************************************************* ***********************************************************Konvertierung von Freitextangaben zu Ländern in numerische Werte nach ISO-3166**************************************************************************************** ********************************************************************************************************************************************************************************************************************************* *****************************************************************Volltextdatensatz: Auslandaufenthalte_2017_Berufliche_Schulen_vt ********************************************************************************************************************************************************************************************************************************* * Herkunft: BIBB-FDZ *Stataversion: 17.0 MP *Quelle:Liste der geographischen Regionen nach den Vereinten Nationen: https://unstats.un.org/unsd/methodology/m49/#geo-regions ********************************************************************************************************************************************************************************************************************************* *Ländercodes ISO-3166 numerisch: label define laender 40 "Österreich" /// 56 "Belgien" /// 100 "Bulgarien" /// 76 "Brasilien" /// 124 "Kanada" /// 756 "Schweiz" /// 152 "China" /// 196 "Zypern" /// 203 "Tschechien" /// 208 "Dänemark" /// 218 "Ecuador" /// 233 "Estland" /// 724 "Spanien" /// 246 "Finnland" /// 205 "Frankreich" /// 826 "Vereinigtes Königreich (Großbritannien und Nordirland)" /// 300 "Griechenland" /// 191 "Kroatien" /// 348 "Ungarn" /// 372 "Irland" /// 376 "Israel" /// 352 "Island" /// 380 "Italien" /// 428 "Lettland" /// 807 "Nordmazedonien" /// 470 "Malta" /// 458 "Malaysia" /// 516 "Namibia" /// 528 "Niederlande" /// 578 "Norwegen" /// 616 "Polen" /// 620 "Portugal" /// 642 "Rumänien" /// 690 "Seychellen" /// 752 "Schweden" /// 750 "Slowenien" /// 703 "Slowakei" /// 792 "Türkei" /// 804 "Ukraine" /// 800 "Uganda" /// 840 "USA" /// 710 "Südafrika" /// -9 "keine Angabe" -1 "Filter" foreach var of varlist f13_1 f13_2 f13_3 f13_4 f13_5 f13_6 f13_7 f13_8 f13_9 f13_10{ label values `var' laender replace `var' = 208 if strpos(`var'_GV1, "Dänemark") > 0 replace `var' = 826 if strpos(`var'_GV1, "England") > 0 replace `var' = 246 if strpos(`var'_GV1, "Finnland") > 0 replace `var' = 205 if strpos(`var'_GV1, "Frankreich") > 0 replace `var' = 205 if `var'_GV1 == "F" replace `var' = 826 if strpos(`var'_GV1, "GB") > 0 replace `var' = 826 if strpos(`var'_GV1, "Großbritannien") > 0 replace `var' = 372 if strpos(`var'_GV1, "Irland") > 0 replace `var' = 372 if strpos(`var'_GV1, "Irrland") > 0 replace `var' = 380 if strpos(`var'_GV1, "Italien") > 0 replace `var' = 124 if strpos(`var'_GV1, "Kanada") > 0 replace `var' = 470 if strpos(`var'_GV1, "Malta") > 0 replace `var' = 528 if strpos(`var'_GV1, "Niederlande") > 0 replace `var' = 578 if strpos(`var'_GV1, "Norwegen") > 0 replace `var' = 616 if strpos(`var'_GV1, "Polen") > 0 replace `var' = 642 if strpos(`var'_GV1, "Rumänien") > 0 replace `var' = 826 if strpos(`var'_GV1, "Schottland") > 0 replace `var' = 752 if strpos(`var'_GV1, "Schweden") > 0 replace `var' = 756 if strpos(`var'_GV1, "Schweiz") > 0 replace `var' = 724 if strpos(`var'_GV1, "Spanien") > 0 replace `var' = 710 if strpos(`var'_GV1, "Südafrika") > 0 replace `var' = 203 if strpos(`var'_GV1, "Tschechien") > 0 replace `var' = 792 if strpos(`var'_GV1, "Türkei") > 0 replace `var' = 826 if strpos(`var'_GV1, "UK") > 0 replace `var' = 840 if strpos(`var'_GV1, "USA") > 0 replace `var' = 800 if strpos(`var'_GV1, "Uganda") > 0 replace `var' = 348 if strpos(`var'_GV1, "Ungarn") > 0 replace `var' = 826 if strpos(`var'_GV1, "United Kingdom") > 0 replace `var' = 40 if strpos(`var'_GV1, "Österreich") > 0 replace `var' = 56 if strpos(`var'_GV1, "Belgien") > 0 replace `var' = 76 if strpos(`var'_GV1, "Brasilien") > 0 replace `var' = 233 if strpos(`var'_GV1, "Estland") > 0 replace `var' = 620 if strpos(`var'_GV1, "Portugal") > 0 replace `var' = 100 if strpos(`var'_GV1, "Bulgarien") > 0 replace `var' = 218 if strpos(`var'_GV1, "Ecuador") > 0 replace `var' = 205 if strpos(`var'_GV1, "FR") > 0 replace `var' = 191 if strpos(`var'_GV1, "Kroatien") > 0 replace `var' = 428 if strpos(`var'_GV1, "Lettland") > 0 replace `var' = 516 if strpos(`var'_GV1, "Namibia") > 0 replace `var' = 750 if strpos(`var'_GV1, "Slowenien") > 0 replace `var' = 196 if strpos(`var'_GV1, "Zypern") > 0 replace `var' = 40 if strpos(`var'_GV1, "AT") > 0 replace `var' = 458 if strpos(`var'_GV1, "Malaylsia") > 0 replace `var' = 458 if strpos(`var'_GV1, "Malaysia") > 0 replace `var' = 203 if strpos(`var'_GV1, "Tschechische Republik") > 0 replace `var' = 804 if strpos(`var'_GV1, "Ukraine") > 0 replace `var' = 528 if strpos(`var'_GV1, "NL") > 0 replace `var' = 703 if strpos(`var'_GV1, "Slowakei") > 0 replace `var' = 152 if strpos(`var'_GV1, "China") > 0 replace `var' = 690 if strpos(`var'_GV1, "Seyschellen") > 0 replace `var' = 690 if strpos(`var'_GV1, "Seychellen") > 0 replace `var' = 376 if strpos(`var'_GV1, "Israel") > 0 replace `var' = 300 if strpos(`var'_GV1, "Griechenland") > 0 replace `var' = 352 if strpos(`var'_GV1, "Island") > 0 replace `var' = 807 if strpos(`var'_GV1, "Mazedonien") > 0 replace `var' = -9 if `var'_GV1 == " " replace `var' = -1 if f08==3 } ********************************************************************************