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

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

 * Origin: BIBB-FDZ
PASW Statistics 18
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.

recode v20
(63=1)(12 10=10) (65=41)(28=15) (28=16) (27 29=18) 
(26=19) (23=20) (24=21) (25 61=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) (64=41) (65=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) (64=92) (57 62 30 31=93) into wz03.
FORMATS wz03 (f8.0).


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

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

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

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

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

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

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

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

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

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

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

if wz03=41 & (v18=54 | v18=31)  wz03=40.
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 1991/92***************************************

 * 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.

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