*************************************************************************************************************************************
***************************BIBB/BAuA 2024***************************************************************************************
*************** Raumornungsregionen aus der Kreiskennziffer( 5-steller)**************************************************************
**************************Gebietsstand 31.12.2023********************************************************************************************
*************************************************************************************************************************************


/*
Herkunft: BIBB-FDZ
Stataversion: 15
Quelle: BBSR Bonn 2015 
https://www.bbsr.bund.de/BBSR/DE/forschung/raumbeobachtung/Raumabgrenzungen/deutschland/regionen/Raumordnungsregionen/raumordnungsregionen.html (Stand: 28.07.25)
*/


************************************************************************************************************************************
************************************************************************************************************************************
*********************Recodieren der Variablen
destring kkz, replace
format kkz %6.0g

#delimit ;
foreach x of varlist kkz F233_KKZ {;
recode `x'

(	1001	=	102	)
(	1002	=	101	)
(	1003	=	103	)
(	1004	=	101	)
(	1051	=	105	)
(	1053	=	104	)
(	1054	=	102	)
(	1055	=	103	)
(	1056	=	104	)
(	1057	=	101	)
(	1058	=	101	)
(	1059	=	102	)
(	1060	=	104	)
(	1061	=	105	)
(	1062	=	104	)
(	2000	=	201	)
(	3101	=	301	)
(	3102	=	301	)
(	3103	=	301	)
(	3151	=	301	)
(	3152	=	305	)
(	3153	=	301	)
(	3154	=	301	)
(	3155	=	305	)
(	3156	=	305	)
( 	3159 	= 	305	)			//Gebietsänderung 2016
(	3157	=	301	)
(	3158	=	301	)
(	3241	=	307	)
(	3251	=	302	)
(	3252	=	308	)
(	3254	=	308	)
(	3255	=	305	)
(	3256	=	307	)
(	3257	=	307	)
(	3351	=	313	)
(	3352	=	303	)
(	3353	=	306	)
(	3354	=	309	)
(	3355	=	309	)
(	3356	=	302	)
(	3357	=	306	)
(	3358	=	313	)
(	3359	=	306	)
(	3360	=	309	)
(	3361	=	302	)
(	3401	=	302	)
(	3402	=	312	)
(	3403	=	310	)
(	3404	=	311	)
(	3405	=	312	)
(	3451	=	310	)
(	3452	=	312	)
(	3453	=	310	)
(	3454	=	304	)
(	3455	=	312	)
(	3456	=	304	)
(	3457	=	312	)
(	3458	=	310	)
(	3459	=	311	)
(	3460	=	311	)
(	3461	=	303	)
(	3462	=	312	)
(	4011	=	401	)
(	4012	=	303	)
(	5111	=	508	)
(	5112	=	507	)
(	5113	=	507	)
(	5114	=	508	)
(	5116	=	508	)
(	5117	=	507	)
(	5119	=	507	)
(	5120	=	508	)
(	5122	=	508	)
(	5124	=	508	)
(	5154	=	507	)
(	5158	=	508	)
(	5162	=	508	)
(	5166	=	508	)
(	5170	=	507	)
(	5314	=	505	)
(	5315	=	510	)
(	5316	=	510	)
(	5334	=	501	)
(	5358	=	501	)
(	5362	=	510	)
(	5366	=	501	)
(	5370	=	501	)
(	5374	=	510	)
(	5378	=	510	)
(	5382	=	505	)
(	5512	=	509	)
(	5513	=	509	)
(	5515	=	511	)
(	5554	=	511	)
(	5558	=	511	)
(	5562	=	509	)
(	5566	=	511	)
(	5570	=	511	)
(	5711	=	503	)
(	5754	=	503	)
(	5758	=	503	)
(	5762	=	512	)
(	5766	=	503	)
(	5770	=	503	)
(	5774	=	512	)
(	5911	=	504	)
(	5913	=	506	)
(	5914	=	504	)
(	5915	=	506	)
(	5916	=	504	)
(	5954	=	504	)
(	5958	=	502	)
(	5962	=	504	)
(	5966	=	513	)
(	5970	=	513	)
(	5974	=	502	)
(	5978	=	506	)
(	6411	=	605	)
(	6412	=	604	)
(	6413	=	604	)
(	6414	=	604	)
(	6431	=	605	)
(	6432	=	605	)
(	6433	=	605	)
(	6434	=	604	)
(	6435	=	604	)
(	6436	=	604	)
(	6437	=	605	)
(	6438	=	604	)
(	6439	=	604	)
(	6440	=	604	)
(	6531	=	601	)
(	6532	=	601	)
(	6533	=	601	)
(	6534	=	601	)
(	6535	=	601	)
(	6611	=	602	)
(	6631	=	603	)
(	6632	=	603	)
(	6633	=	602	)
(	6634	=	602	)
(	6635	=	602	)
(	6636	=	602	)
(	7111	=	701	)
(	7131	=	701	)
(	7132	=	701	)
(	7133	=	702	)
(	7134	=	702	)
(	7135	=	701	)
(	7137	=	701	)
(	7138	=	701	)
(	7140	=	701	)
(	7141	=	701	)
(	7143	=	701	)
(	7211	=	704	)
(	7231	=	704	)
(	7232	=	704	)
(	7233	=	704	)
(	7235	=	704	)
(	7311	=	703	)
(	7312	=	705	)
(	7313	=	703	)
(	7314	=	703	)
(	7315	=	702	)
(	7316	=	703	)
(	7317	=	705	)
(	7318	=	703	)
(	7319	=	702	)
(	7320	=	705	)
(	7331	=	702	)
(	7332	=	703	)
(	7333	=	705	)
(	7334	=	703	)
(	7335	=	705	)
(	7336	=	705	)
(	7337	=	703	)
(	7338	=	703	)
(	7339	=	702	)
(	7340	=	705	)
(	8111	=	810	)
(	8115	=	810	)
(	8116	=	810	)
(	8117	=	810	)
(	8118	=	810	)
(	8119	=	810	)
(	8121	=	803	)
(	8125	=	803	)
(	8126	=	803	)
(	8127	=	803	)
(	8128	=	803	)
(	8135	=	808	)
(	8136	=	808	)
(	8211	=	805	)
(	8212	=	805	)
(	8215	=	805	)
(	8216	=	805	)
(	8221	=	812	)
(	8222	=	812	)
(	8225	=	812	)
(	8226	=	812	)
(	8231	=	807	)
(	8235	=	807	)
(	8236	=	807	)
(	8237	=	807	)
(	8311	=	811	)
(	8315	=	811	)
(	8316	=	811	)
(	8317	=	811	)
(	8325	=	809	)
(	8326	=	809	)
(	8327	=	809	)
(	8335	=	804	)
(	8336	=	804	)
(	8337	=	804	)
(	8415	=	806	)
(	8416	=	806	)
(	8417	=	806	)
(	8421	=	802	)
(	8425	=	802	)
(	8426	=	802	)
(	8435	=	801	)
(	8436	=	801	)
(	8437	=	801	)
(	9161	=	907	)
(	9162	=	910	)
(	9163	=	916	)
(	9171	=	916	)
(	9172	=	916	)
(	9173	=	913	)
(	9174	=	910	)
(	9175	=	910	)
(	9176	=	907	)
(	9177	=	910	)
(	9178	=	910	)
(	9179	=	910	)
(	9180	=	913	)
(	9181	=	910	)
(	9182	=	913	)
(	9183	=	916	)
(	9184	=	910	)
(	9185	=	907	)
(	9186	=	907	)
(	9187	=	916	)
(	9188	=	910	)
(	9189	=	916	)
(	9190	=	913	)
(	9261	=	908	)
(	9262	=	905	)
(	9263	=	905	)
(	9271	=	905	)
(	9272	=	905	)
(	9273	=	915	)
(	9274	=	908	)
(	9275	=	905	)
(	9276	=	905	)
(	9277	=	908	)
(	9278	=	905	)
(	9279	=	908	)
(	9361	=	914	)
(	9362	=	915	)
(	9363	=	914	)
(	9371	=	914	)
(	9372	=	915	)
(	9373	=	915	)
(	9374	=	914	)
(	9375	=	915	)
(	9376	=	914	)
(	9377	=	914	)
(	9461	=	912	)
(	9462	=	911	)
(	9463	=	912	)
(	9464	=	911	)
(	9471	=	912	)
(	9472	=	911	)
(	9473	=	912	)
(	9474	=	912	)
(	9475	=	911	)
(	9476	=	912	)
(	9477	=	911	)
(	9478	=	912	)
(	9479	=	911	)
(	9561	=	917	)
(	9562	=	906	)
(	9563	=	906	)
(	9564	=	906	)
(	9565	=	906	)
(	9571	=	917	)
(	9572	=	906	)
(	9573	=	906	)
(	9574	=	906	)
(	9575	=	917	)
(	9576	=	906	)
(	9577	=	917	)
(	9661	=	903	)
(	9662	=	909	)
(	9663	=	918	)
(	9671	=	903	)
(	9672	=	909	)
(	9673	=	909	)
(	9674	=	909	)
(	9675	=	918	)
(	9676	=	903	)
(	9677	=	918	)
(	9678	=	909	)
(	9679	=	918	)
(	9761	=	902	)
(	9762	=	901	)
(	9763	=	901	)
(	9764	=	904	)
(	9771	=	902	)
(	9772	=	902	)
(	9773	=	902	)
(	9774	=	904	)
(	9775	=	904	)
(	9776	=	901	)
(	9777	=	901	)
(	9778	=	904	)
(	9779	=	902	)
(	9780	=	901	)
(	10041	=	1001	)
(	10042	=	1001	)
(	10043	=	1001	)
(	10044	=	1001	)
(	10045	=	1001	)
(	10046	=	1001	)
(	11000	=	1101	)
( 	11100 	=	1101)				
( 	11200 	=	1101)
(	12051	=	1201	)
(	12052	=	1202	)
(	12053	=	1203	)
(	12054	=	1201	)
(	12060	=	1205	)
(	12061	=	1202	)
(	12062	=	1202	)
(	12063	=	1201	)
(	12064	=	1203	)
(	12065	=	1204	)
(	12066	=	1202	)
(	12067	=	1203	)
(	12068	=	1204	)
(	12069	=	1201	)
(	12070	=	1204	)
(	12071	=	1202	)
(	12072	=	1201	)
(	12073	=	1205	)
(	13003	=	1302	)
(	13004	=	1304	)
(	13071	=	1301	)
(	13072	=	1302	)
(	13073	=	1303	)
(	13074	=	1304	)
(	13075	=	1303	)
(	13076	=	1304	)
(	14511	=	1403	)
(	14521	=	1403	)
(	14522	=	1403	)
(	14523	=	1403	)
(	14524	=	1403	)
(	14612	=	1401	)
(	14625	=	1402	)
(	14626	=	1402	)
(	14627	=	1401	)
(	14628	=	1401	)
(	14713	=	1404	)
(	14729	=	1404	)
(	14730	=	1404	)
(	15001	=	1502	)
(	15002	=	1503	)
(	15003	=	1504	)
(	15081	=	1501	)
(	15082	=	1502	)
(	15083	=	1504	)
(	15084	=	1503	)
(	15085	=	1504	)
(	15086	=	1504	)
(	15087	=	1503	)
(	15088	=	1503	)
(	15089	=	1504	)
(	15090	=	1501	)
(	15091	=	1502	)
(	16051	=	1601	)
(	16052	=	1603	)
(	16053	=	1603	)
(	16054	=	1604	)
(	16055	=	1601	)
(	16056	=	1604	)
(	16061	=	1602	)
(	16062	=	1602	)
(	16063	=	1604	)
(	16064	=	1602	)
(	16065	=	1602	)
(	16066	=	1604	)
(	16067	=	1601	)
(	16068	=	1601	)
(	16069	=	1604	)
(	16070	=	1601	)
(	16071	=	1601	)
(	16072	=	1604	)
(	16073	=	1603	)
(	16074	=	1603	)
(	16075	=	1603	)
(	16076	=	1603	)
(	16077	=	1603	)
(	99999 	=	-9		), gen (`x'_h);
      };
