******************************************************************************* * OESCH CLASS SCHEMA FOR RESPONDENTS AND THEIR PARTNERS * Create 16-Class schema * Data: Mosaich 2019 (containing ISCO08 codes) * October 2020 * Nathalie Vigna, University of Lausanne ******************************************************************************* ******************************************************************************* * Respondent's Oesch class position * Recode and create variables used to construct class variable for respondents * Variables used to construct class variable for respondents: ISCO08, EMPREL, NEMPLOY ******************************************************************************* **** Recode occupation variable (isco08 com-4-digit) for respondents tab WORK4ISCO, m recode WORK4ISCO (missing=-9), copyrest gen(isco08_mainjob) recode isco08_mainjob (0=-9) label variable isco08_mainjob "Current occupation of respondent - isco08 4-digit" tab isco08_mainjob **** Recode employment status for respondents recode WORK8a (1/9=1)(10/400000=2)(-1=.) (-2=.) (-7=.), gen(emplno_r) label define emplno_r /// 0 "0 employees" /// 1 "1-9 employees" /// 2 "10+ employees" label value emplno_r emplno_r tab emplno_r gen selfemp_r=9 replace selfemp_r=1 if emplno_r==1 | emplno_r==2 | WORK2==2 | WORK2==3 | WORK2==4 replace selfemp_r=2 if WORK2==1 label define selfemp_r 1"Self-employed" 2 "Employee" 9 "Missing" label value selfemp_r selfemp_r tab selfemp_r gen selfem_mainjob=. replace selfem_mainjob=1 if selfemp_r==2 | selfemp_r==9 replace selfem_mainjob=2 if (selfemp_r==1 & (emplno_r==0 | emplno_r==.)) | WORK2==2 | WORK2==4 replace selfem_mainjob=3 if (selfemp_r==1 | selfemp_r==9) & emplno_r==1 replace selfem_mainjob=4 if (selfemp_r==1 | selfemp_r==9) & emplno_r==2 label variable selfem_mainjob "Employment status for respondants" label define selfem_mainjob 1 "Not self-employed" 2 "Self-empl without employees" 3 "Self-empl with 1-9 employees" 4 "Self-empl with 10 or more" label value selfem_mainjob selfem_mainjob tab selfem_mainjob, m ***NB1: selfem_mainjob=1 if selfemp_r==9 -> people we don't know if they are self-employed or not are considered to be employees ***NB2: selfem_mainjob=2 selfemp_r==1 & emplno_r==. -> self-employed people we don't know how many employees they have are considered to be self-employed without employees ************************************************* * Create Oesch class schema for respondents * Create class16_r class8_r class5_r * Using isco08_mainjob and selfem_mainjob ************************************************* gen class16_r = -9 * Large employers (1) replace class16_r=1 if selfem_mainjob==4 * Self-employed professionals (2) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2000 & isco08_mainjob <= 2162) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2164 & isco08_mainjob <= 2165) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2200 & isco08_mainjob <= 2212) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob == 2250) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2261 & isco08_mainjob <= 2262) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2300 & isco08_mainjob <= 2330) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2350 & isco08_mainjob <= 2352) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2359 & isco08_mainjob <= 2432) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2500 & isco08_mainjob <= 2619) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob == 2621) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2630 & isco08_mainjob <= 2634) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2636 & isco08_mainjob <= 2640) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco08_mainjob >= 2642 & isco08_mainjob <= 2643) * Small business owners with employees (3) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob >= 1000 & isco08_mainjob <= 1439) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob == 2163) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob == 2166) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob >= 2220 & isco08_mainjob <= 2240) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob == 2260) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob >= 2263 & isco08_mainjob <= 2269) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob >= 2340 & isco08_mainjob <= 2342) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob >= 2353 & isco08_mainjob <= 2356) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob >= 2433 & isco08_mainjob <= 2434) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob == 2620) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob == 2622) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob == 2635) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob == 2641) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob >= 2650 & isco08_mainjob <= 2659) replace class16_r=3 if (selfem_mainjob==3) & (isco08_mainjob >= 3000 & isco08_mainjob <= 9629) * Small business owners without employees (4) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob >= 1000 & isco08_mainjob <= 1439) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob == 2163) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob == 2166) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob >= 2220 & isco08_mainjob <= 2240) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob == 2260) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob >= 2263 & isco08_mainjob <= 2269) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob >= 2340 & isco08_mainjob <= 2342) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob >= 2353 & isco08_mainjob <= 2356) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob >= 2433 & isco08_mainjob <= 2434) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob == 2620) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob == 2622) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob == 2635) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob == 2641) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob >= 2650 & isco08_mainjob <= 2659) replace class16_r=4 if (selfem_mainjob==2) & (isco08_mainjob >= 3000 & isco08_mainjob <= 9629) * Technical experts (5) replace class16_r=5 if (selfem_mainjob==1) & (isco08_mainjob >= 2100 & isco08_mainjob <= 2162) replace class16_r=5 if (selfem_mainjob==1) & (isco08_mainjob >= 2164 & isco08_mainjob <= 2165) replace class16_r=5 if (selfem_mainjob==1) & (isco08_mainjob >= 2500 & isco08_mainjob <= 2529) * Technicians (6) replace class16_r=6 if (selfem_mainjob==1) & (isco08_mainjob >= 3100 & isco08_mainjob <= 3155) replace class16_r=6 if (selfem_mainjob==1) & (isco08_mainjob >= 3210 & isco08_mainjob <= 3214) replace class16_r=6 if (selfem_mainjob==1) & (isco08_mainjob == 3252) replace class16_r=6 if (selfem_mainjob==1) & (isco08_mainjob >= 3500 & isco08_mainjob <= 3522) * Skilled manual (7) replace class16_r=7 if (selfem_mainjob==1) & (isco08_mainjob >= 6000 & isco08_mainjob <= 7549) replace class16_r=7 if (selfem_mainjob==1) & (isco08_mainjob >= 8310 & isco08_mainjob <= 8312) replace class16_r=7 if (selfem_mainjob==1) & (isco08_mainjob == 8330) replace class16_r=7 if (selfem_mainjob==1) & (isco08_mainjob >= 8332 & isco08_mainjob <= 8340) replace class16_r=7 if (selfem_mainjob==1) & (isco08_mainjob >= 8342 & isco08_mainjob <= 8344) * Low-skilled manual (8) replace class16_r=8 if (selfem_mainjob==1) & (isco08_mainjob >= 8000 & isco08_mainjob <= 8300) replace class16_r=8 if (selfem_mainjob==1) & (isco08_mainjob >= 8320 & isco08_mainjob <= 8321) replace class16_r=8 if (selfem_mainjob==1) & (isco08_mainjob == 8341) replace class16_r=8 if (selfem_mainjob==1) & (isco08_mainjob == 8350) replace class16_r=8 if (selfem_mainjob==1) & (isco08_mainjob >= 9200 & isco08_mainjob <= 9334) replace class16_r=8 if (selfem_mainjob==1) & (isco08_mainjob >= 9600 & isco08_mainjob <= 9620) replace class16_r=8 if (selfem_mainjob==1) & (isco08_mainjob >= 9622 & isco08_mainjob <= 9629) * Higher-grade managers and administrators (9) replace class16_r=9 if (selfem_mainjob==1) & (isco08_mainjob >= 1000 & isco08_mainjob <= 1300) replace class16_r=9 if (selfem_mainjob==1) & (isco08_mainjob >= 1320 & isco08_mainjob <= 1349) replace class16_r=9 if (selfem_mainjob==1) & (isco08_mainjob >= 2400 & isco08_mainjob <= 2432) replace class16_r=9 if (selfem_mainjob==1) & (isco08_mainjob >= 2610 & isco08_mainjob <= 2619) replace class16_r=9 if (selfem_mainjob==1) & (isco08_mainjob == 2631) replace class16_r=9 if (selfem_mainjob==1) & (isco08_mainjob >= 100 & isco08_mainjob <= 110) * Lower-grade managers and administrators (10) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob >= 1310 & isco08_mainjob <= 1312) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob >= 1400 & isco08_mainjob <= 1439) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob >= 2433 & isco08_mainjob <= 2434) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob >= 3300 & isco08_mainjob <= 3339) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob == 3343) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob >= 3350 & isco08_mainjob <= 3359) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob == 3411) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob == 5221) replace class16_r=10 if (selfem_mainjob==1) & (isco08_mainjob >= 200 & isco08_mainjob <= 210) * Skilled clerks (11) replace class16_r=11 if (selfem_mainjob==1) & (isco08_mainjob >= 3340 & isco08_mainjob <= 3342) replace class16_r=11 if (selfem_mainjob==1) & (isco08_mainjob == 3344) replace class16_r=11 if (selfem_mainjob==1) & (isco08_mainjob >= 4000 & isco08_mainjob <= 4131) replace class16_r=11 if (selfem_mainjob==1) & (isco08_mainjob >= 4200 & isco08_mainjob <= 4221) replace class16_r=11 if (selfem_mainjob==1) & (isco08_mainjob >= 4224 & isco08_mainjob <= 4413) replace class16_r=11 if (selfem_mainjob==1) & (isco08_mainjob >= 4415 & isco08_mainjob <= 4419) * Unskilled clerks (12) replace class16_r=12 if (selfem_mainjob==1) & (isco08_mainjob == 4132) replace class16_r=12 if (selfem_mainjob==1) & (isco08_mainjob == 4222) replace class16_r=12 if (selfem_mainjob==1) & (isco08_mainjob == 4223) replace class16_r=12 if (selfem_mainjob==1) & (isco08_mainjob == 5230) replace class16_r=12 if (selfem_mainjob==1) & (isco08_mainjob == 9621) * Socio-cultural professionals (13) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob >= 2200 & isco08_mainjob <= 2212) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob == 2250) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob >= 2261 & isco08_mainjob <= 2262) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob >= 2300 & isco08_mainjob <= 2330) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob >= 2350 & isco08_mainjob <= 2352) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob == 2359) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob == 2600) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob == 2621) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob == 2630) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob >= 2632 & isco08_mainjob <= 2634) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob >= 2636 & isco08_mainjob <= 2640) replace class16_r=13 if (selfem_mainjob==1) & (isco08_mainjob >= 2642 & isco08_mainjob <= 2643) * Socio-cultural semi-professionals (14) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 2163) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 2166) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 2220 & isco08_mainjob <= 2240) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 2260) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 2263 & isco08_mainjob <= 2269) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 2340 & isco08_mainjob <= 2342) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 2353 & isco08_mainjob <= 2356) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 2620) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 2622) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 2635) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 2641) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 2650 & isco08_mainjob <= 2659) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 3200) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 3220 & isco08_mainjob <= 3230) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 3250) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 3253 & isco08_mainjob <= 3257) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 3259) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 3400 & isco08_mainjob <= 3410) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 3412 & isco08_mainjob <= 3413) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob >= 3430 & isco08_mainjob <= 3433) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 3435) replace class16_r=14 if (selfem_mainjob==1) & (isco08_mainjob == 4414) * Skilled service (15) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 3240) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 3251) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 3258) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob >= 3420 & isco08_mainjob <= 3423) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 3434) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob >= 5000 & isco08_mainjob <= 5120) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob >= 5140 & isco08_mainjob <= 5142) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 5163) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 5165) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 5200) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 5220) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob >= 5222 & isco08_mainjob <= 5223) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob >= 5241 & isco08_mainjob <= 5242) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob >= 5300 & isco08_mainjob <= 5321) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob >= 5400 & isco08_mainjob <= 5413) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 5419) replace class16_r=15 if (selfem_mainjob==1) & (isco08_mainjob == 8331) * Low-skilled service (16) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob >= 5130 & isco08_mainjob <= 5132) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob >= 5150 & isco08_mainjob <= 5162) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob == 5164) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob == 5169) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob >= 5210 & isco08_mainjob <= 5212) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob == 5240) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob >= 5243 & isco08_mainjob <= 5249) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob >= 5322 & isco08_mainjob <= 5329) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob == 5414) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob == 8322) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob >= 9100 & isco08_mainjob <= 9129) replace class16_r=16 if (selfem_mainjob==1) & (isco08_mainjob >= 9400 & isco08_mainjob <= 9520) ***NB: a missing value in class16_r when isco08_mainjob!=. means that the value of selfem_mainjob was not coherent with the job type mvdecode class16_r, mv(-9) label variable class16_r "Respondent's Oesch class position - 16 classes" label define class16_r /// 1 "Large employers" /// 2 "Self-employed professionals" /// 3 "Small business owners with employees" /// 4 "Small business owners without employees" /// 5 "Technical experts" /// 6 "Technicians" /// 7 "Skilled manual" /// 8 "Low-skilled manual" /// 9 "Higher-grade managers and administrators" /// 10 "Lower-grade managers and administrators" /// 11 "Skilled clerks" /// 12 "Unskilled clerks" /// 13 "Socio-cultural professionals" /// 14 "Socio-cultural semi-professionals" /// 15 "Skilled service" /// 16 "Low-skilled service" label value class16_r class16_r tab class16_r ******************************************************************************* * OESCH CLASS SCHEMA FOR PARTNERS AND MERGED CLASS POSITION * Create 16-Class schema * Data: Mosaich 2019 (containing ISCO08 codes) * October 2020 * Nathalie Vigna, University of Lausanne ******************************************************************************* ******************************************************************************* * Partner's Oesch class position * Recode and create variables used to construct class variable for partners * Variables used to construct class variable for partners: SPISCO08, SPEMPREL * NB: Partners we don't know if they are self-employed or not are considered to be employees ******************************************************************************* recode PWORK4ISCO (missing=-9), copyrest gen(isco08_partner) recode isco08_partner (0=-9) label variable isco08_partner "Current occupation of partner - isco08 4-digit" gen selfem_partner=9 replace selfem_partner=1 if PWORK2==2 | PWORK2==3 | PWORK2==4 | PWORK2==5 replace selfem_partner=2 if PWORK2==1 label define selfem_partner 1"Self-employed" 2 "Employee" 9 "Missing" label value selfem_partner selfem_partner ************************************************* * Create Oesch class schema for partners * Create class16_p class8_p class5_p * Using isco08_partner and selfem_partner ************************************************* gen class16_p = -9 * Large employers (1) * Self-employed professionals (2) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2000 & isco08_partner <= 2162) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2164 & isco08_partner <= 2165) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2200 & isco08_partner <= 2212) replace class16_p=2 if (selfem_partner==1) & (isco08_partner == 2250) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2261 & isco08_partner <= 2262) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2300 & isco08_partner <= 2330) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2350 & isco08_partner <= 2352) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2359 & isco08_partner <= 2432) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2500 & isco08_partner <= 2619) replace class16_p=2 if (selfem_partner==1) & (isco08_partner == 2621) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2630 & isco08_partner <= 2634) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2636 & isco08_partner <= 2640) replace class16_p=2 if (selfem_partner==1) & (isco08_partner >= 2642 & isco08_partner <= 2643) * Small business owners with employees (3) * Small business owners without employees (4) replace class16_p=4 if (selfem_partner==1) & (isco08_partner >= 1000 & isco08_partner <= 1439) replace class16_p=4 if (selfem_partner==1) & (isco08_partner == 2163) replace class16_p=4 if (selfem_partner==1) & (isco08_partner == 2166) replace class16_p=4 if (selfem_partner==1) & (isco08_partner >= 2220 & isco08_partner <= 2240) replace class16_p=4 if (selfem_partner==1) & (isco08_partner == 2260) replace class16_p=4 if (selfem_partner==1) & (isco08_partner >= 2263 & isco08_partner <= 2269) replace class16_p=4 if (selfem_partner==1) & (isco08_partner >= 2340 & isco08_partner <= 2342) replace class16_p=4 if (selfem_partner==1) & (isco08_partner >= 2353 & isco08_partner <= 2356) replace class16_p=4 if (selfem_partner==1) & (isco08_partner >= 2433 & isco08_partner <= 2434) replace class16_p=4 if (selfem_partner==1) & (isco08_partner == 2620) replace class16_p=4 if (selfem_partner==1) & (isco08_partner == 2622) replace class16_p=4 if (selfem_partner==1) & (isco08_partner == 2635) replace class16_p=4 if (selfem_partner==1) & (isco08_partner == 2641) replace class16_p=4 if (selfem_partner==1) & (isco08_partner >= 2650 & isco08_partner <= 2659) replace class16_p=4 if (selfem_partner==1) & (isco08_partner >= 3000 & isco08_partner <= 9629) * Technical experts (5) replace class16_p=5 if (selfem_partner==2) & (isco08_partner >= 2100 & isco08_partner <= 2162) replace class16_p=5 if (selfem_partner==2) & (isco08_partner >= 2164 & isco08_partner <= 2165) replace class16_p=5 if (selfem_partner==2) & (isco08_partner >= 2500 & isco08_partner <= 2529) * Technicians (6) replace class16_p=6 if (selfem_partner==2) & (isco08_partner >= 3100 & isco08_partner <= 3155) replace class16_p=6 if (selfem_partner==2) & (isco08_partner >= 3210 & isco08_partner <= 3214) replace class16_p=6 if (selfem_partner==2) & (isco08_partner == 3252) replace class16_p=6 if (selfem_partner==2) & (isco08_partner >= 3500 & isco08_partner <= 3522) * Skilled manual (7) replace class16_p=7 if (selfem_partner==2) & (isco08_partner >= 6000 & isco08_partner <= 7549) replace class16_p=7 if (selfem_partner==2) & (isco08_partner >= 8310 & isco08_partner <= 8312) replace class16_p=7 if (selfem_partner==2) & (isco08_partner == 8330) replace class16_p=7 if (selfem_partner==2) & (isco08_partner >= 8332 & isco08_partner <= 8340) replace class16_p=7 if (selfem_partner==2) & (isco08_partner >= 8342 & isco08_partner <= 8344) * Low-skilled manual (8) replace class16_p=8 if (selfem_partner==2) & (isco08_partner >= 8000 & isco08_partner <= 8300) replace class16_p=8 if (selfem_partner==2) & (isco08_partner >= 8320 & isco08_partner <= 8321) replace class16_p=8 if (selfem_partner==2) & (isco08_partner == 8341) replace class16_p=8 if (selfem_partner==2) & (isco08_partner == 8350) replace class16_p=8 if (selfem_partner==2) & (isco08_partner >= 9200 & isco08_partner <= 9334) replace class16_p=8 if (selfem_partner==2) & (isco08_partner >= 9600 & isco08_partner <= 9620) replace class16_p=8 if (selfem_partner==2) & (isco08_partner >= 9622 & isco08_partner <= 9629) * Higher-grade managers and administrators (9) replace class16_p=9 if (selfem_partner==2) & (isco08_partner >= 1000 & isco08_partner <= 1300) replace class16_p=9 if (selfem_partner==2) & (isco08_partner >= 1320 & isco08_partner <= 1349) replace class16_p=9 if (selfem_partner==2) & (isco08_partner >= 2400 & isco08_partner <= 2432) replace class16_p=9 if (selfem_partner==2) & (isco08_partner >= 2610 & isco08_partner <= 2619) replace class16_p=9 if (selfem_partner==2) & (isco08_partner == 2631) replace class16_p=9 if (selfem_partner==2) & (isco08_partner >= 100 & isco08_partner <= 110) * Lower-grade managers and administrators (10) replace class16_p=10 if (selfem_partner==2) & (isco08_partner >= 1310 & isco08_partner <= 1312) replace class16_p=10 if (selfem_partner==2) & (isco08_partner >= 1400 & isco08_partner <= 1439) replace class16_p=10 if (selfem_partner==2) & (isco08_partner >= 2433 & isco08_partner <= 2434) replace class16_p=10 if (selfem_partner==2) & (isco08_partner >= 3300 & isco08_partner <= 3339) replace class16_p=10 if (selfem_partner==2) & (isco08_partner == 3343) replace class16_p=10 if (selfem_partner==2) & (isco08_partner >= 3350 & isco08_partner <= 3359) replace class16_p=10 if (selfem_partner==2) & (isco08_partner == 3411) replace class16_p=10 if (selfem_partner==2) & (isco08_partner == 5221) replace class16_p=10 if (selfem_partner==2) & (isco08_partner >= 200 & isco08_partner <= 210) * Skilled clerks (11) replace class16_p=11 if (selfem_partner==2) & (isco08_partner >= 3340 & isco08_partner <= 3342) replace class16_p=11 if (selfem_partner==2) & (isco08_partner == 3344) replace class16_p=11 if (selfem_partner==2) & (isco08_partner >= 4000 & isco08_partner <= 4131) replace class16_p=11 if (selfem_partner==2) & (isco08_partner >= 4200 & isco08_partner <= 4221) replace class16_p=11 if (selfem_partner==2) & (isco08_partner >= 4224 & isco08_partner <= 4413) replace class16_p=11 if (selfem_partner==2) & (isco08_partner >= 4415 & isco08_partner <= 4419) * Unskilled clerks (12) replace class16_p=12 if (selfem_partner==2) & (isco08_partner == 4132) replace class16_p=12 if (selfem_partner==2) & (isco08_partner == 4222) replace class16_p=12 if (selfem_partner==2) & (isco08_partner == 4223) replace class16_p=12 if (selfem_partner==2) & (isco08_partner == 5230) replace class16_p=12 if (selfem_partner==2) & (isco08_partner == 9621) * Socio-cultural professionals (13) replace class16_p=13 if (selfem_partner==2) & (isco08_partner >= 2200 & isco08_partner <= 2212) replace class16_p=13 if (selfem_partner==2) & (isco08_partner == 2250) replace class16_p=13 if (selfem_partner==2) & (isco08_partner >= 2261 & isco08_partner <= 2262) replace class16_p=13 if (selfem_partner==2) & (isco08_partner >= 2300 & isco08_partner <= 2330) replace class16_p=13 if (selfem_partner==2) & (isco08_partner >= 2350 & isco08_partner <= 2352) replace class16_p=13 if (selfem_partner==2) & (isco08_partner == 2359) replace class16_p=13 if (selfem_partner==2) & (isco08_partner == 2600) replace class16_p=13 if (selfem_partner==2) & (isco08_partner == 2621) replace class16_p=13 if (selfem_partner==2) & (isco08_partner == 2630) replace class16_p=13 if (selfem_partner==2) & (isco08_partner >= 2632 & isco08_partner <= 2634) replace class16_p=13 if (selfem_partner==2) & (isco08_partner >= 2636 & isco08_partner <= 2640) replace class16_p=13 if (selfem_partner==2) & (isco08_partner >= 2642 & isco08_partner <= 2643) * Socio-cultural semi-professionals (14) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 2163) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 2166) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 2220 & isco08_partner <= 2240) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 2260) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 2263 & isco08_partner <= 2269) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 2340 & isco08_partner <= 2342) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 2353 & isco08_partner <= 2356) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 2620) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 2622) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 2635) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 2641) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 2650 & isco08_partner <= 2659) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 3200) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 3220 & isco08_partner <= 3230) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 3250) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 3253 & isco08_partner <= 3257) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 3259) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 3400 & isco08_partner <= 3410) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 3412 & isco08_partner <= 3413) replace class16_p=14 if (selfem_partner==2) & (isco08_partner >= 3430 & isco08_partner <= 3433) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 3435) replace class16_p=14 if (selfem_partner==2) & (isco08_partner == 4414) * Skilled service (15) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 3240) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 3251) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 3258) replace class16_p=15 if (selfem_partner==2) & (isco08_partner >= 3420 & isco08_partner <= 3423) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 3434) replace class16_p=15 if (selfem_partner==2) & (isco08_partner >= 5000 & isco08_partner <= 5120) replace class16_p=15 if (selfem_partner==2) & (isco08_partner >= 5140 & isco08_partner <= 5142) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 5163) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 5165) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 5200) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 5220) replace class16_p=15 if (selfem_partner==2) & (isco08_partner >= 5222 & isco08_partner <= 5223) replace class16_p=15 if (selfem_partner==2) & (isco08_partner >= 5241 & isco08_partner <= 5242) replace class16_p=15 if (selfem_partner==2) & (isco08_partner >= 5300 & isco08_partner <= 5321) replace class16_p=15 if (selfem_partner==2) & (isco08_partner >= 5400 & isco08_partner <= 5413) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 5419) replace class16_p=15 if (selfem_partner==2) & (isco08_partner == 8331) * Low-skilled service (16) replace class16_p=16 if (selfem_partner==2) & (isco08_partner >= 5130 & isco08_partner <= 5132) replace class16_p=16 if (selfem_partner==2) & (isco08_partner >= 5150 & isco08_partner <= 5162) replace class16_p=16 if (selfem_partner==2) & (isco08_partner == 5164) replace class16_p=16 if (selfem_partner==2) & (isco08_partner == 5169) replace class16_p=16 if (selfem_partner==2) & (isco08_partner >= 5210 & isco08_partner <= 5212) replace class16_p=16 if (selfem_partner==2) & (isco08_partner == 5240) replace class16_p=16 if (selfem_partner==2) & (isco08_partner >= 5243 & isco08_partner <= 5249) replace class16_p=16 if (selfem_partner==2) & (isco08_partner >= 5322 & isco08_partner <= 5329) replace class16_p=16 if (selfem_partner==2) & (isco08_partner == 5414) replace class16_p=16 if (selfem_partner==2) & (isco08_partner == 8322) replace class16_p=16 if (selfem_partner==2) & (isco08_partner >= 9100 & isco08_partner <= 9129) replace class16_p=16 if (selfem_partner==2) & (isco08_partner >= 9400 & isco08_partner <= 9520) mvdecode class16_p, mv(-9) label variable class16_p "Partner's Oesch class position - 16 classes" label define class16_p /// 1 "Large employers" /// 2 "Self-employed professionals" /// 3 "Small business owners with employees" /// 4 "Small business owners without employees" /// 5 "Technical experts" /// 6 "Technicians" /// 7 "Skilled manual" /// 8 "Low-skilled manual" /// 9 "Higher-grade managers and administrators" /// 10 "Lower-grade managers and administrators" /// 11 "Skilled clerks" /// 12 "Unskilled clerks" /// 13 "Socio-cultural professionals" /// 14 "Socio-cultural semi-professionals" /// 15 "Skilled service" /// 16 "Low-skilled service" label value class16_p class16_p tab class16_p **************************************************************************************************** * Final Oesch class position * Merge two class variables (respondents and partners) * Assign the partner's Oesch class position if the respondent's Oesch class position is missing **************************************************************************************************** gen class16=class16_r replace class16=class16_p if class16_r==. label variable class16 "Final Oesch class position - 16 classes" label define class16 /// 1 "Large employers" /// 2 "Self-employed professionals" /// 3 "Small business owners with employees" /// 4 "Small business owners without employees" /// 5 "Technical experts" /// 6 "Technicians" /// 7 "Skilled manual" /// 8 "Low-skilled manual" /// 9 "Higher-grade managers and administrators" /// 10 "Lower-grade managers and administrators" /// 11 "Skilled clerks" /// 12 "Unskilled clerks" /// 13 "Socio-cultural professionals" /// 14 "Socio-cultural semi-professionals" /// 15 "Skilled service" /// 16 "Low-skilled service" label value class16 class16 tab class16 drop isco08_mainjob emplno_r selfem_mainjob isco08_partner selfem_partner