* JCS 131016 Revised version including SIC80 4-digit codes up to 9900, corresponding to SIC92 2-digit codes up to 99. 
* (The previous version, dated 160612, had an omission affecting * 2. below (recode based on actual SIC values): the previous version mistakenly omitted SIC80 4-digit codes larger than 3262, corresopnding to SIC92 2-digit codes larger than 29.)
* Recode SIC80 4-digit Activity to SIC92 2-digit Division.
** 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 uses 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 Division.

* 1. Using LFS codes for both SIC80 Activities and SIC92 Divisions.
recode indmain (1 = 1) (2 = 2) (3 = 3) (4 = 4) (5 = 4) (6 = 34) (7 = 17) (8 = 5) (9 = 17) (10 = 17) (11 = 17) (12 = 32) (13 = 32) (14 = 23) (15 = 33) (16 = 7) (17 = 21) (18 = 21) (19 = 22) (20 = 21) (21 = 21) (22 = 21) (23 = 21) (24 = 8) (25 = 18) (26 = 8) (27 = 20) (28 = 20) (29 = 20) (30 = 20) (31 = 20) (32 = 20) (33 = 20) (34 = 20) (35 = 20) (36 = 20) (37 = 20) (38 = 20) (39 = 18) (40 = 18) (41 = 18) (42 = 18) (43 = 18) (44 = 18) (45 = 18) (46 = 18) (47 = 18) (49 = 18) (50 = 18) (51 = 18) (52 = 18) (53 = 19) (54 = 18) (55 = 18) (56 = 18) (57 = 18) (58 = 18) (59 = 18) (60 = 21) (61 = 21) (62 = 22) (63 = 22) (64 = 22) (65 = 22) (66 = 22) (67 = 22) (68 = 22) (69 = 22) (70 = 23) (71 = 30) (72 = 22) (73 = 22) (74 = 22) (75 = 22) (76 = 36) (77 = 23) (78 = 23) (79 = 23) (80 = 23) (81 = 23) (82 = 23) (83 = 34) (84 = 23) (85 = 23) (86 = 23) (87 = 23) (88 = 23) (89 = 23) (90 = 16) (91 = 23) (92 = 23) (93 = 23) (94 = 23) (95 = 23) (96 = 23) (97 = 23) (98 = 22) (99 = 23) (100 = 24) (101 = 24) (102 = 25) (103 = 25) (104 = 25) (105 = 25) (106 = 25) (107 = 23) (108 = 26) (109 = 25) (110 = 27) (111 = 26) (112 = 16) (113 = 26) (114 = 25) (115 = 23) (116 = 25) (117 = 34) (118 = 28) (119 = 28) (120 = 28) (121 = 28) (122 = 28) (123 = 29) (124 = 29) (125 = 28) (126 = 29) (127 = 29) (128 = 30) (129 = 27) (130 = 27) (131 = 27) (132 = 27) (133 = 27) (134 = 27) (135 = 9) (136 = 9) (137 = 9) (138 = 9) (139 = 9) (140 = 9) (141 = 9) (142 = 9) (143 = 9) (144 = 9) (145 = 54) (146 = 9) (147 = 9) (148 = 9) (149 = 9) (150 = 9) (151 = 9) (152 = 9) (153 = 9) (154 = 9) (155 = 9) (156 = 9) (157 = 9) (158 = 10) (159 = 11) (160 = 11) (161 = 11) (164 = 11) (165 = 11) (167 = 11) (168 = 11) (169 = 11) (170 = 11) (171 = 11) (172 = 11) (173 = 11) (174 = 13) (175 = 13) (176 = 13) (177 = 12) (178 = 12) (179 = 12) (180 = 12) (181 = 12) (182 = 12) (183 = 12) (184 = 12) (185 = 12) (186 = 11) (187 = 11) (188 = 11) (190 = 14) (191 = 14) (192 = 34) (193 = 14) (194 = 34) (195 = 30) (196 = 51) (197 = 30) (198 = 34) (199 = 15) (200 = 15) (201 = 15) (202 = 15) (203 = 15) (204 = 15) (205 = 15) (206 = 16) (207 = 16) (208 = 16) (209 = 16) (210 = 19) (211 = 19) (212 = 19) (213 = 11) (214 = 19) (215 = 19) (216 = 19) (217 = 19) (218 = 19) (219 = 30) (220 = 30) (221 = 51) (222 = 30) (223 = 30) (224 = 30) (225 = 19) (226 = 34) (227 = 35) (228 = 36) (229 = 36) (230 = 36) (231 = 35) (232 = 37) (233 = 38) (234 = 38) (235 = 38) (236 = 56) (237 = 38) (238 = 38) (239 = 38) (240 = 35) (241 = 37) (242 = 37) (243 = 39) (244 = 39) (245 = 39) (246 = 39) (247 = 42) (248 = 40) (249 = 42) (250 = 42) (251 = 42) (252 = 42) (253 = 42) (254 = 43) (255 = 43) (256 = 44) (257 = 44) (258 = 46) (259 = 44) (260 = 46) (261 = 47) (262 = 51) (263 = 51) (264 = 51) (265 = 51) (266 = 49) (267 = 51) (268 = 51) (269 = 48) (270 = 48) (271 = 48) (272 = 48) (273 = 48) (274 = 48) (275 = 47) (276 = 52) (277 = 52) (278 = 52) (279 = 52) (280 = 52) (281 = 52) (282 = 52) (283 = 55) (284 = 55) (285 = 51) (286 = 53) (287 = 53) (288 = 53) (289 = 53) (290 = 53) (291 = 50) (292 = 54) (293 = 54) (294 = 54) (295 = 54) (296 = 54) (297 = 54) (298 = 54) (299 = 56) (300 = 56) (301 = 56) (302 = 57) (303 = 57) (304 = 57) (305 = 57) (306 = 57) (307 = 58) (308 = 58) (309 = 58) (310 = 51) (311 = 59), generate(in8092dm)
label define sic92d_lab 1 "01:agriculture,hunting,etc" 2 "02:forestry,logging etc" 3 "05:fishing,fish farms,hatcheries etc" 4 "10:coal,lignite mining,peat extraction" 5 "11:oil,gas extractn etc (not surveying)" 6 "12:uranium,thorium ore mining" 7 "13:mining of metal ores" 8 "14:other mining,quarrying" 9 "15:food,beverage manufacture" 10 "16:tobacco products manufacture" 11 "17:textile manufacture" 12 "18:clothing,fur manufacture" 13 "19:leather,leather goods manufacture" 14 "20:wood,straw,cork,wood prods(not furn)" 15 "21:pulp,paper,paper prods manufacture" 16 "22:printing,publishing,recorded media" 17 "23:coke,petrol prods,nuclear fuel man." 18 "24:chemicals,chemical products man." 19 "25:rubber,plastic products manufacture" 20 "26:other non-metallic products man." 21 "27:basic metals manufacture" 22 "28:fabric-metal prod (not mach,eqt) man." 23 "29:mach,eqt manufacture" 24 "30:office mach,computer manufacture" 25 "31:elec mach,eqt manufacture" 26 "32:radio,tv,communication eqt man." 27 "33:medical,precision,optical eqt man." 28 "34:motor veh,trailer,etc manufacture" 29 "35:other transport eqt manufacture" 30 "36:furniture etc manufacture" 31 "37:recycling" 32 "40:elec,gas,steam etc supply" 33 "41:water collection,purif.,supply etc" 34 "45:construction" 35 "50:sales of motor vehs,parts,fuel etc" 36 "51:wsale,commission trade (fee,contract)" 37 "52:retail trade (not motor veh) repairs" 38 "55:hotels,restaurants" 39 "60:transport by land,pipeline" 40 "61:water transport" 41 "62:air transport" 42 "63:aux transport activ.,travel agents" 43 "64:post,telecommunications" 44 "65:financl intermed(not insur.,pensions)" 45 "66:insurance,pensions (not social sec)" 46 "67:other financial (not insur.,pensions)" 47 "70:real estate activities" 48 "71:personal,hhld,mach,eqt rental(no op)" 49 "72:computer,related activities" 50 "73:research,development" 51 "74:other business activities" 52 "75:public admin,defence,social security" 53 "80:education" 54 "85:health,social work" 55 "90:sanitation,sewage,refuse disposal etc" 56 "91:activ. of membership organisations" 57 "92:recreational,cultural,sporting activ." 58 "93:other service activities" 59 "95:private hhlds with employed persons" 60	"99:extra-territorial organisations etc", replace
label values in8092dm sic92d_lab

