* JCS 160612. * Recode SIC80 4-digit Activity to SIC92 "1"-digit Section. ** Ensure that all SIC80 4-digit Activity variables are named "indmain". * This 1-to-1 mapping is based on job stayers between Sep-Nov 1993 and Dec-Feb 1993/4. ** The Sep-Nov 1993 Autumn seasonal quarterly dataset qlfssn93.dta is primarily coded according to SIC80. ** The Dec-Feb 1993/4 Winter seasonal quarterly dataset qlfsd93f.dta is primarily coded according to SIC92. * This stayer-based recode is based on variables indmain (SIC80 Activity) and indd92m (SIC92 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 "SIC80 to SIC92 mappings.xlsx" to generate the other two possible correspondences between code and Section. * 1. Using LFS codes for both SIC80 Activities and SIC92 Sections. recode indmain (1 = 1) (2 = 1) (3 = 2) (4 = 3) (5 = 3) (6 = 6) (7 = 4) (8 = 3) (9 = 4) (10 = 4) (11 = 4) (12 = 5) (13 = 5) (14 = 4) (15 = 5) (16 = 3) (17 = 4) (18 = 4) (19 = 4) (20 = 4) (21 = 4) (22 = 4) (23 = 4) (24 = 3) (25 = 4) (26 = 3) (27 = 4) (28 = 4) (29 = 4) (30 = 4) (31 = 4) (32 = 4) (33 = 4) (34 = 4) (35 = 4) (36 = 4) (37 = 4) (38 = 4) (39 = 4) (40 = 4) (41 = 4) (42 = 4) (43 = 4) (44 = 4) (45 = 4) (46 = 4) (47 = 4) (49 = 4) (50 = 4) (51 = 4) (52 = 4) (53 = 4) (54 = 4) (55 = 4) (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 = 4) (76 = 7) (77 = 4) (78 = 4) (79 = 4) (80 = 4) (81 = 4) (82 = 4) (83 = 6) (84 = 4) (85 = 4) (86 = 4) (87 = 4) (88 = 4) (89 = 4) (90 = 4) (91 = 4) (92 = 4) (93 = 4) (94 = 4) (95 = 4) (96 = 4) (97 = 4) (98 = 4) (99 = 4) (100 = 4) (101 = 4) (102 = 4) (103 = 4) (104 = 4) (105 = 4) (106 = 4) (107 = 4) (108 = 4) (109 = 4) (110 = 4) (111 = 4) (112 = 4) (113 = 4) (114 = 4) (115 = 4) (116 = 4) (117 = 6) (118 = 4) (119 = 4) (120 = 4) (121 = 4) (122 = 4) (123 = 4) (124 = 4) (125 = 4) (126 = 4) (127 = 4) (128 = 4) (129 = 4) (130 = 4) (131 = 4) (132 = 4) (133 = 4) (134 = 4) (135 = 4) (136 = 4) (137 = 4) (138 = 4) (139 = 4) (140 = 4) (141 = 4) (142 = 4) (143 = 4) (144 = 4) (145 = 14) (146 = 4) (147 = 4) (148 = 4) (149 = 4) (150 = 4) (151 = 4) (152 = 4) (153 = 4) (154 = 4) (155 = 4) (156 = 4) (157 = 4) (158 = 4) (159 = 4) (160 = 4) (161 = 4) (164 = 4) (165 = 4) (167 = 4) (168 = 4) (169 = 4) (170 = 4) (171 = 4) (172 = 4) (173 = 4) (174 = 4) (175 = 4) (176 = 4) (177 = 4) (178 = 4) (179 = 4) (180 = 4) (181 = 4) (182 = 4) (183 = 4) (184 = 4) (185 = 4) (186 = 4) (187 = 4) (188 = 4) (190 = 4) (191 = 4) (192 = 6) (193 = 4) (194 = 6) (195 = 4) (196 = 11) (197 = 4) (198 = 6) (199 = 4) (200 = 4) (201 = 4) (202 = 4) (203 = 4) (204 = 4) (205 = 4) (206 = 4) (207 = 4) (208 = 4) (209 = 4) (210 = 4) (211 = 4) (212 = 4) (213 = 4) (214 = 4) (215 = 4) (216 = 4) (217 = 4) (218 = 4) (219 = 4) (220 = 4) (221 = 11) (222 = 4) (223 = 4) (224 = 4) (225 = 4) (226 = 6) (227 = 7) (228 = 7) (229 = 7) (230 = 7) (231 = 7) (232 = 7) (233 = 8) (234 = 8) (235 = 8) (236 = 15) (237 = 8) (238 = 8) (239 = 8) (240 = 7) (241 = 7) (242 = 7) (243 = 9) (244 = 9) (245 = 9) (246 = 9) (247 = 9) (248 = 9) (249 = 9) (250 = 9) (251 = 9) (252 = 9) (253 = 9) (254 = 9) (255 = 9) (256 = 10) (257 = 10) (258 = 10) (259 = 10) (260 = 10) (261 = 11) (262 = 11) (263 = 11) (264 = 11) (265 = 11) (266 = 11) (267 = 11) (268 = 11) (269 = 11) (270 = 11) (271 = 11) (272 = 11) (273 = 11) (274 = 11) (275 = 11) (276 = 12) (277 = 12) (278 = 12) (279 = 12) (280 = 12) (281 = 12) (282 = 12) (283 = 15) (284 = 15) (285 = 11) (286 = 13) (287 = 13) (288 = 13) (289 = 13) (290 = 13) (291 = 11) (292 = 14) (293 = 14) (294 = 14) (295 = 14) (296 = 14) (297 = 14) (298 = 14) (299 = 15) (300 = 15) (301 = 15) (302 = 15) (303 = 15) (304 = 15) (305 = 15) (306 = 15) (307 = 15) (308 = 15) (309 = 15) (310 = 11) (311 = 16), generate(in8092sm) label define sic92s_lab 1 "a agriculture, hunting & forestry" 2 "b fishing" 3 "c mining, quarrying" 4 "d manufacturing" 5 "e electricity gas & water supply" 6 "f construction" 7 "g wholesale, retail & motor trade" 8 "h hotels & restaurants" 9 "i transport, storage & communication" 10 "j financial intermediation" 11 "k real estate, renting & business activ." 12 "l public administration & defence" 13 "m education" 14 "n health & social work" 15 "o other community, social & personal" 16 "p private hholds with employed persons" 17 "q extra-territorial organisations,bodies", replace label values in8092sm sic92s_lab * 2. Using SIC80 Activity Headings and SIC92 Sections (i.e. actual SIC values in both cases, not LFS codes). recode indmain (100 = 1) (200 = 1) (300 = 2) (1113 = 3) (1114 = 3) (1115 = 6) (1200 = 4) (1300 = 3) (1401 = 4) (1402 = 4) (1520 = 4) (1610 = 5) (1620 = 5) (1630 = 4) (1700 = 5) (2100 = 3) (2210 = 4) (2220 = 4) (2234 = 4) (2235 = 4) (2245 = 4) (2246 = 4) (2247 = 4) (2310 = 3) (2330 = 4) (2396 = 3) (2410 = 4) (2420 = 4) (2436 = 4) (2437 = 4) (2440 = 4) (2450 = 4) (2460 = 4) (2471 = 4) (2478 = 4) (2479 = 4) (2481 = 4) (2489 = 4) (2511 = 4) (2512 = 4) (2513 = 4) (2514 = 4) (2515 = 4) (2516 = 4) (2551 = 4) (2552 = 4) (2562 = 4) (2564 = 4) (2565 = 4) (2567 = 4) (2568 = 4) (2569 = 4) (2570 = 4) (2581 = 4) (2582 = 4) (2591 = 4) (2599 = 4) (2600 = 4) (3111 = 4) (3112 = 4) (3120 = 4) (3137 = 4) (3138 = 4) (3142 = 4) (3161 = 4) (3162 = 4) (3163 = 4) (3164 = 4) (3165 = 4) (3166 = 4) (3167 = 4) (3169 = 4) (3204 = 4) (3205 = 4) (3211 = 7) (3212 = 4) (3221 = 4) (3222 = 4) (3230 = 4) (3244 = 4) (3245 = 4) (3246 = 6) (3251 = 4) (3254 = 4) (3255 = 4) (3261 = 4) (3262 = 4) (3275 = 4) (3276 = 4) (3281 = 4) (3283 = 4) (3284 = 4) (3285 = 4) (3286 = 4) (3287 = 4) (3288 = 4) (3289 = 4) (3290 = 4) (3301 = 4) (3302 = 4) (3410 = 4) (3420 = 4) (3432 = 4) (3433 = 4) (3434 = 4) (3435 = 4) (3441 = 4) (3442 = 4) (3443 = 4) (3444 = 4) (3452 = 4) (3453 = 4) (3454 = 4) (3460 = 4) (3470 = 4) (3480 = 6) (3510 = 4) (3521 = 4) (3522 = 4) (3523 = 4) (3530 = 4) (3610 = 4) (3620 = 4) (3633 = 4) (3634 = 4) (3640 = 4) (3650 = 4) (3710 = 4) (3720 = 4) (3731 = 4) (3732 = 4) (3733 = 4) (3740 = 4) (4415 = 4) (4416 = 4) (4121 = 4) (4122 = 4) (4123 = 4) (4126 = 4) (4130 = 4) (4147 = 4) (4150 = 4) (4160 = 4) (4180 = 14) (4196 = 4) (4197 = 4) (4200 = 4) (4213 = 4) (4214 = 4) (4221 = 4) (4222 = 4) (4239 = 4) (4240 = 4) (4261 = 4) (4270 = 4) (4283 = 4) (4290 = 4) (4310 = 4) (4321 = 4) (4322 = 4) (4350 = 4) (4363 = 4) (4370 = 4) (4384 = 4) (4385 = 4) (4395 = 4) (4396 = 4) (4398 = 4) (4399 = 4) (4410 = 4) (4420 = 4) (4510 = 4) (4531 = 4) (4532 = 4) (4533 = 4) (4534 = 4) (4535 = 4) (4536 = 4) (4537 = 4) (4538 = 4) (4539 = 4) (4555 = 4) (4556 = 4) (4557 = 4) (4610 = 4) (4620 = 4) (4630 = 6) (4640 = 4) (4650 = 6) (4663 = 4) (4664 = 11) (4671 = 4) (4672 = 6) (4710 = 4) (4721 = 4) (4722 = 4) (4723 = 4) (4724 = 4) (4725 = 4) (4728 = 4) (4751 = 4) (4752 = 4) (4753 = 4) (4754 = 4) (4811 = 4) (4812 = 4) (4820 = 4) (4831 = 4) (4832 = 4) (4833 = 4) (4834 = 4) (4835 = 4) (4836 = 4) (4910 = 4) (4920 = 4) (4930 = 11) (4941 = 4) (4942 = 4) (4954 = 4) (4959 = 4) (5000 = 6) (6148 = 7) (6110 = 7) (6210 = 7) (6300 = 7) (6510 = 7) (6410 = 7) (6611 = 8) (6612 = 8) (6620 = 8) (6630 = 15) (6640 = 8) (6650 = 8) (6670 = 8) (6710 = 7) (6720 = 7) (6730 = 7) (7100 = 9) (7210 = 9) (7220 = 9) (7230 = 9) (7260 = 9) (7400 = 9) (7500 = 9) (7610 = 9) (7630 = 9) (7640 = 9) (7700 = 9) (7901 = 9) (7902 = 9) (8140 = 10) (8150 = 10) (8200 = 10) (8310 = 10) (8320 = 10) (8340 = 11) (8350 = 11) (8360 = 11) (8370 = 11) (8380 = 11) (8394 = 11) (8395 = 11) (8396 = 11) (8410 = 11) (8420 = 11) (8430 = 11) (8460 = 11) (8480 = 11) (8490 = 11) (8500 = 11) (9111 = 12) (9112 = 12) (9120 = 12) (9130 = 12) (9140 = 12) (9150 = 12) (9190 = 12) (9211 = 15) (9212 = 15) (9230 = 11) (9310 = 13) (9310 = 13) (9310 = 13) (9330 = 13) (9360 = 13) (9400 = 11) (9510 = 14) (9520 = 14) (9530 = 14) (9540 = 14) (9550 = 14) (9560 = 14) (9611 = 14) (9631 = 15) (9660 = 15) (9690 = 15) (9711 = 15) (9741 = 15) (9760 = 15) (9770 = 15) (9791 = 15) (9811 = 15) (9812 = 15) (9820 = 15) (9890 = 11) (9900 = 16), generate(in8092sm_actual) label define sic92s_lab_actual 1 "a agriculture, hunting & forestry" 2 "b fishing" 3 "c mining, quarrying" 4 "d manufacturing" 5 "e electricity gas & water supply" 6 "f construction" 7 "g wholesale, retail & motor trade" 8 "h hotels & restaurants" 9 "i transport, storage & communication" 10 "j financial intermediation" 11 "k real estate, renting & business activ." 12 "l public administration & defence" 13 "m education" 14 "n health & social work" 15 "o other community, social & personal" 16 "p private hholds with employed persons" 17 "q extra-territorial organisations,bodies", replace label values in8092sm_actual sic92s_lab_actual