* JCS 130612. * Recode SIC68 3-digit Minimum List Heading to SIC80 1-digit Division. ** 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 Division corresponds to 1-digit Section 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 = 1) (2 = 1) (3 = 2) (4 = 3) (5 = 3) (6 = 2) (7 = 3) (8 = 5) (9 = 5) (10 = 5) (11 = 5) (12 = 5) (13 = 5) (14 = 5) (15 = 5) (16 = 5) (17 = 5) (18 = 5) (19 = 5) (20 = 5) (21 = 5) (22 = 5) (23 = 2) (24 = 2) (25 = 2) (26 = 3) (27 = 3) (28 = 3) (29 = 3) (30 = 3) (31 = 3) (32 = 3) (33 = 3) (34 = 3) (35 = 4) (36 = 3) (37 = 3) (38 = 4) (39 = 3) (40 = 4) (41 = 4) (42 = 4) (43 = 4) (44 = 4) (45 = 4) (46 = 4) (47 = 4) (48 = 4) (49 = 4) (50 = 4) (51 = 4) (52 = 4) (53 = 4) (54 = 5) (55 = 3) (56 = 4) (57 = 4) (58 = 4) (59 = 4) (60 = 4) (61 = 4) (62 = 4) (63 = 4) (64 = 4) (65 = 4) (66 = 4) (67 = 4) (68 = 4) (69 = 4) (70 = 4) (71 = 4) (72 = 4) (73 = 4) (74 = 4) (75 = 5) (76 = 4) (77 = 3) (78 = 4) (79 = 5) (80 = 4) (81 = 3) (82 = 5) (83 = 5) (84 = 5) (85 = 5) (86 = 5) (87 = 5) (88 = 5) (89 = 5) (90 = 5) (91 = 5) (92 = 5) (93 = 5) (94 = 5) (95 = 5) (96 = 5) (97 = 5) (98 = 5) (99 = 5) (100 = 5) (101 = 5) (102 = 5) (103 = 5) (104 = 5) (105 = 3) (106 = 3) (107 = 3) (108 = 3) (109 = 3) (110 = 5) (111 = 5) (112 = 5) (113 = 5) (114 = 5) (115 = 5) (116 = 5) (117 = 5) (118 = 5) (119 = 5) (120 = 5) (121 = 5) (122 = 5) (123 = 5) (124 = 5) (125 = 5) (126 = 5) (127 = 5) (128 = 4) (129 = 5) (130 = 6) (131 = 2) (132 = 2) (133 = 2) (134 = 8) (135 = 8) (136 = 8) (137 = 8) (138 = 8) (139 = 8) (140 = 8) (141 = 8) (142 = 8) (143 = 7) (144 = 7) (145 = 7) (146 = 7) (147 = 7) (148 = 7) (149 = 7) (150 = 9) (151 = 9) (152 = 9) (153 = 9) (154 = 9) (155 = 10) (156 = 9) (157 = 9) (158 = 10) (159 = 9) (160 = 10) (161 = 10) (162 = 2) (163 = 9) (164 = 10) (165 = 10) (166 = 10) (167 = 10) (168 = 7) (169 = 7) (170 = 7) (171 = 7) (173 = 10) (174 = 10) (176 = 7) (177 = 7) (178 = 10) (179 = 10) (180 = 10), generate(in6880sl) label define sic80sllab 1 "0 agriculture,forestry,fishing" 2 "1 energy and water supply" 3 "2 minerals,ores,metals,chemicals" 4 "3 metal goods,engineering,vehicles" 5 "4 other manufacturing industries" 6 "5 construction" 7 "6 distribution,hotels&catering,repairs" 8 "7 transport and communication" 9 "8 banking,financial&business services" 10 "9 other services", replace label values ind6880sl sic80sllab * 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 = 0) (2 = 0) (3 = 0) (101 = 1) (102 = 2) (103 = 2) (104 = 1) (109 = 2) (211 = 4) (212 = 4) (213 = 4) (214 = 4) (215 = 4) (216 = 4) (217 = 4) (218 = 4) (219 = 4) (221 = 4) (229 = 4) (231 = 4) (232 = 4) (239 = 4) (240 = 4) (261 = 1) (262 = 1) (263 = 1) (271 = 2) (272 = 2) (273 = 2) (274 = 2) (275 = 2) (276 = 2) (277 = 2) (278 = 2) (279 = 2) (311 = 3) (312 = 2) (313 = 2) (321 = 3) (322 = 2) (323 = 3) (331 = 3) (332 = 3) (333 = 3) (334 = 3) (335 = 3) (336 = 3) (337 = 3) (338 = 3) (339 = 3) (341 = 3) (342 = 3) (349 = 3) (351 = 3) (352 = 4) (353 = 2) (354 = 3) (361 = 3) (362 = 3) (363 = 3) (364 = 3) (365 = 3) (366 = 3) (367 = 3) (368 = 3) (369 = 3) (370 = 3) (380 = 3) (381 = 3) (382 = 3) (383 = 3) (384 = 3) (385 = 3) (390 = 3) (391 = 3) (392 = 4) (393 = 3) (394 = 2) (395 = 3) (396 = 4) (399 = 3) (411 = 2) (412 = 4) (413 = 4) (414 = 4) (415 = 4) (416 = 4) (417 = 4) (418 = 4) (419 = 4) (421 = 4) (422 = 4) (423 = 4) (429 = 4) (431 = 4) (432 = 4) (433 = 4) (441 = 4) (442 = 4) (443 = 4) (444 = 4) (445 = 4) (446 = 4) (449 = 4) (450 = 4) (461 = 2) (462 = 2) (463 = 2) (464 = 2) (469 = 2) (471 = 4) (472 = 4) (473 = 4) (474 = 4) (475 = 4) (479 = 4) (481 = 4) (482 = 4) (483 = 4) (484 = 4) (485 = 4) (486 = 4) (489 = 4) (491 = 4) (492 = 4) (493 = 4) (494 = 4) (495 = 4) (496 = 3) (499 = 4) (500 = 5) (601 = 1) (602 = 1) (603 = 1) (701 = 7) (702 = 7) (703 = 7) (704 = 7) (705 = 7) (706 = 7) (707 = 7) (708 = 7) (709 = 7) (810 = 6) (811 = 6) (812 = 6) (820 = 6) (821 = 6) (831 = 6) (832 = 6) (860 = 8) (861 = 8) (862 = 8) (863 = 8) (864 = 8) (865 = 9) (866 = 8) (871 = 8) (872 = 9) (873 = 8) (874 = 9) (875 = 9) (876 = 1) (879 = 8) (881 = 9) (882 = 9) (883 = 9) (884 = 9) (885 = 6) (886 = 6) (887 = 6) (888 = 6) (891 = 9) (892 = 9) (894 = 6) (895 = 6) (899 = 9) (901 = 9) (906 = 9), generate(in6880sl_actual) label define sic80sllab_actual 0 "agriculture,forestry,fishing" 1 "energy and water supply" 2 "minerals,ores,metals,chemicals" 3 "metal goods,engineering,vehicles" 4 "other manufacturing industries" 5 "construction" 6 "distribution,hotels&catering,repairs" 7 "transport and communication" 8 "banking,financial&business services" 9 "other services", replace label values ind6880sl_actual sic80sllab_actual