* 2. Using SIC80 Activity Headings and SIC92 Divisions (i.e. actual SIC values in both cases, not LFS codes).
recode indmain (100 = 1) (200 = 2) (300 = 5) (1113 = 10) (1114 = 10) (1115 = 45) (1200 = 23) (1300 = 11) (1401 = 23) (1402 = 23) (1520 = 23) (1610 = 40) (1620 = 40) (1630 = 29) (1700 = 41) (2100 = 13) (2210 = 27) (2220 = 27) (2234 = 28) (2235 = 27) (2245 = 27) (2246 = 27) (2247 = 27) (2310 = 14) (2330 = 24) (2396 = 14) (2410 = 26) (2420 = 26) (2436 = 26) (2437 = 26) (2440 = 26) (2450 = 26) (2460 = 26) (2471 = 26) (2478 = 26) (2479 = 26) (2481 = 26) (2489 = 26) (2511 = 24) (2512 = 24) (2513 = 24) (2514 = 24) (2515 = 24) (2516 = 24) (2551 = 24) (2552 = 24) (2562 = 24) (2564 = 24) (2565 = 24) (2567 = 24) (2568 = 24) (2569 = 25) (2570 = 24) (2581 = 24) (2582 = 24) (2591 = 24) (2599 = 24) (2600 = 24) (3111 = 27) (3112 = 27) (3120 = 28) (3137 = 28) (3138 = 28) (3142 = 28) (3161 = 28) (3162 = 28) (3163 = 28) (3164 = 28) (3165 = 29) (3166 = 36) (3167 = 28) (3169 = 28) (3204 = 28) (3205 = 28) (3211 = 51) (3212 = 29) (3221 = 29) (3222 = 29) (3230 = 29) (3244 = 29) (3245 = 29) (3246 = 45) (3251 = 29) (3254 = 29) (3255 = 29) (3261 = 29) (3262 = 29) (3275 = 29) (3276 = 22) (3281 = 29) (3283 = 29) (3284 = 29) (3285 = 29) (3286 = 29) (3287 = 29) (3288 = 29) (3289 = 28) (3290 = 29) (3301 = 30) (3302 = 30) (3410 = 31) (3420 = 31) (3432 = 31) (3433 = 31) (3434 = 31) (3435 = 29) (3441 = 32) (3442 = 31) (3443 = 33) (3444 = 32) (3452 = 22) (3453 = 32) (3454 = 31) (3460 = 29) (3470 = 31) (3480 = 45) (3510 = 34) (3521 = 34) (3522 = 34) (3523 = 34) (3530 = 34) (3610 = 35) (3620 = 35) (3633 = 34) (3634 = 35) (3640 = 35) (3650 = 36) (3710 = 33) (3720 = 33) (3731 = 33) (3732 = 33) (3733 = 33) (3740 = 33) (4415 = 15) (4416 = 15) (4121 = 15) (4122 = 15) (4123 = 15) (4126 = 15) (4130 = 15) (4147 = 15) (4150 = 15) (4160 = 15) (4180 = 85) (4196 = 15) (4197 = 15) (4200 = 15) (4213 = 15) (4214 = 15) (4221 = 15) (4222 = 15) (4239 = 15) (4240 = 15) (4261 = 15) (4270 = 15) (4283 = 15) (4290 = 16) (4310 = 17) (4321 = 17) (4322 = 17) (4350 = 17) (4363 = 17) (4370 = 17) (4384 = 17) (4385 = 17) (4395 = 17) (4396 = 17) (4398 = 17) (4399 = 17) (4410 = 19) (4420 = 19) (4510 = 19) (4531 = 18) (4532 = 18) (4533 = 18) (4534 = 18) (4535 = 18) (4536 = 18) (4537 = 18) (4538 = 18) (4539 = 18) (4555 = 17) (4556 = 17) (4557 = 17) (4610 = 20) (4620 = 20) (4630 = 45) (4640 = 20) (4650 = 45) (4663 = 36) (4664 = 74) (4671 = 36) (4672 = 45) (4710 = 21) (4721 = 21) (4722 = 21) (4723 = 21) (4724 = 21) (4725 = 21) (4728 = 21) (4751 = 22) (4752 = 22) (4753 = 22) (4754 = 22) (4811 = 25) (4812 = 25) (4820 = 25) (4831 = 17) (4832 = 25) (4833 = 25) (4834 = 25) (4835 = 25) (4836 = 25) (4910 = 36) (4920 = 36) (4930 = 74) (4941 = 36) (4942 = 36) (4954 = 36) (4959 = 25) (5000 = 45) (6148 = 50) (6110 = 51) (6210 = 51) (6300 = 51) (6510 = 50) (6410 = 52) (6611 = 55) (6612 = 55) (6620 = 55) (6630 = 91) (6640 = 55) (6650 = 55) (6670 = 55) (6710 = 50) (6720 = 52) (6730 = 52) (7100 = 60) (7210 = 60) (7220 = 60) (7230 = 60) (7260 = 63) (7400 = 61) (7500 = 63) (7610 = 63) (7630 = 63) (7640 = 63) (7700 = 63) (7901 = 64) (7902 = 64) (8140 = 65) (8150 = 65) (8200 = 67) (8310 = 65) (8320 = 67) (8340 = 70) (8350 = 74) (8360 = 74) (8370 = 74) (8380 = 74) (8394 = 72) (8395 = 74) (8396 = 74) (8410 = 71) (8420 = 71) (8430 = 71) (8460 = 71) (8480 = 71) (8490 = 71) (8500 = 70) (9111 = 75) (9112 = 75) (9120 = 75) (9130 = 75) (9140 = 75) (9150 = 75) (9190 = 75) (9211 = 90) (9212 = 90) (9230 = 74) (9310 = 80) (9310 = 80) (9310 = 80) (9330 = 80) (9360 = 80) (9400 = 73) (9510 = 85) (9520 = 85) (9530 = 85) (9540 = 85) (9550 = 85) (9560 = 85) (9611 = 85) (9631 = 91) (9660 = 91) (9690 = 91) (9711 = 92) (9741 = 92) (9760 = 92) (9770 = 92) (9791 = 92) (9811 = 93) (9812 = 93) (9820 = 93) (9890 = 74) (9900 = 95), generate(in8092dm_actual)
label define sic92d_lab_actual 1 "agriculture,hunting,etc" 2 "forestry,logging etc" 5 "fishing,fish farms,hatcheries etc" 10 "coal,lignite mining,peat extraction" 11 "oil,gas extractn etc (not surveying)" 12 "uranium,thorium ore mining" 13 "mining of metal ores" 14 "other mining,quarrying" 15 "food,beverage manufacture" 16 "tobacco products manufacture" 17 "textile manufacture" 18 "clothing,fur manufacture" 19 "leather,leather goods manufacture" 20 "wood,straw,cork,wood prods(not furn)" 21 "pulp,paper,paper prods manufacture" 22 "printing,publishing,recorded media" 23 "coke,petrol prods,nuclear fuel man." 24 "chemicals,chemical products man." 25 "rubber,plastic products manufacture" 26 "other non-metallic products man." 27 "basic metals manufacture" 28 "fabric-metal prod (not mach,eqt) man." 29 "mach,eqt manufacture" 30 "office mach,computer manufacture" 31 "elec mach,eqt manufacture" 32 "radio,tv,communication eqt man." 33 "medical,precision,optical eqt man." 34 "motor veh,trailer,etc manufacture" 35 "other transport eqt manufacture" 36 "furniture etc manufacture" 37 "recycling" 40 "elec,gas,steam etc supply" 41 "water collection,purif.,supply etc" 45 "construction" 50 "sales of motor vehs,parts,fuel etc" 51 "wsale,commission trade (fee,contract)" 52 "retail trade (not motor veh) repairs" 55 "hotels,restaurants" 60 "transport by land,pipeline" 61 "water transport" 62 "air transport" 63 "aux transport activ.,travel agents" 64 "post,telecommunications" 65 "financl intermed(not insur.,pensions)" 66 "insurance,pensions (not social sec)" 67 "other financial (not insur.,pensions)" 70 "real estate activities" 71 "personal,hhld,mach,eqt rental(no op)" 72 "computer,related activities" 73 "research,development" 74 "other business activities" 75 "public admin,defence,social security" 80 "education" 85 "health,social work" 90 "sanitation,sewage,refuse disposal etc" 91 "activ. of membership organisations" 92 "recreational,cultural,sporting activ." 93 "other service activities" 95 "private hhlds with employed persons" 99 "extra-territorial organisations etc", replace
label values in8092dm_actual sic92d_lab_actual