******************************************************************************************
*****************************Recoding branch to WZ03*******************************
************************BIBB/IAB Employment survey 1991/92********************************
******************************************************************************************

******************************************************************************************
/*
Origin: BIBB-FDZ
Stataversion: 12.0 MP
Source: Federal Institute for Vocational Education and Training (BIBB)
*/
******************************************************************************************


******************************************************************************************
*************Branch BIBB/IAB Employment survey 1991/92 to WZ03***************************
******************************************************************************************


**clearly defined branch 13, 15, 17-26, 29-31, 40-44, 50-55, 58-62
# delimit ;
recode v20
(63=1)(12 10=10) (28=15) (28=16) (27 29=18) 
(26=19) (23=20) (24=21) (25 61=22) (11=24) (12=26) (13=27) (14 21=28) (15=29)
 (18=30) (19=31) (50=32) (20=33) (16=34) (17=35) (64=41) (22=45) (16 =50)
 (42 44 43=51) (40 41=52) (55=55) (52 51=60) (53=65) (54=66) (60=75)
 (56=80) (58 =85) (59=91) (57 62 30 31=93), gen(wz03);
#delimit cr


***if no clear definition is possible the occupation is used additionally

replace wz03=11 if wz03==10 & v17==83
replace wz03=14 if wz03==10 & (v17==81 | v17==82 | v17==91)


replace wz03=25 if wz03==24 & (v17==143 | v17==151)


replace wz03=26 if wz03==10 & (v18==12 | v18==13)


replace wz03=26 if wz03==28 & (v18>=19 & v18<=26)


replace wz03=50 if wz03==34 & (v18==28 | v18==68 | v17==936)

replace wz03=17 if wz03==18 & (v18==34 | v18==35)

*replace wz03=16 if wz03==15 & v17==424			//to few cases

replace wz03=73 if wz03==80 & v17==871 | wz03==80 & v16==88

replace wz03=85 if wz03==93 & v18==84
replace wz03=75 if wz03==93 & v18==81

replace wz03=2 if wz03==1 & v18==6
replace wz03=5 if wz03==1 & v18==2

replace wz03=40 if wz03==41 & (v18==54 | v18==31) 




**********Label for International Standard Industrial Classification of All Economic****** 
**************************Activities Revision 3.1 (ISIC Rev.3.1)**************************
******************************************************************************************
******************************************NACE Rev. 1.1***********************************
***********************************2-digit level Englisch*********************************
******************************************************************************************

***************************BIBB/IAB Employment survey 1991/92******************************

/*
Origin: BIBB-FDZ
Stataversion: 12.0 MP
Source:
http://ec.europa.eu/eurostat/ramon/nomenclatures/index.cfm?TargetUrl=LST_CLS_DLD&StrNom=NACE_1_1
*/
******************************************************************************************

#delimit ;
label define wz03_2eng
1 " Agriculture, hunting and related service activities "
2 " Forestry, logging and related service activities "
5 " Fishing, fish farming and related service activities "
10 " Mining of coal and lignite; extraction of peat "
11 " Extraction of crude petroleum and natural gas; service activities incidental to oil and gas extraction, excluding surveying "
12 " Mining of uranium and thorium ores "
13 " Mining of metal ores "
14 " Other mining and quarrying "
15 " Manufacture of food products and beverages "
16 " Manufacture of tobacco products "
17 " Manufacture of textiles "
18 " Manufacture of wearing apparel; dressing and dyeing of fur "
19 " Tanning and dressing of leather; manufacture of luggage, handbags, saddlery, harness and footwear "
20 " Manufacture of wood and of products of wood and cork, except furniture; manufacture of articles of straw "
21 " Manufacture of pulp, paper and paper products "
22 " Publishing, printing and reproduction of recorded media "
23 " Manufacture of coke, refined petroleum products and nuclear fuel "
24 " Manufacture of chemicals and chemical products "
25 " Manufacture of rubber and plastic products "
26 " Manufacture of other non-metallic mineral products "
27 " Manufacture of basic metals "
28 " Manufacture of fabricated metal products, except machinery and equipment "
29 " Manufacture of machinery and equipment n.e.c. "
30 " Manufacture of office machinery and computers "
31 " Manufacture of electrical machinery and apparatus n.e.c. "
32 " Manufacture of radio, television and communication equipment and apparatus "
33 " Manufacture of medical, precision and optical instruments, watches and clocks "
34 " Manufacture of motor vehicles, trailers and semi-trailers "
35 " Manufacture of other transport equipment "
36 " Manufacture of furniture; manufacturing n.e.c. "
37 " Recycling "
40 " Electricity, gas, steam and hot water supply "
41 " Collection, purification and distribution of water "
45 " Construction "
50 " Sale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuel "
51 " Wholesale trade and commission trade, except of motor vehicles and motorcycles "
52 " Retail trade, except of motor vehicles and motorcycles; repair of personal and household goods "
55 " Hotels and restaurants "
60 " Land transport; transport via pipelines "
61 " Water transport "
62 " Air transport "
63 " Supporting and auxiliary transport activities; activities of travel agencies "
64 " Post and telecommunications "
65 " Financial intermediation, except insurance and pension funding "
66 " Insurance and pension funding, except compulsory social security "
67 " Activities auxiliary to financial intermediation "
70 " Real estate activities "
71 " Renting of machinery and equipment without operator and of personal and household goods "
72 " Computer and related activities "
73 " Research and development "
74 " Other business activities "
75 " Public administration and defence; compulsory social security "
80 " Education "
85 " Health and social work "
90 " Sewage and refuse disposal, sanitation and similar activities "
91 " Activities of membership organizations n.e.c. "
92 " Recreational, cultural and sporting activities "
93 " Other service activities "
95 " Activities of households as employers of domestic staff "
99 " Extra-territorial organizations and bodies ";
#delimit cr
******************************************************************************************