* Kreise zu Arbeitsmarktregionen aggregieren #del; label define amr 0 "0 Ausland" 1 "1 Kiel" 2 "2 Lübeck" 3 "3 Dithmarschen" 4 "4 Flensburg" 5 "5 Hamburg" 6 "6 Braunschweig" 7 "7 Wolfsburg" 8 "8 Göttingen" 9 "9 Goslar" 10 "10 Hannover" 11 "11 Hameln" 12 "12 Celle" 13 "13 Löchow-Dannenberg" 14 "14 Stade" 15 "15 Uelzen" 16 "16 Emden" 17 "17 Oldenburg" 18 "18 Osnabrück" 19 "19 Emsland" 20 "20 Wilhelmshaven" 21 "21 Vechta" 22 "22 Bremen" 23 "23 Bremerhaven" 24 "24 Düsseldorf" 25 "25 Essen" 26 "26 Wuppertal" 27 "27 Kleve" 28 "28 Bonn" 29 "29 Köln" 30 "30 Aachen" 31 "31 Olpe" 32 "32 Münster" 33 "33 Borken" 34 "34 Bielefeld" 35 "35 Höxter" 36 "36 Minden" 37 "37 Bochum" 38 "38 Dortmund" 39 "39 Hagen" 40 "40 Siegen" 41 "41 Soest" 42 "42 Darmstadt" 43 "43 Frankfurt/M" 44 "44 Gießen" 45 "45 Limburg-Weilburg" 46 "46 Kassel" 47 "47 Fulda" 48 "48 Waldeck-Frankenberg" 49 "49 Koblenz" 50 "50 Altenkirchen" 51 "51 Bad Kreuznach" 52 "52 Bitburg" 53 "53 Vulkaneifel" 54 "54 Trier" 55 "55 Kaiserslautern" 56 "56 Landau" 57 "57 Ludwigshafen" 58 "58 Mainz" 59 "59 Stuttgart" 60 "60 Böblingen" 61 "61 Göppingen" 62 "62 Heilbronn" 63 "63 Schwäsch Hall" 64 "64 Heidenheim" 65 "65 Karlsruhe" 66 "66 Heidelberg" 67 "67 Pforzheim" 68 "68 Freiburg" 69 "69 Ortenaukreis" 70 "70 Rottweil" 71 "71 Konstanz" 72 "72 Lörrach" 73 "73 Waldshut" 74 "74 Reutlingen" 75 "75 Zollernalbkreis" 76 "76 Ulm" 77 "77 Ravensburg" 78 "78 Sigmaringen" 79 "79 Ingolstadt" 80 "80 München" 81 "81 Altötting" 82 "82 Traunstein" 83 "83 Weilheim-Schongau" 84 "84 Deggendorf" 85 "85 Freyung-Grafenau" 86 "86 Passau" 87 "87 Landshut" 88 "88 Cham" 89 "89 Amberg" 90 "90 Regensburg" 91 "91 Bamberg" 92 "92 Bayreuth" 93 "93 Coburg" 94 "94 Hof" 95 "95 Kronach" 96 "96 Erlangen" 97 "97 Nürnberg" 98 "98 Ansbach" 99 "99 Weißenburg-Gunzenhausen" 100 "100 Aschaffenburg" 101 "101 Schweinfurt" 102 "102 Würzburg" 103 "103 Augsburg" 104 "104 Memmingen" 105 "105 Donau-Ries" 106 "106 Kempten" 107 "107 Saarbrücken" 108 "108 Pirmasens" 109 "109 Berlin" 110 "110 Frankfurt (Oder)" 111 "111 Elbe-Elster" 112 "112 Havelland" 113 "113 Märkisch-Oderland" 114 "114 Oberhavel" 115 "115 Ostprignitz-Ruppin" 116 "116 Potsdam-Mittelmark" 117 "117 Prignitz" 118 "118 Cottbus" 119 "119 Teltow-Fläming" 120 "120 Uckermark" 121 "121 Schwerin" 122 "122 Mecklenburgische Seenplatte" 123 "123 Rostock" 124 "124 Nordvorpommern" 125 "125 Südvorpommern" 126 "126 Chemnitz" 127 "127 Dresden" 128 "128 Bautzen" 129 "129 Leipzig" 130 "130 Dessau-Roßlau" 131 "131 Magdeburg" 132 "132 Halle" 133 "133 Stendal" 134 "134 Erfurt" 135 "135 Gera" 136 "136 Jena" 137 "137 Nordhausen" 138 "138 Eisenach" 139 "139 Unstrut-Hainich" 140 "140 Suhl" 141 "141 Saalfeld-Rudolstadt", replace; #del cr ; gen amr=. replace amr = 1 if krs_num == 1002 | krs_num == 1004 | krs_num == 1057 | krs_num == 1058 replace amr = 2 if krs_num == 1003 | krs_num == 1055 replace amr = 3 if krs_num == 1051 replace amr = 4 if krs_num == 1001 | krs_num == 1054 | krs_num == 1059 replace amr = 5 if krs_num == 1053 | krs_num == 1056 | krs_num == 1060 | krs_num == 1061 | krs_num == 1062 | krs_num == 2000 | krs_num == 3353 | krs_num == 3355 replace amr = 6 if krs_num == 3101 | krs_num == 3102 | krs_num == 3157 | krs_num == 3158 replace amr = 7 if krs_num == 3103 | krs_num == 3151 | krs_num == 3154 replace amr = 8 if krs_num == 3152 | krs_num == 3155 | krs_num == 16061 replace amr = 9 if krs_num == 3153 | krs_num == 3156 | krs_num == 15085 | krs_num == 15319 | krs_num == 15357 | krs_num == 15332 | krs_num == 15364 | krs_num == 15343 | krs_num == 15369 replace amr = 10 if krs_num == 3241 | krs_num == 3254 | krs_num == 3257 | krs_num == 3358 | krs_num == 3201 | krs_num == 3253 replace amr = 11 if krs_num == 3252 | krs_num == 3255 replace amr = 12 if krs_num == 3351 replace amr = 13 if krs_num == 3354 | krs_num == 15081 | krs_num == 15316 | krs_num == 15325 | krs_num == 15336 | krs_num == 15370 replace amr = 14 if krs_num == 3359 replace amr = 15 if krs_num == 3360 replace amr = 16 if krs_num == 3402 | krs_num == 3452 | krs_num == 3457 replace amr = 17 if krs_num == 3403 | krs_num == 3451 | krs_num == 3458 | krs_num == 3461 replace amr = 18 if krs_num == 3404 | krs_num == 3459 replace amr = 19 if krs_num == 3454 | krs_num == 3456 replace amr = 20 if krs_num == 3405 | krs_num == 3455 | krs_num == 3462 replace amr = 21 if krs_num == 3453 | krs_num == 3460 replace amr = 22 if krs_num == 3251 | krs_num == 3356 | krs_num == 3357 | krs_num == 3361 | krs_num == 3401 | krs_num == 4011 replace amr = 23 if krs_num == 3352 | krs_num == 4012 replace amr = 24 if krs_num == 5111 | krs_num == 5114 | krs_num == 5116 | krs_num == 5158 | krs_num == 5162 | krs_num == 5166 replace amr = 25 if krs_num == 5112 | krs_num == 5113 | krs_num == 5117 | krs_num == 5119 | krs_num == 5170 | krs_num == 5512 replace amr = 26 if krs_num == 5120 | krs_num == 5122 | krs_num == 5124 replace amr = 27 if krs_num == 5154 replace amr = 28 if krs_num == 5314 | krs_num == 5382 | krs_num == 7131 replace amr = 29 if krs_num == 5315 | krs_num == 5316 | krs_num == 5362 | krs_num == 5366 | krs_num == 5378 replace amr = 30 if krs_num == 5334 | krs_num == 5358 | krs_num == 5370 | krs_num == 5354 | krs_num == 5313 replace amr = 31 if krs_num == 5374 | krs_num == 5966 replace amr = 32 if krs_num == 5515 | krs_num == 5558 | krs_num == 5566 | krs_num == 5570 replace amr = 33 if krs_num == 5554 replace amr = 34 if krs_num == 5711 | krs_num == 5754 | krs_num == 5766 replace amr = 35 if krs_num == 5762 replace amr = 36 if krs_num == 3256 | krs_num == 5758 | krs_num == 5770 replace amr = 37 if krs_num == 5513 | krs_num == 5562 | krs_num == 5911 | krs_num == 5916 replace amr = 38 if krs_num == 5913 | krs_num == 5915 | krs_num == 5978 replace amr = 39 if krs_num == 5914 | krs_num == 5954 | krs_num == 5962 replace amr = 40 if krs_num == 5970 replace amr = 41 if krs_num == 5774 | krs_num == 5958 | krs_num == 5974 replace amr = 42 if krs_num == 6411 | krs_num == 6432 | krs_num == 6437 replace amr = 43 if krs_num == 6412 | krs_num == 6413 | krs_num == 6433 | krs_num == 6434 | krs_num == 6435 | krs_num == 6436 | krs_num == 6438 | krs_num == 6440 replace amr = 44 if krs_num == 6531 | krs_num == 6532 | krs_num == 6534 replace amr = 45 if krs_num == 6439 | krs_num == 6533 replace amr = 46 if krs_num == 6611 | krs_num == 6633 | krs_num == 6634 | krs_num == 6636 replace amr = 47 if krs_num == 6535 | krs_num == 6631 | krs_num == 6632 replace amr = 48 if krs_num == 6635 replace amr = 49 if krs_num == 7111 | krs_num == 7135 | krs_num == 7137 | krs_num == 7138 | krs_num == 7140 | krs_num == 7141 | krs_num == 7143 replace amr = 50 if krs_num == 7132 replace amr = 51 if krs_num == 7133 | krs_num == 7134 replace amr = 52 if krs_num == 7232 replace amr = 53 if krs_num == 7233 replace amr = 54 if krs_num == 7211 | krs_num == 7231 | krs_num == 7235 replace amr = 55 if krs_num == 7312 | krs_num == 7333 | krs_num == 7335 | krs_num == 7336 replace amr = 56 if krs_num == 7313 | krs_num == 7334 | krs_num == 7337 replace amr = 57 if krs_num == 7311 | krs_num == 7314 | krs_num == 7316 | krs_num == 7318 | krs_num == 7319 | krs_num == 7332 | krs_num == 7338 | krs_num == 8222 replace amr = 58 if krs_num == 6414 | krs_num == 7315 | krs_num == 7331 | krs_num == 7339 replace amr = 59 if krs_num == 8111 | krs_num == 8116 | krs_num == 8118 | krs_num == 8119 replace amr = 60 if krs_num == 8115 | krs_num == 8235 | krs_num == 8237 replace amr = 61 if krs_num == 8117 replace amr = 62 if krs_num == 8121 | krs_num == 8125 | krs_num == 8126 | krs_num == 8225 replace amr = 63 if krs_num == 8127 replace amr = 64 if krs_num == 8135 | krs_num == 8136 | krs_num == 9773 replace amr = 65 if krs_num == 8211 | krs_num == 8212 | krs_num == 8215 | krs_num == 8216 replace amr = 66 if krs_num == 6431 | krs_num == 8221 | krs_num == 8226 replace amr = 67 if krs_num == 8231 | krs_num == 8236 replace amr = 68 if krs_num == 8311 | krs_num == 8315 | krs_num == 8316 replace amr = 69 if krs_num == 8317 replace amr = 70 if krs_num == 8325 | krs_num == 8326 | krs_num == 8327 replace amr = 71 if krs_num == 8335 replace amr = 72 if krs_num == 8336 replace amr = 73 if krs_num == 8337 replace amr = 74 if krs_num == 8415 | krs_num == 8416 replace amr = 75 if krs_num == 8417 replace amr = 76 if krs_num == 8421 | krs_num == 8425 | krs_num == 9774 | krs_num == 9775 replace amr = 77 if krs_num == 8426 | krs_num == 8435 | krs_num == 8436 | krs_num == 9776 replace amr = 78 if krs_num == 8437 replace amr = 79 if krs_num == 9161 | krs_num == 9176 | krs_num == 9185 | krs_num == 9186 replace amr = 80 if krs_num == 9162 | krs_num == 9173 | krs_num == 9174 | krs_num == 9175 | krs_num == 9177 | krs_num == 9178 | krs_num == 9179 | krs_num == 9181 | krs_num == 9182 | krs_num == 9184 | krs_num == 9188 replace amr = 81 if krs_num == 9171 | krs_num == 9183 | krs_num == 9277 replace amr = 82 if krs_num == 9163 | krs_num == 9172 | krs_num == 9187 | krs_num == 9189 replace amr = 83 if krs_num == 9180 | krs_num == 9190 replace amr = 84 if krs_num == 9271 | krs_num == 9276 replace amr = 85 if krs_num == 9272 replace amr = 86 if krs_num == 9262 | krs_num == 9275 replace amr = 87 if krs_num == 9261 | krs_num == 9263 | krs_num == 9274 | krs_num == 9278 | krs_num == 9279 replace amr = 88 if krs_num == 9372 replace amr = 89 if krs_num == 9361 | krs_num == 9363 | krs_num == 9371 | krs_num == 9374 | krs_num == 9377 replace amr = 90 if krs_num == 9273 | krs_num == 9362 | krs_num == 9375 | krs_num == 9376 replace amr = 91 if krs_num == 9461 | krs_num == 9471 | krs_num == 9674 replace amr = 92 if krs_num == 9462 | krs_num == 9472 | krs_num == 9477 replace amr = 93 if krs_num == 9463 | krs_num == 9473 | krs_num == 9478 | krs_num == 16072 replace amr = 94 if krs_num == 9464 | krs_num == 9475 | krs_num == 9479 | krs_num == 14523 | krs_num == 14166 | krs_num == 14178 replace amr = 95 if krs_num == 9476 replace amr = 96 if krs_num == 9474 | krs_num == 9562 | krs_num == 9572 | krs_num == 9575 replace amr = 97 if krs_num == 9373 | krs_num == 9563 | krs_num == 9564 | krs_num == 9565 | krs_num == 9573 | krs_num == 9574 | krs_num == 9576 replace amr = 98 if krs_num == 9561 | krs_num == 9571 replace amr = 99 if krs_num == 9577 replace amr = 100 if krs_num == 9661 | krs_num == 9671 | krs_num == 9676 replace amr = 101 if krs_num == 9662 | krs_num == 9672 | krs_num == 9673 | krs_num == 9678 replace amr = 102 if krs_num == 8128 | krs_num == 9663 | krs_num == 9675 | krs_num == 9677 | krs_num == 9679 replace amr = 103 if krs_num == 9761 | krs_num == 9771 | krs_num == 9772 replace amr = 104 if krs_num == 9764 | krs_num == 9778 replace amr = 105 if krs_num == 9779 replace amr = 106 if krs_num == 9762 | krs_num == 9763 | krs_num == 9777 | krs_num == 9780 replace amr = 107 if krs_num == 10041 | krs_num == 10042 | krs_num == 10043 | krs_num == 10044 | krs_num == 10046 replace amr = 108 if krs_num == 7317 | krs_num == 7320 | krs_num == 7340 | krs_num == 10045 replace amr = 109 if krs_num == 11000 | krs_num == 12054 | krs_num == 12060 | krs_num == 12061 | krs_num == 11100 | krs_num == 11200 replace amr = 110 if krs_num == 12053 | krs_num == 12067 replace amr = 111 if krs_num == 12062 | krs_num == 12066 replace amr = 112 if krs_num == 12063 replace amr = 113 if krs_num == 12064 replace amr = 114 if krs_num == 12065 replace amr = 115 if krs_num == 12068 replace amr = 116 if krs_num == 12051 | krs_num == 12069 replace amr = 117 if krs_num == 12070 replace amr = 118 if krs_num == 12052 | krs_num == 12071 replace amr = 119 if krs_num == 12072 replace amr = 120 if krs_num == 12073 replace amr = 121 if krs_num == 13004 | krs_num == 13074 | krs_num == 13076 | krs_num == 13060 | krs_num == 13058 | krs_num == 13054 replace amr = 122 if krs_num == 13071 | krs_num == 13055 | krs_num == 13056 | krs_num == 13052 | krs_num == 13002 replace amr = 123 if krs_num == 13003 | krs_num == 13072 | krs_num == 13053 | krs_num == 13051 | krs_num == 13006 replace amr = 124 if krs_num == 13073 | krs_num == 13005 | krs_num == 13061 | krs_num == 13057 replace amr = 125 if krs_num == 13075 | krs_num == 13001 | krs_num == 13059 | krs_num == 13062 replace amr = 126 if krs_num == 14511 | krs_num == 14521 | krs_num == 14522 | krs_num == 14524 | krs_num == 14161 | krs_num == 14167 | krs_num == 14171 | krs_num == 14173 | krs_num == 14177 | krs_num == 14181 | krs_num == 14182 | krs_num == 14188 | krs_num == 14191 | krs_num == 14193 | krs_num == 14375 replace amr = 127 if krs_num == 14612 | krs_num == 14627 | krs_num == 14628 | krs_num == 14090 | krs_num == 14262 | krs_num == 14280 | krs_num == 14285 | krs_num == 14287 | krs_num == 14290 replace amr = 128 if krs_num == 14625 | krs_num == 14626 | krs_num == 14263 | krs_num == 14264 | krs_num == 14272 | krs_num == 14284 | krs_num == 14286 | krs_num == 14292 replace amr = 129 if krs_num == 14713 | krs_num == 14729 | krs_num == 14730 | krs_num == 14365 | krs_num == 14374 | krs_num == 14379 | krs_num == 14383 | krs_num == 14389 replace amr = 130 if krs_num == 15001 | krs_num == 15082 | krs_num == 15091 | krs_num == 15101 | krs_num == 15151 | krs_num == 15154 | krs_num == 15159 | krs_num == 15171 replace amr = 131 if krs_num == 15003 | krs_num == 15083 | krs_num == 15086 | krs_num == 15089 | krs_num == 15153 | krs_num == 15211 | krs_num == 15303 | krs_num == 15314 | krs_num == 15317 | krs_num == 15320 | krs_num == 15330 | krs_num == 15338 | krs_num == 15367 | krs_num == 15339 | krs_num == 15341 | krs_num == 15345 | krs_num == 15352 | krs_num == 15355 | krs_num == 15358 replace amr = 132 if krs_num == 15002 | krs_num == 15084 | krs_num == 15087 | krs_num == 15088 | krs_num == 15202 | krs_num == 15215 | krs_num == 15222 | krs_num == 15223 | krs_num == 15227 | krs_num == 15228 | krs_num == 15229 | krs_num == 15233 | krs_num == 15235 | krs_num == 15237 | krs_num == 15242 | krs_num == 15246 | krs_num == 15256 | krs_num == 15260 | krs_num == 15261 | krs_num == 15265 | krs_num == 15266 | krs_num == 15268 replace amr = 133 if krs_num == 15090 | krs_num == 15321 | krs_num == 15331 | krs_num == 15340 | krs_num == 15363 | krs_num == 15362 replace amr = 134 if krs_num == 16051 | krs_num == 16055 | krs_num == 16067 | krs_num == 16068 | krs_num == 16070 | krs_num == 16071 replace amr = 135 if krs_num == 16052 | krs_num == 16076 | krs_num == 16077 replace amr = 136 if krs_num == 16053 | krs_num == 16074 replace amr = 137 if krs_num == 16062 | krs_num == 16065 replace amr = 138 if krs_num == 16056 | krs_num == 16063 replace amr = 139 if krs_num == 16064 replace amr = 140 if krs_num == 16054 | krs_num == 16066 | krs_num == 16069 replace amr = 141 if krs_num == 16073 | krs_num == 16075 replace amr = 0 if krs_num==0 | (krs_num >= 100 & krs_num < 1000) replace amr=krs_num if krs_num<0 label values amr amr * Kreise zu Regionstypen aggregieren (feine und grobe Abgrenzung) gen rtyp_fein=. replace rtyp_fein=1 if inlist(krs_num,5111,5112,5113,5114,5116,5117,5119,5120,5122,5124,5154,5158,5162,5166,5170,5314,5315,5316,5334,5354,5313,5358,5362,5366,5370,5374,5378,5382,5512,5513,5562,5711,5754,5758,5766,5770,5911,5913,5914,5915,5916,5954,5962,5978,6411,6412,6413,6414,6431,6432,6433,6434,6435,6436,6437,6438,6439,6440,7311,7313,7314,7316,7318,7332,7334,7337,7338,8111,8115,8116,8117,8118,8119,8211,8212,8215,8216,8221,8222,8225,8226,10041,10042,10043,10044,10045,10046) replace rtyp_fein=2 if inlist(krs_num,1053,1056,1060,1062,2000,3241,3201,3253,3251,3256,3257,3353,3356,3357,3359,3361,3401,4011,9162,9174,9175,9177,9178,9179,9181,9184,9188,9562,9563,9564,9565,9572,9573,9574,9576,11000,11100,11200,12051,12053,12054,12060,12061,12063,12064,12065,12067,12069,12072,14612,14627,14628,14713,14729,14730,14090,14262,14280,14285,14287,14290,14365,14374,14379,14383,14389,15124) replace rtyp_fein=3 if inlist(krs_num,1002,1003,1004,1055,1057,1058,3101,3102,3103,3151,3153,3154,3157,3158,3252,3254,3404,3459,3460,5515,5554,5558,5566,5570,5966,5970,7133,7134,7315,7319,7331,7339,8135,8136,8231,8235,8236,8237,8311,8315,8316,8317,8335,8336,8337,8415,8416,8417,9661,9671,9676,9761,9771,9772,9773,9779,14511,14521,14522,14523,14524,14001,14161,14166,14167,14171,14173,14177,14178,14181,14182,14188,14191,14193,14375) replace rtyp_fein=4 if inlist(krs_num,3152,3155,3156,3255,3352,3403,3451,3453,3458,3461,4012,5762,5774,6611,6633,6634,6635,6636,7111,7131,7132,7135,7137,7138,7140,7141,7143,7211,7231,7232,7233,7235,8121,8125,8126,8127,8128,8421,8425,8426,9161,9176,9185,9186,9273,9362,9372,9373,9375,9663,9675,9677,9679,12052,12062,12066,12071,13003,13051,13053,15002,15003,15083,15084,15085,15086,15087,15088,15089,16051,16052,16053,16055,16067,16068,16070,16071,16073,16074,16075,16076,16077,15112,15153,15202,15211,15215,15222,15223,15227,15228,15229,15233,15235,15237,15242,15246,15256,15260,15261,15265,15266,15268,15303,15314,15317,15319,15357,15320,15330,15332,15364,15338,15367,15339,15341,15343,15369,15345,15352,15355,15358,15362,15369,13072) replace rtyp_fein=5 if inlist(krs_num,3402,3405,3452,3455,3457,3462,5958,5974,6531,6532,6533,6534,6535,7312,7317,7320,7333,7335,7336,7340,8325,8326,8327,8435,8436,8437,9461,9463,9471,9473,9474,9476,9478,9764,9774,9775,9778) replace rtyp_fein=6 if inlist(krs_num,1001,1051,1054,1059,1061,3454,3456,6631,6632,9163,9171,9172,9173,9180,9182,9183,9187,9189,9190,9261,9262,9263,9271,9272,9274,9275,9276,9277,9278,9279,9462,9464,9472,9475,9477,9479,9662,9672,9673,9674,9678,9762,9763,9776,9777,9780,14625,14626,15001,15082,15091,16054,16056,16061,16062,16063,16064,16065,16066,16069,16072,14263,14264,14272,14284,14286,14292,15101,15113,15118,15126,15134,15144,15147,15151,15154,15159,15171) replace rtyp_fein=7 if inlist(krs_num,3351,3354,3355,3358,3360,9361,9363,9371,9374,9376,9377,9561,9571,9575,9577,12068,12070,12073,13001,13002,13004,13005,13006,13052,13054,13055,13056,13057,13058,13059,13060,13061,13062,15081,15090,15316,15321,15325,15331,15340,15363,15336,15370,13071,13073,13074,13075,13076) label variable rtyp_fein "`ort': Regionstyp, fein untergliedert" recode rtyp_fein (1 2 = 1) (3/5 = 2) (6 7 = 3) , gen(rtyp_grob) label variable rtyp_grob "Regionstyp, grob untergliedert" replace rtyp_fein=krs_num if krs_num<0 replace rtyp_grob=krs_num if krs_num<0