******************************************************************************************
******************************Recoding branch to WZ03*******************************
************************BIBB/IAB Employment survey 1985/86*********************************
******************************************************************************************

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

 * Origin: BIBB-FDZ
PASW Statistics 18
Source: Federal Institute for Vocational Education and Training (BIBB)

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


******************************************************************************************
*************Branch BIBB/IAB Employment survey 1985/86 to WZ03****************************
******************************************************************************************

**clearly defined branch 13, 15, 17-26, 29-31, 40-44, 50-55, 58-62.

recode v8
(62=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) (63=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 61 30 31=93) into wz03.


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

compute help=trunc(v5/10).


  if wz03=10 & v5=83 wz03=11.
  if wz03=10 & (v5=81 | v5=82 | v5=91) wz03=14.


 if wz03=24 & (v5=143 | v5=151)  wz03=25.


  if wz03=10 & (help=12 | help=13) wz03=26.


  if wz03=28 & (help>=19 & help<=26) wz03=26.


 if wz03=34 & (help=28 | help=68 | v5=936)  wz03=50.

 if wz03=18 & (help=34 | help=35) wz03=17 .

*  if wz03=15 & v5=424 wz03=16.			//to few cases.

 if wz03=80 & v5=871 wz03=73.

 if wz03=93 & help=84  wz03=85.
 if wz03=93 & help=81  wz03=75.

 if wz03=1 & help=6 wz03=2.
 if wz03=1 & help=2 wz03=5.

 if wz03=41 & (help=54 | help=31)   wz03=40.

DELETE VARIABLES help.
Execute.

**********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 1985/86**********************************************************

 * Origin: BIBB-FDZ
PASW Statistics 18
Refernce: United Nations, (2002): International Standard Industrial Classification of All
Economic Activities (ISIC) Revision 3.1. Statistical papers, Series M No. 4/Rev. 3.1, 
New York: Department of Economic and Social Affairs. Statistics Division.
*******************************************************************************************************.


VALUE LABELS wz03
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 '.

VARIABLE LABELS wz03  'branch: ISIC Rev. 31 / NACE Rev. 1.1 '.
EXECUTE.

******************************************************************************************
Execute.