*************************************************************************************************************************************
***************************BIBB/BAuA 2018***************************************************************************************
*************** Raumornungsregionen aus der Kreiskennziffer( 5-steller)**************************************************************
**************************Stand 31.12.2015********************************************************************************************
*************************************************************************************************************************************


/*
Herkunft: BIBB-FDZ
Stataversion: 15
Quelle: BBSR Bonn 2015 
https://www.bbsr.bund.de/BBSR/DE/Raumbeobachtung/Raumabgrenzungen/deutschland/archiv/archiv.html (stand: 16.01.2020)
*/


************************************************************************************************************************************
//neue kkz für Göttingen im Jahr 2016 "3159" dazugenommen
************************************************************************************************************************************
*********************Recodieren der Variablen


#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	)
(	99996 99997 99998 99999 =-4), gen (`x'_h);
      };
#delimit cr

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

#delimit ;
label define ror
-4 "nicht zuordenbar"
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	";


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