******************************************************************************************
******************************Recode branch to WZ03*******************************
*************************BIBB/IAB Employment survey 1998/99*************************

******************************************************************************************

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


******************************************************************************************
*************Branch BIBB/IAB 98/99 to WZ03*********************************************
******************************************************************************************

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

***if no clear definition is possible the occupation is used additionally 
tab v14 if wz03==1
replace wz03=2 if wz03==1 & (v14==6 | v14==018)
replace wz03=5 if wz03==1 & v13==23

tab v14 if wz03==10
replace wz03=14 if wz03==10 & v14==10
*replace wz03=13 if wz03==10 & v14==8		//to few cases 
replace wz03=26 if wz03==10 & v14==12
replace wz03=26 if wz03==10 & v14==13

tab v14 if wz03==41
*replace wz03=11 if wz03==41 & v14==7		//to few cases 
replace wz03=40 if wz03==41 & (v14==54 | v14==31) 

tab v13 if wz03==15
replace wz03=16 if wz03==15 & v13==424

tab v13 if wz03==18
replace wz03=17 if wz03==18 & (v14==34 | v14==35)

tab v13 if wz03==22
replace wz03=32 if wz03==22 & (v13==315 | v13==603 | v13==622) |  wz03==22 & v14==73

tab v13 if wz03==24
replace wz03=25 if wz03==24 & (v13==145 | v13==606 | v13==511 | v13==627) | wz03==24 & (v14==15 | v14==50)

tab v14 if wz03==28
replace wz03=27 if wz03==28 & (v14>=19 & v14<=26)

tab v14 if wz03==34
replace wz03=50 if wz03==34 & (v14==28 | v14==67 | v14==66 | v14==68 | v13==936)

tab v14 if wz03==52
replace wz03=51 if wz03==52 & v13==671 & v134==46
replace wz03=50 if wz03==52 & (v13==686 | v13==662 | v14==28) & v134==46

tab v14 if wz03==73
replace wz03=80 if wz03==73 & v14==87 



**********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 1998/99*************************

/*
Origin: BIBB-FDZ
Stataversion: 12.0 MP
Reference: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
******************************************************************************************