#delimit cr

rename kkz_h ror
rename F233_KKZ_h F233_ror
**************************************************************************************************************************************
**************Labeln der Variablen

#delimit ;
label define ror
-9 	"keine Angabe"
101	"Schleswig-Holstein Mitte"
102	"Schleswig-Holstein Nord"
103	"Schleswig-Holstein Ost"
104	"Schleswig-Holstein Süd"
105	"Schleswig-Holstein Süd-West"
201	"Hamburg"
301	"Braunschweig"
302	"Bremen-Umland"
303	"Bremerhaven"
304	"Emsland"
305	"Göttingen"
306	"Hamburg-Umland-Süd"
307	"Hannover"
308	"Hildesheim"
309	"Lüneburg"
310	"Oldenburg"
311	"Osnabrück"
312	"Ost-Friesland"
313	"Südheide"
401	"Bremen"
501	"Aachen"
502	"Arnsberg"
503	"Bielefeld"
504	"Bochum/Hagen"
505	"Bonn"
506	"Dortmund"
507	"Duisburg/Essen"
508	"Düsseldorf"
509	"Emscher-Lippe"
510	"Köln"
511	"Münster"
512	"Paderborn"
513	"Siegen"
601	"Mittelhessen"
602	"Nordhessen"
603	"Osthessen"
604	"Rhein-Main"
605	"Starkenburg"
701	"Mittelrhein-Westerwald"
702	"Rheinhessen-Nahe"
703	"Rheinpfalz"
704	"Trier"
705	"Westpfalz"
801	"Bodensee-Oberschwaben"
802	"Donau-Iller (BW)"
803	"Franken"
804	"Hochrhein-Bodensee"
805	"Mittlerer Oberrhein"
806	"Neckar-Alb"
807	"Nordschwarzwald"
808	"Ostwürttemberg"
809	"Schwarzwald-Baar-Heuberg"
810	"Stuttgart"
811	"Südlicher Oberrhein"
812	"Unterer Neckar"
901	"Allgäu"
902	"Augsburg"
903	"Bayerischer Untermain"
904	"Donau-Iller (BY)"
905	"Donau-Wald"
906	"Industrieregion Mittelfranken"
907	"Ingolstadt"
908	"Landshut"
909	"Main-Rhön"
910	"München"
911	"Oberfranken-Ost"
912	"Oberfranken-West"
913	"Oberland"
914	"Oberpfalz-Nord"
915	"Regensburg"
916	"Südostoberbayern"
917	"Westmittelfranken"
918	"Würzburg"
1001	"Saar"
1101	"Berlin"
1201	"Havelland-Fläming"
1202	"Lausitz-Spreewald"
1203	"Oderland-Spree"
1204	"Prignitz-Oberhavel"
1205	"Uckermark-Barnim"
1301	"Mecklenburgische Seenplatte"
1302	"Mittleres Mecklenburg/Rostock"
1303	"Vorpommern"
1304	"Westmecklenburg"
1401	"Oberes Elbtal/Osterzgebirge"
1402	"Oberlausitz-Niederschlesien"
1403	"Südsachsen"
1404	"Westsachsen"
1501	"Altmark"
1502	"Anhalt-Bitterfeld-Wittenberg"
1503	"Halle/S."
1504	"Magdeburg"
1601	"Mittelthüringen"
1602	"Nordthüringen"
1603	"Ostthüringen"
1604	"Südthüringen"
99997 "Betriebsstätte befindet sich im Ausland"
99998 "wechselnder Arbeitsort in unterschiedlichen Regionen";

#delimit cr
label val ror F233_ror ror
label var ror "Raumordnungsregionen des Wohnortes"
label var F233_ror "Raumordnungsregionen des Betriebes"