* To create SIC2007 division from SIC92 main job, use recoding from Sean Milburn of ONS: SM 070109. Missing values code added 090311. recode indm92m (001=1) (002=1) (003=1) (004=1) (005=1) (006=1) (007=1) (008=1) (009=1) (010=81) (011=1) (012=1) (013=2) (014=2) (015=3) (016=3) (017=5) (018=5) (019=19) (020=5) (021=8) (022=6) (023=9) (024=7) (025=7) (026=7) (027=8) (028=8) (029=8) (030=8) (031=8) (032=8) (033=8) (034=8) (035=10) (036=10) (037=10) (038=10) (039=10) (040=10) (041=10) (042=10) (043=10) (044=10) (045=10) (046=10) (047=10) (048=10) (049=10) (050=10) (051=10) (052=10) (053=10) (054=10) (055=10) (056=10) (057=10) (058=10) (059=10) (060=10) (061=10) (062=11) (063=11) (064=11) (065=11) (066=11) (067=11) (068=11) (069=11) (070=12) (071=13) (072=13) (073=13) (074=13) (075=13) (076=13) (077=13) (078=13) (079=13) (080=13) (081=13) (082=13) (083=13) (084=13) (085=13) (086=13) (087=13) (088=13) (089=13) (090=13) (091=13) (092=13) (093=13) (094=13) (095=14) (096=14) (097=14) (098=14) (099=14) (100=14) (101=14) (102=14) (103=14) (104=14) (105=14) (106=15) (107=15) (108=15) (109=16) (110=16) (111=16) (112=16) (113=16) (114=16) (115=17) (116=17) (117=17) (118=17) (119=17) (120=17) (121=17) (122=17) (123=58) (124=58) (125=58) (126=59) (127=58) (128=18) (129=18) (130=18) (131=18) (132=18) (133=18) (134=18) (135=18) (136=19) (137=19) (138=19) (139=24) (140=20) (141=20) (142=20) (143=20) (144=20) (145=20) (146=20) (147=20) (148=20) (149=20) (150=21) (151=21) (152=20) (153=20) (154=20) (155=20) (156=20) (157=20) (158=20) (159=26) (160=20) (161=20) (162=22) (163=22) (164=22) (165=22) (166=22) (167=22) (168=22) (169=22) (170=23) (171=23) (172=23) (173=23) (174=23) (175=23) (176=23) (177=23) (178=23) (179=23) (180=23) (181=23) (182=23) (183=23) (184=23) (185=23) (186=23) (187=23) (188=23) (189=23) (190=23) (191=23) (192=23) (193=23) (194=23) (195=23) (196=24) (197=24) (198=24) (199=24) (200=24) (201=24) (202=24) (203=24) (204=24) (205=24) (206=24) (207=24) (208=24) (209=24) (210=24) (211=24) (212=24) (213=25) (214=25) (215=25) (216=25) (217=25) (218=25) (219=25) (220=25) (221=25) (222=25) (223=25) (224=25) (225=25) (226=25) (227=25) (228=25) (229=28) (230=28) (231=28) (232=28) (233=28) (234=28) (235=28) (236=28) (237=28) (238=28) (239=28) (240=28) (241=28) (242=28) (243=28) (244=28) (245=28) (246=28) (247=28) (248=25) (249=27) (250=27) (251=28) (252=26) (253=33) (254=27) (255=27) (256=27) (257=27) (258=29) (259=26) (260=26) (261=26) (262=26) (263=26) (264=32) (265=26) (266=26) (267=32) (268=26) (269=26) (270=26) (271=29) (272=29) (273=29) (274=29) (275=29) (276=30) (277=30) (278=30) (279=30) (280=30) (281=30) (282=30) (283=30) (284=31) (285=31) (286=31) (287=31) (288=31) (289=32) (290=32) (291=32) (292=32) (293=32) (294=32) (295=32) (296=32) (297=32) (298=32) (299=38) (300=38) (301=35) (302=35) (303=35) (304=36) (305=43) (306=45) (307=45) (308=45) (309=46) (310=46) (311=46) (312=47) (313=95) (314=95) (315=95) (316=96) (317=55) (318=55) (319=55) (320=55) (321=55) (322=56) (323=56) (324=56) (325=56) (326=56) (327=56) (328=49) (329=49) (330=49) (331=49) (332=49) (333=49) (334=50) (335=50) (336=51) (337=51) (338=51) (339=52) (340=52) (341=52) (342=52) (343=52) (344=79) (345=79) (346=52) (347=53) (348=53) (349=61) (350=64) (351=64) (352=64) (353=64) (354=64) (355=64) (356=64) (357=65) (358=65) (359=65) (360=66) (361=66) (362=66) (363=66) (364=41) (365=68) (366=68) (367=68) (368=68) (369=77) (370=77) (371=77) (372=77) (373=77) (374=77) (375=77) (376=77) (377=77) (378=62) (379=62) (380=63) (381=63) (382=62) (383=62) (384=72) (385=72) (386=69) (387=69) (388=73) (389=70) (390=70) (391=71) (392=71) (393=73) (394=78) (395=80) (396=81) (397=74) (398=82) (399=82) (400=82) (401=84) (402=84) (403=84) (404=84) (405=84) (406=84) (407=84) (408=84) (409=84) (410=84) (411=85) (412=85) (413=85) (414=85) (415=85) (416=85) (417=85) (418=85) (419=85) (420=85) (421=85) (422=86) (423=86) (424=86) (425=86) (426=75) (427=87) (428=88) (429=38) (430=94) (431=94) (432=94) (433=94) (434=94) (435=94) (436=59) (437=59) (438=59) (439=59) (440=90) (441=90) (442=93) (443=93) (444=63) (445=91) (446=91) (447=91) (448=93) (449=93) (450=92) (451=93) (452=96) (453=96) (454=96) (455=96) (456=96) (457=97) (458=99) (459=-8) (461=-8), generate(in9207dm) mvdecode in9207dm, mv(-9,-8) label var in9207dm "SIC92 to SIC2007 main job division" label define in9207d_lab 1 "01 Crop, animal production, hunting" 2 "02 Forestry and logging" 3 "03 Fishing and aquaculture" 5 "05 Mining of coal and lignite" 6 "06 Extraction of crude petroleum and gas" 7 "07 Mining of metal ores" 8 "08 Other mining and quarrying" 9 "09 Mining support service activities" 10 "10 Manufacture of food products" 11 "11 Manufacture of beverages" 12 "12 Manufacture of tobacco products" 13 "13 Manufacture of textiles" 14 "14 Manufacture of wearing apparel" 15 "15 Manufacture of leather and related" 16 "16 Manufacture of wood and wood products" 17 "17 Manufacture of paper & paper products" 18 "18 Printing and recorded media" 19 "19 Manufacture of coke & refined petrol" 20 "20 Manufacture of chemicals" 21 "21 Manufacture of pharmaceuticals" 22 "22 Manufacture of rubber plastic products" 23 "23 Manuf non-metallic mineral products" 24 "24 Manufacture of basic metals" 25 "25 Manuf fab metal products, ex machinery" 26 "26 Manuf computer, electronic and optical" 27 "27 Manufacture of electrical equipment" 28 "28 Manuf of machinery n.e.c." 29 "29 Manuf vehicles and trailers" 30 "30 Manufacture of other transport" 31 "31 Manufacture of furniture" 32 "32 Other manufacturing" 33 "33 Repair and installation of machinery" 35 "35 Electricity, gas and air cond supply" 36 "36 Water collection, treatment and supply" 37 "37 Sewerage" 38 "38 Waste collection, treatment, disposal" 39 "39 Remediation and other waste management" 41 "41 Construction of buildings" 42 "42 Civil engineering" 43 "43 Specialised construction activities" 45 "45 Wholesale retail trade repair vehicles" 46 "46 Wholesale trade, except vehicles" 47 "47 Retail trade, except vehicles" 49 "49 Land transport inc via pipelines" 50 "50 Water transport" 51 "51 Air transport" 52 "52 Warehousing and support for transport" 53 "53 Postal and courier activities" 55 "55 Accommodation" 56 "56 Food and beverage service activities" 58 "58 Publishing activities" 59 "59 Film, video, television sound record" 60 "60 Programming and broadcasting" 61 "61 Telecommunications" 62 "62 Computer programming and consultancy" 63 "63 Information service activities" 64 "64 Financial ex insurance and pension" 65 "65 Insurance, reinsurance and pension" 66 "66 Auxiliary to financial and insurance" 68 "68 Real estate activities" 69 "69 Legal and accounting activities" 70 "70 Head offices; management consultancy" 71 "71 Architectural and engineering" 72 "72 Scientific research and development" 73 "73 Advertising and market research" 74 "74 Other prof, scientific and technical" 75 "75 Veterinary activities" 77 "77 Rental and leasing activities" 78 "78 Employment activities" 79 "79 Travel, tour operator, reservation" 80 "80 Security and investigation activities" 81 "81 Services to buildings and landscape" 82 "82 Office admin, support and other" 84 "84 Public admin, defence, social sec " 85 "85 Education" 86 "86 Human health activities" 87 "87 Residential care activities" 88 "88 Social work without accommodation" 90 "90 Creative, arts and entertainment" 91 "91 Libraries, archives, museums" 92 "92 Gambling and betting activities" 93 "93 Sports, amusement, recreation" 94 "94 Activities of membership organisations" 95 "95 Repair of computers and other goods" 96 "96 Other personal service activities" 97 "97 Domestic personnel" 98 "98 Undifferentiated goods" 99 "99 Extraterritorial organisations", replace label values in9207dm in9207d_lab