******************************************************************************************
************************IBB/IAB Employment survey 1991/92*********************************
*****************************************Coding the***************************************
************International Standard Classification of Education 97 (ISCED-97)**************
******************************************************************************************


******************************************************************************************
/*
Origin: BIBB-FDZ
Stataversion: 12.0 MP
Reference:
Schroedter, J. H., Lechert, Y., und Lüttinger, P., (2006): Die Umsetzung der Bildungsskala
ISCED-1997 für die Volkszählung 1970, die Mikrozensus-Zusatzerhebung 1971 und die 
Mikrozensen 1976-2004. GESIS.
*/
******************************************************************************************

** occ. degree
gen deg=0
replace deg=1 if v205==1 | v229==1 |v230==1 
replace deg=2 if v255==1 | v256==1
replace deg=3 if v233==1 | v234==1 | v231==1 | v232==1 |v235==1

gen isced=.
replace isced=2 if v202==1
replace isced=3 if v202==2
replace isced=4 if deg==1 
replace isced=5 if v202==3 | v202==4 
replace isced=6 if deg==1 & (v202==3 | v202==4 )
replace isced=7 if deg==2
replace isced=8 if deg==3
replace isced=-4 if isced==.

*****************labeln
#delimit ;
label define isced
-9 "keine Angabe"
-8 "weiß nicht"
-7 "trifft nicht zu"
-6 "ungültig"
-5 "verweigert"
-4 "not classifiable"
-1 "Filter"
0 "0 Pre-primary education / Kindergarten"
1 "1 Primary education on first stage of basic education / Grundschule"
2 "2b Lower secondary education / Hauptschule"
3 "2a Lower secondary education / Mittlere Reife" 
4 "3b Upper secondary education / Abschulss berufl. Ausbildung"
5 "3a Upper secondary education / Fach-|Hochschulreife"
6 "4a Post secondary non tertiary education / Abi + berufl. Ausbildung"
7 "5b First stage of tertiary education / Meister|Techniker"
8 "5a First stage of tertiary education / Uni FH Abschluss"
9 "6 Second stage of tertiary education / Promotion";
#delimit cr

label value isced isced
label var isced "ISCED 97"