* JCS 130612. * Recode SIC68 3-digit Minimum List Heading to SIC80 2-digit Class. ** You should choose option 1. or option 2. depending on how your data are coded (and how you want the mapped data coded). *** Option 1. maps according to LFS code. *** Option 2. maps according to SIC classification. *** It would be possible to use the spreadsheet "SIC68 to SIC80 mappings.xlsx" to generate the other two possible correspondences between code and Class. * SIC80 Class corresponds to 2-digit Division of later SICs. * The following renames will have to be conducted first: 1979 - rename var35 (indc) as ind68; 1977 - rename var60 (indb) as ind68; 1975 - rename var44 (inda) as ind68. ** ind68 will then have LFS codes corresponding to SIC68 Minimum List Headings. To use the final recode command, ind68 would have to be recoded to actual SIC68 Minimum List Headings rather than LFS codes. * 1. Using LFS codes for both SIC68 Minimum List Headings and SIC80 Classes. recode ind68 (0 = 1) (1 = 2) (2 = 3) (3 = 4) (4 = 13) (5 = 13) (6 = 6) (7 = 13) (8 = 24) (9 = 24) (10 = 24) (11 = 24) (12 = 24) (13 = 24) (14 = 24) (15 = 24) (16 = 24) (17 = 24) (18 = 24) (19 = 24) (20 = 24) (21 = 24) (22 = 24) (23 = 5) (24 = 7) (25 = 7) (26 = 15) (27 = 15) (28 = 15) (29 = 15) (30 = 15) (31 = 15) (32 = 15) (33 = 15) (34 = 15) (35 = 18) (36 = 12) (37 = 12) (38 = 17) (39 = 12) (40 = 17) (41 = 18) (42 = 18) (43 = 18) (44 = 18) (45 = 18) (46 = 18) (47 = 18) (48 = 19) (49 = 18) (50 = 18) (51 = 18) (52 = 18) (53 = 23) (54 = 28) (55 = 15) (56 = 20) (57 = 20) (58 = 20) (59 = 20) (60 = 20) (61 = 20) (62 = 19) (63 = 20) (64 = 20) (65 = 20) (66 = 22) (67 = 18) (68 = 21) (69 = 22) (70 = 22) (71 = 18) (72 = 22) (73 = 18) (74 = 18) (75 = 31) (76 = 17) (77 = 12) (78 = 17) (79 = 31) (80 = 17) (81 = 16) (82 = 25) (83 = 25) (84 = 25) (85 = 25) (86 = 25) (87 = 25) (88 = 25) (89 = 25) (90 = 25) (91 = 27) (92 = 25) (93 = 25) (94 = 26) (95 = 26) (96 = 26) (97 = 27) (98 = 27) (99 = 27) (100 = 27) (101 = 27) (102 = 27) (103 = 27) (104 = 27) (105 = 14) (106 = 14) (107 = 14) (108 = 14) (109 = 14) (110 = 28) (111 = 28) (112 = 27) (113 = 28) (114 = 28) (115 = 28) (116 = 29) (117 = 30) (118 = 29) (119 = 29) (120 = 29) (121 = 29) (122 = 29) (123 = 30) (124 = 30) (125 = 28) (126 = 31) (127 = 31) (128 = 21) (129 = 30) (130 = 32) (131 = 9) (132 = 9) (133 = 10) (134 = 40) (135 = 40) (136 = 40) (137 = 40) (138 = 43) (139 = 43) (140 = 42) (141 = 45) (142 = 40) (143 = 33) (144 = 33) (145 = 33) (146 = 36) (147 = 36) (148 = 33) (149 = 33) (150 = 47) (151 = 46) (152 = 46) (153 = 50) (154 = 48) (155 = 51) (156 = 48) (157 = 48) (158 = 51) (159 = 48) (160 = 55) (161 = 56) (162 = 4) (163 = 48) (164 = 57) (165 = 57) (166 = 57) (167 = 56) (168 = 37) (169 = 37) (170 = 37) (171 = 37) (173 = 59) (174 = 58) (176 = 36) (177 = 38) (178 = 51) (179 = 51) (180 = 51), generate(in6880dl) label define sic80dllab 1 "01 agriculture & horticulture" 2 "02 forestry" 3 "03 fishing" 4 "11 coal extraction,solid fuels" 5 "12 coke ovens" 6 "13 extraction of mineral oil,natural gas" 7 "14 mineral oil processing" 8 "15 nuclear fuel production" 9 "16 electricity,gas etc supply industry" 10 "17 water supply industry" 11 "21 extraction etc metal ores" 12 "22 metal manufacture" 13 "23 mineral extraction nes" 14 "24 non-metal mineral manufacture" 15 "25 chemical industry" 16 "26 production of man-made fibres" 17 "31 manufacture of metal goods nes" 18 "32 mechanical engineering" 19 "33 office machinery,processing equipment" 20 "34 electrical,electronic engineering" 21 "35 motor vehicles & parts manufacture" 22 "36 other transport equipment manufacture" 23 "37 instrument engineering" 24 "41,2 food,drink & tobacco manufacturing" 25 "43 textile industry" 26 "44 leather and leather goods manufacture" 27 "45 footwear & clothing industries" 28 "46 timber & wooden furniture industries" 29 "47 paper products, printing & publishing" 30 "48 processing of rubber & plastics" 31 "49 other manufacturing industries" 32 "50 construction" 33 "61 wholesale distribution (not scrap)" 34 "62 dealing in scrap etc" 35 "63 commission agents" 36 "64,5 retail distribution" 37 "66 hotels and catering" 38 "67 consumer goods & vehicle repair" 39 "71 railways" 40 "72 other inland transport" 41 "74 sea transport" 42 "75 air transport" 43 "76 transport support services" 44 "77 transport,storage nes" 45 "79 telecommunications" 46 "81 banking and finance" 47 "82 insurance,not social security" 48 "83 business services" 49 "84 renting of movables" 50 "85 owning & dealing in real estate" 51 "91 public administration etc nes" 52 "92 sanitary services" 53 "93 education" 54 "94 research & development" 55 "95 medical,health services" 56 "96 other public services" 57 "97 recreational etc services" 58 "98 personal services" 59 "99 domestic services" 60 "00 diplomatic etc,allied armies", replace label values ind6880dl sic80dllab * 2. Using SIC68 Minimum List Headings and SIC80 Class Headings (i.e. actual SIC values in both cases, not LFS codes). recode ind68_recoded_to_MLH (1 = 1) (2 = 2) (3 = 3) (101 = 11) (102 = 23) (103 = 23) (104 = 13) (109 = 23) (211 = 42) (212 = 41) (213 = 41) (214 = 41) (215 = 41) (216 = 42) (217 = 42) (218 = 42) (219 = 42) (221 = 41) (229 = 42) (231 = 42) (232 = 42) (239 = 42) (240 = 42) (261 = 12) (262 = 14) (263 = 14) (271 = 25) (272 = 25) (273 = 25) (274 = 25) (275 = 25) (276 = 25) (277 = 25) (278 = 25) (279 = 25) (311 = 32) (312 = 22) (313 = 22) (321 = 31) (322 = 22) (323 = 31) (331 = 32) (332 = 32) (333 = 32) (334 = 32) (335 = 32) (336 = 32) (337 = 32) (338 = 33) (339 = 32) (341 = 32) (342 = 32) (349 = 32) (351 = 37) (352 = 46) (353 = 25) (354 = 34) (361 = 34) (362 = 34) (363 = 34) (364 = 34) (365 = 34) (366 = 33) (367 = 34) (368 = 34) (369 = 34) (370 = 36) (380 = 32) (381 = 35) (382 = 36) (383 = 36) (384 = 32) (385 = 36) (390 = 32) (391 = 32) (392 = 49) (393 = 31) (394 = 22) (395 = 31) (396 = 49) (399 = 31) (411 = 26) (412 = 43) (413 = 43) (414 = 43) (415 = 43) (416 = 43) (417 = 43) (418 = 43) (419 = 43) (421 = 43) (422 = 45) (423 = 43) (429 = 43) (431 = 44) (432 = 44) (433 = 44) (441 = 45) (442 = 45) (443 = 45) (444 = 45) (445 = 45) (446 = 45) (449 = 45) (450 = 45) (461 = 24) (462 = 24) (463 = 24) (464 = 24) (469 = 24) (471 = 46) (472 = 46) (473 = 45) (474 = 46) (475 = 46) (479 = 46) (481 = 47) (482 = 48) (483 = 47) (484 = 47) (485 = 47) (486 = 47) (489 = 47) (491 = 48) (492 = 48) (493 = 46) (494 = 49) (495 = 49) (496 = 35) (499 = 48) (500 = 50) (601 = 16) (602 = 16) (603 = 17) (701 = 72) (702 = 72) (703 = 72) (704 = 72) (705 = 76) (706 = 76) (707 = 75) (708 = 79) (709 = 72) (810 = 61) (811 = 61) (812 = 61) (820 = 64) (821 = 64) (831 = 61) (832 = 61) (860 = 82) (861 = 81) (862 = 81) (863 = 85) (864 = 83) (865 = 91) (866 = 83) (871 = 83) (872 = 91) (873 = 83) (874 = 95) (875 = 96) (876 = 11) (879 = 83) (881 = 97) (882 = 97) (883 = 97) (884 = 96) (885 = 66) (886 = 66) (887 = 66) (888 = 66) (891 = 99) (892 = 98) (894 = 65) (895 = 67) (899 = 91) (901 = 91) (906 = 91), generate(in6880dl_actual) label define sic80dllab_actual 1 "agriculture & horticulture" 2 "forestry" 3 "fishing" 11 "coal extraction,solid fuels" 12 "coke ovens" 13 "extraction of mineral oil,natural gas" 14 "mineral oil processing" 15 "nuclear fuel production" 16 "electricity,gas etc supply industry" 17 "water supply industry" 21 "extraction etc metal ores" 22 "metal manufacture" 23 "mineral extraction nes" 24 "non-metal mineral manufacture" 25 "chemical industry" 26 "production of man-made fibres" 31 "manufacture of metal goods nes" 32 "mechanical engineering" 33 "office machinery,processing equipment" 34 "electrical,electronic engineering" 35 "motor vehicles & parts manufacture" 36 "other transport equipment manufacture" 37 "instrument engineering" 41 "41,42 food,drink & tobacco manufacturing" 43 "textile industry" 44 "leather and leather goods manufacture" 45 "footwear & clothing industries" 46 "timber & wooden furniture industries" 47 "paper products, printing & publishing" 48 "processing of rubber & plastics" 49 "other manufacturing industries" 50 "construction" 61 "wholesale distribution (not scrap)" 62 "dealing in scrap etc" 63 "commission agents" 64 "64,65 retail distribution" 66 "hotels and catering" 67 "consumer goods & vehicle repair" 71 "railways" 72 "other inland transport" 74 "sea transport" 75 "air transport" 76 "transport support services" 77 "transport,storage nes" 79 "telecommunications" 81 "banking and finance" 82 "insurance,not social security" 83 "business services" 84 "renting of movables" 85 "owning & dealing in real estate" 91 "public administration etc nes" 92 "sanitary services" 93 "education" 94 "research & development" 95 "medical,health services" 96 "other public services" 97 "recreational etc services" 98 "personal services" 99 "domestic services" 0 "diplomatic etc,allied armies", replace label values ind6880dl_actual sic80dllab_actual