******************************************************************************* * OESCH CLASS SCHEMA * Create 16-Class schema, 8-Class schema and 5-Class schema * Data: ISSP cumulative dataset Social Inequalities (1987, 1992, 1999, 2009), annual datasets 1997-2013 (containing ISCO88 codes) * June 2020 * Nathalie Vigna, University of Lausanne ******************************************************************************* ******************************************************************************* *CLASS SCHEMA *NB1: The variable names are not always identical among the year datasets: it is necessary to check for each variable on the attached table and to rename it. /*NB2: SPECIFIC COUNTRY CODES The general code is not valid for some countries and some years, because of the absence of the ISCO codes, which have been substituted by specific country variables. Therefore, if using the cumulative dataset on social inequalities, some specific parts of the code (named “SPECIFIC …” and located at the end of the do-file) are needed for: - 1987: Poland, United States, Great Britain, Italy, Poland (only 5-class schema and 6-class schema are possible for this country in this year) - 1992: Great Britain, Sweden, Italy NB: These parts of the code need some specific country variables which are contained in the ADD-ON dataset. Class schema is not provided for: - cumulative dataset on social inequalities: 1987 Australia, 1992 Philippines, 1999 Japan - 1997: Great Britain, Italy, Netherlands, Slovenia, Philippines, Israel, Japan, Spain, France, portugal, Bangladesh - 1998: Great Britain, Northern Ireland, Italy, Japan, Chile - 1999: Austria, Slovenia, Philippines, Israel, Japan, France, Portugal - 2000: Austria, Italy, Isreael, France, South Africa - 2004: South Africa - 2008: Northern Ireland - 2012: South Africa*/ ******************************************************************************* ******************************************************************************* * Respondent's Oesch class position * Recode and create variables used to construct class variable for respondents * Variables used to construct class variable for respondents: ISCO88, NEMPLOY, SELFEMP, EMPREL, WRKTYPE * If using a cumulation of annual datasets including 2000 and 2010, it is also necessary to generate a YEAR variable ******************************************************************************* **** Recode occupation variable (isco88 com 4-digit) for respondents tab ISCO88, m recode ISCO88 (missing=-9), copyrest gen(isco88_mainjob) recode isco88_mainjob (0=-9) label variable isco88_mainjob "Current occupation of respondent - isco88 4-digit" tab isco88_mainjob **** Recode employment status for respondents recode NEMPLOY (9995=0)(1/9=1)(10/9990=2)(.=.) (.a=.) (.n=.) (9997=.) (9998=.) (9999=.), gen(emplno_r) *ONLY IF using annual dataset 2010: there is an observation coded 9995 which correspond in this year to "9995 employees or more" recode emplno_r (0=2) if NEMPLOY==9995 /*& YEAR==2010*/ *ONLY IF using annual dataset 2000: the value 99996 corresponds to 0 employees 9995 which correspond in this year to "9995 employees or more" recode emplno_r (99996=0) if NEMPLOY==99996 /*& YEAR==2000*/ label define emplno_r /// 0 "0 employees" /// 1 "1-9 employees" /// 2 "10+ employees" label value emplno_r emplno_r tab emplno_r ***NB: In 2002, 2003 and 2007 it is not possible to identify self-employed respondents with no emoloyees: in these years there are no "0" nor corresponding values in the variable "NEMPLOY". Moreover, in these years there are no variables distinguishing between self-employed with emoloyees and self-employed without employees. gen selfemp_r=9 *ONLY IF using annual datasets 1997 - 2001 or the cumulative dataset on Social Inequalities: replace selfemp_r=1 if emplno_r==1 | emplno_r==2 | SELFEMP==1 replace selfemp_r=2 if SELFEMP==2 *ONLY IF using annual datasets 2002 - 2009 or the cumulative dataset on Social Inequalities: replace selfemp_r=1 if emplno_r==1 | emplno_r==2 | WRKTYPE==4 replace selfemp_r=2 if WRKTYPE==1| WRKTYPE==2 | WRKTYPE==3 | WRKTYPE==5 | WRKTYPE==6 *ONLY IF using annual datasets 2010 - 2013 : replace selfemp_r=1 if emplno_r==1 | emplno_r==2 | EMPREL==2 | EMPREL==3 | EMPREL==4 replace selfemp_r=2 if EMPREL==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==.) *ONLY IF using datasets 2010 - 2013 : replace selfem_mainjob=2 if EMPREL==2 | EMPREL==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 respondents" 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 isco88_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) & (isco88_mainjob >= 2000 & isco88_mainjob <= 2229) replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (isco88_mainjob >= 2300 & isco88_mainjob <= 2470) * Small business owners with employees (3) replace class16_r=3 if (selfem_mainjob==3) & (isco88_mainjob >= 1000 & isco88_mainjob <= 1999) replace class16_r=3 if (selfem_mainjob==3) & (isco88_mainjob >= 3000 & isco88_mainjob <= 9333) replace class16_r=3 if (selfem_mainjob==3) & (isco88_mainjob == 2230) * Small business owners without employees (4) replace class16_r=4 if (selfem_mainjob==2) & (isco88_mainjob >= 1000 & isco88_mainjob <= 1999) replace class16_r=4 if (selfem_mainjob==2) & (isco88_mainjob >= 3000 & isco88_mainjob <= 9333) replace class16_r=4 if (selfem_mainjob==2) & (isco88_mainjob == 2230) * Technical experts (5) replace class16_r=5 if (selfem_mainjob==1) & (isco88_mainjob >= 2000 & isco88_mainjob <= 2213) * Technicians (6) replace class16_r=6 if (selfem_mainjob==1) & (isco88_mainjob >= 3000 & isco88_mainjob <= 3152) replace class16_r=6 if (selfem_mainjob==1) & (isco88_mainjob >= 3210 & isco88_mainjob <= 3213) replace class16_r=6 if (selfem_mainjob==1) & (isco88_mainjob == 3434) replace class16_r=6 if (selfem_mainjob==1) & (isco88_mainjob == 7900) * Skilled manual (7) replace class16_r=7 if (selfem_mainjob==1) & (isco88_mainjob >= 6000 & isco88_mainjob <= 7450) replace class16_r=7 if (selfem_mainjob==1) & (isco88_mainjob >= 7500 & isco88_mainjob <= 7510) replace class16_r=7 if (selfem_mainjob==1) & (isco88_mainjob >= 8310 & isco88_mainjob <= 8312) replace class16_r=7 if (selfem_mainjob==1) & (isco88_mainjob >= 8324 & isco88_mainjob <= 8330) replace class16_r=7 if (selfem_mainjob==1) & (isco88_mainjob >= 8332 & isco88_mainjob <= 8340) replace class16_r=7 if (selfem_mainjob==1) & (isco88_mainjob == 7520) replace class16_r=7 if (selfem_mainjob==1) & (isco88_mainjob == 8341) * Low-skilled manual (8) replace class16_r=8 if (selfem_mainjob==1) & (isco88_mainjob >= 8000 & isco88_mainjob <= 8300) replace class16_r=8 if (selfem_mainjob==1) & (isco88_mainjob >= 8320 & isco88_mainjob <= 8321) replace class16_r=8 if (selfem_mainjob==1) & (isco88_mainjob == 8331) replace class16_r=8 if (selfem_mainjob==1) & (isco88_mainjob >= 9153 & isco88_mainjob <= 9333) replace class16_r=8 if (selfem_mainjob==1) & (isco88_mainjob == 8400) replace class16_r=8 if (selfem_mainjob==1) & (isco88_mainjob == 7530) * Higher-grade managers and administrators (9) replace class16_r=9 if (selfem_mainjob==1) & (isco88_mainjob >= 1000 & isco88_mainjob <= 1239) replace class16_r=9 if (selfem_mainjob==1) & (isco88_mainjob >= 2400 & isco88_mainjob <= 2429) replace class16_r=9 if (selfem_mainjob==1) & (isco88_mainjob == 2441) replace class16_r=9 if (selfem_mainjob==1) & (isco88_mainjob == 2470) * Lower-grade managers and administrators (10) - "new" code ISCO (3439) replace class16_r=10 if (selfem_mainjob==1) & (isco88_mainjob >= 1300 & isco88_mainjob <= 1412) replace class16_r=10 if (selfem_mainjob==1) & (isco88_mainjob >= 3400 & isco88_mainjob <= 3433) replace class16_r=10 if (selfem_mainjob==1) & (isco88_mainjob >= 3439 & isco88_mainjob <= 3451) replace class16_r=10 if (selfem_mainjob==1) & (isco88_mainjob >= 1240 & isco88_mainjob <= 1252) replace class16_r=10 if (selfem_mainjob==1) & (isco88_mainjob ==1252) * Skilled clerks (11) replace class16_r=11 if (selfem_mainjob==1) & (isco88_mainjob >= 4000 & isco88_mainjob <= 4112) replace class16_r=11 if (selfem_mainjob==1) & (isco88_mainjob >= 4114 & isco88_mainjob <= 4210) replace class16_r=11 if (selfem_mainjob==1) & (isco88_mainjob >= 4212 & isco88_mainjob <= 4222) * Unskilled clerks (12) replace class16_r=12 if (selfem_mainjob==1) & (isco88_mainjob == 4113) replace class16_r=12 if (selfem_mainjob==1) & (isco88_mainjob == 4211) replace class16_r=12 if (selfem_mainjob==1) & (isco88_mainjob == 4223) * Socio-cultural professionals (13) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob >= 2220 & isco88_mainjob <= 2229) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob >= 2300 & isco88_mainjob <= 2323) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob >= 2340 & isco88_mainjob <= 2359) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob >= 2430 & isco88_mainjob <= 2440) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob >= 2442 & isco88_mainjob <= 2443) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob == 2445) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob == 2451) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob == 2460) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob == 3491) replace class16_r=13 if (selfem_mainjob==1) & (isco88_mainjob == 3492) * Socio-cultural semi-professionals (14) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob == 2230) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob >= 2330 & isco88_mainjob <= 2332) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob == 2444) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob >= 2446 & isco88_mainjob <= 2450) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob >= 2452 & isco88_mainjob <= 2455) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob == 3200) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob >= 3220 & isco88_mainjob <= 3224) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob == 3226) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob >= 3229 & isco88_mainjob <= 3342) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob >= 3460 & isco88_mainjob <= 3472) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob == 3480) replace class16_r=14 if (selfem_mainjob==1) & (isco88_mainjob >=2500 & isco88_mainjob<=2519) * Skilled service (15) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob == 3225) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob >= 3227 & isco88_mainjob <= 3228) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob >= 3473 & isco88_mainjob <= 3475) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob >= 5000 & isco88_mainjob <= 5113) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob == 5122) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob >= 5131 & isco88_mainjob <= 5132) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob >= 5140 & isco88_mainjob <= 5141) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob == 5143) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob >= 5160 & isco88_mainjob <= 5223) replace class16_r=15 if (selfem_mainjob==1) & (isco88_mainjob == 8323) * Low-skilled service (16) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob >= 5120 & isco88_mainjob <= 5121) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob >= 5123 & isco88_mainjob <= 5130) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob >= 5133 & isco88_mainjob <= 5139) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob == 5142) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob == 5149) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob == 5150) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob == 5151) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob == 5152) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob == 5230) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob == 8322) replace class16_r=16 if (selfem_mainjob==1) & (isco88_mainjob >= 9000 & isco88_mainjob <= 9152) ***NB: a missing value in class16_r when isco88_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 recode class16_r (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8), gen(class8_r) label variable class8_r "Respondent's Oesch class position - 8 classes" label define class8_r /// 1 "Self-employed professionals and large employers" /// 2 "Small business owners" /// 3 "Technical (semi-)professionals" /// 4 "Production workers" /// 5 "(Associate) managers" /// 6 "Clerks" /// 7 "Socio-cultural (semi-)professionals" /// 8 "Service workers" label value class8_r class8_r tab class8_r recode class16_r (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5), gen(class5_r) label variable class5_r "Respondent's Oesch class position - 5 classes" label define class5_r /// 1 "Higher-grade service class" /// 2 "Lower-grade service class" /// 3 "Small business owners" /// 4 "Skilled workers" /// 5 "Unskilled workers" label value class5_r class5_r tab class5_r ******************************************************************************* * Partner's Oesch class position * Recode and create variables used to construct class variable for partners * Variables used to construct class variable for partners: SPISCO88, SPSELFEM, SPWRKTYP (only for year 2002-2008), SPEMPREL (only for years 2010-2013) * NB: Partners we don't know if they are self-employed or not are considered to be employees. ******************************************************************************* recode SPISCO88 (missing=-9), copyrest gen(isco88_partner) recode isco88_partner (0=-9) label variable isco88_partner "Current occupation of partner - isco88 4-digit" gen selfem_partner=9 *ONLY IF using the cumulative dataset on Social Inequalities: replace selfem_partner=1 if SPSELFEM==1 replace selfem_partner=2 if SPSELFEM==2 *ONLY IF using annual datasets 2002-2009: replace selfem_partner =1 if SPWRKTYP==4 *ONLY IF using annual datsets 2010-2013: replace selfem_partner=1 if SPEMPREL==2 | SPEMPREL==3 | SPEMPREL==4 | SPEMPREL==5 replace selfem_partner=2 if SPEMPREL==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 isco88_partner and selfem_partner ************************************************* gen class16_p = -9 * Large employers (1) replace class16_p=1 if (selfem_partner==1) & (isco88_partner >= 1200 & isco88_partner <= 1239) * Self-employed professionals (2) replace class16_p=2 if (selfem_partner==1) & (isco88_partner >= 2000 & isco88_partner <= 2470) * Small business owners with employees (3) replace class16_p=3 if (selfem_partner==1) & (isco88_partner >= 1000 & isco88_partner <= 1143) replace class16_p=3 if (selfem_partner==1) & (isco88_partner >= 1300 & isco88_partner <= 1319) * Small business owners without employees (4) replace class16_p=4 if (selfem_partner==1) & (isco88_partner >= 3000 & isco88_partner <= 9333) * Technical experts (5) replace class16_p=5 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2000 & isco88_partner <= 2213) * Technicians (6) replace class16_p=6 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3000 & isco88_partner <= 3152) replace class16_p=6 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3210 & isco88_partner <= 3213) replace class16_p=6 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 3434) replace class16_p=6 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 7900) * Skilled manual (7) replace class16_p=7 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 6000 & isco88_partner <= 7442) replace class16_p=7 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 7500 & isco88_partner <= 7520) replace class16_p=7 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 8310 & isco88_partner <= 8312) replace class16_p=7 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 8324 & isco88_partner <= 8330) replace class16_p=7 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 8332 & isco88_partner <= 8341) * Low-skilled manual (8) replace class16_p=8 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 8000 & isco88_partner <= 8300) replace class16_p=8 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 8320 & isco88_partner <= 8321) replace class16_p=8 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 8331) replace class16_p=8 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 8400) replace class16_p=8 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 9153 & isco88_partner <= 9333) * Higher-grade managers and administrators (9) replace class16_p=9 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 1000 & isco88_partner <= 1239) replace class16_p=9 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2400 & isco88_partner <= 2429) replace class16_p=9 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 2441) replace class16_p=9 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 2470) * Lower-grade managers and administrators (10) - "new" code ISCO (3439) replace class16_p=10 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 1300 & isco88_partner <= 1320) replace class16_p=10 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3400 & isco88_partner <= 3433) replace class16_p=10 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3439 & isco88_partner <= 3451) replace class16_p=10 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 1240 & isco88_partner <= 1252) replace class16_p=10 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 1320 & isco88_partner <= 1412) * Skilled clerks (11) replace class16_p=11 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 4000 & isco88_partner <= 4112) replace class16_p=11 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 4114 & isco88_partner <= 4210) replace class16_p=11 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 4212 & isco88_partner <= 4222) * Unskilled clerks (12) replace class16_p=12 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 4113) replace class16_p=12 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 4211) replace class16_p=12 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 4223) * Socio-cultural professionals (13) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2220 & isco88_partner <= 2229) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2300 & isco88_partner <= 2323) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2340 & isco88_partner <= 2359) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2430 & isco88_partner <= 2440) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2442 & isco88_partner <= 2443) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 2445) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 2451) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 2460) replace class16_p=13 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 3491) * Socio-cultural semi-professionals (14) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 2230) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2330 & isco88_partner <= 2332) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 2444) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2446 & isco88_partner <= 2450) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 2452 & isco88_partner <= 2455) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 3200) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3220 & isco88_partner <= 3224) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 3226) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3229 & isco88_partner <= 3342) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3460 & isco88_partner <= 3472) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 3480) replace class16_p=14 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner==2500 |isco88_partner==2511 | isco88_partner==2512| isco88_partner==2513 | isco88_partner==2519) * Skilled service (15) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 3225) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3227 & isco88_partner <= 3228) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 3473 & isco88_partner <= 3475) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 5000 & isco88_partner <= 5113) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 5122) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 5131 & isco88_partner <= 5132) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 5140 & isco88_partner <= 5141) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 5143) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 5160 & isco88_partner <= 5223) replace class16_p=15 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 8323) * Low-skilled service (16) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 5120 & isco88_partner <= 5121) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 5123 & isco88_partner <= 5130) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 5133 & isco88_partner <= 5139) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 5142) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 5149) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >=5150 & isco88_partner <=5152) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 5230) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner == 8322) replace class16_p=16 if (selfem_partner==2 | selfem_partner==9) & (isco88_partner >= 9000 & isco88_partner <= 9152) 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 recode class16_p (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8), gen(class8_p) label variable class8_p "Partner's Oesch class position - 8 classes" label define class8_p /// 1 "Self-employed professionals and large employers" /// 2 "Small business owners" /// 3 "Technical (semi-)professionals" /// 4 "Production workers" /// 5 "(Associate) managers" /// 6 "Clerks" /// 7 "Socio-cultural (semi-)professionals" /// 8 "Service workers" label value class8_p class8_p tab class8_p recode class16_p (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5), gen(class5_p) label variable class5_p "Partner's Oesch class position - 5 classes" label define class5_p /// 1 "Higher-grade service class" /// 2 "Lower-grade service class" /// 3 "Small business owners" /// 4 "Skilled workers" /// 5 "Unskilled workers" label value class5_p class5_p tab class5_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 recode class16 (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8), gen(class8) label variable class8 "Final Oesch class position - 8 classes" label define class8 /// 1 "Self-employed professionals and large employers" /// 2 "Small business owners" /// 3 "Technical (semi-)professionals" /// 4 "Production workers" /// 5 "(Associate) managers" /// 6 "Clerks" /// 7 "Socio-cultural (semi-)professionals" /// 8 "Service workers" label value class8 class8 tab class8 recode class16 (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5), gen(class5) label variable class5 "Final Oesch class position - 5 classes" label define class5 /// 1 "Higher-grade service class" /// 2 "Lower-grade service class" /// 3 "Small business owners" /// 4 "Skilled workers" /// 5 "Unskilled workers" label value class5 class5 tab class5 drop isco88_mainjob emplno_r selfem_mainjob isco88_partner selfem_partner /* NB: For the following countries and years, the class variables should be completely emply, even if the code involountary produces some wrong information: - 1997: Great Britain, Italy, Netherlands, Slovenia, Philippines, Israel, Japan, Spain, France, portugal, Bangladesh - 1998: Great Britain, Northern Ireland, Italy, Japan, Chile - 1999: Austria, Slovenia, Philippines, Israel, Japan, France, Portugal - 2000: Austria, Italy, Isreael, France, South Africa - 2004: South Africa - 2008: Northern Ireland - 2012: South Africa*/ ******************************************************************************* /*ONLY IF using cumulative dataset on social inequalities: specific Oesch’s class schema for: - 1987: Poland, United States, Great Britain, Italy, Poland (only 5-class schema and 6-class schema are possible for this country in this year) - 1992: Great Britain, Sweden, Italy NB: These parts of the code need some specific country variables which are contained in the ADD-ON dataset*/ ******************************************************************************* *two variables are necessary to identify observations for each country and each year rename V6 COUNTRY rename V4 YEAR ******************************************************************************* ******************************************************************************* * SPECIFIC Oesch’s class schema for Great Britain 1987 ******************************************************************************* ************************************************* * Create Oesch class schema for respondent * Create GB87_class * Using GB_OCC87 and SELFEMP ************************************************* *Class schema for respondent gen GB87_class=. * Large employers (1) replace GB87_class=1 if SELFEMP==1 & GB_OCC87==3 replace GB87_class=1 if SELFEMP==1 & GB_OCC87==5 replace GB87_class=1 if SELFEMP==1 & GB_OCC87==7 replace GB87_class=1 if SELFEMP==1 & GB_OCC87==9 replace GB87_class=1 if SELFEMP==1 & GB_OCC87==34 replace GB87_class=1 if SELFEMP==1 & GB_OCC87==36 replace GB87_class=1 if SELFEMP==1 & GB_OCC87==38 replace GB87_class=1 if SELFEMP==1 & GB_OCC87==44 ****NB: no good differenciation possible between (1) and (3) * Self-employed professionals (2) replace GB87_class=2 if SELFEMP==1 & GB_OCC87==1 replace GB87_class=2 if SELFEMP==1 & GB_OCC87==2 replace GB87_class=2 if SELFEMP==1 & GB_OCC87==4 replace GB87_class=2 if SELFEMP==1 & GB_OCC87>=10 & GB_OCC87<=21 replace GB87_class=2 if SELFEMP==1 & GB_OCC87>=24 & GB_OCC87<=33 * Small business owners with employees (3) replace GB87_class=3 if SELFEMP==1 & GB_OCC87==35 replace GB87_class=3 if SELFEMP==1 & GB_OCC87==37 replace GB87_class=3 if SELFEMP==1 & GB_OCC87==39 * Small business owners without employees (4) replace GB87_class=4 if SELFEMP==1 & GB_OCC87==6 replace GB87_class=4 if SELFEMP==1 & GB_OCC87==22 replace GB87_class=4 if SELFEMP==1 & GB_OCC87==32 replace GB87_class=4 if SELFEMP==1 & GB_OCC87==40 replace GB87_class=4 if SELFEMP==1 & GB_OCC87==43 replace GB87_class=4 if SELFEMP==1 & GB_OCC87>=45 & GB_OCC87<=998 * Technical experts (5) replace GB87_class=5 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==4 replace GB87_class=5 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=24 & GB_OCC87<=28 replace GB87_class=5 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==30 replace GB87_class=5 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==31 replace GB87_class=5 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==33 * Technicians (6) replace GB87_class=6 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==6 replace GB87_class=6 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==22 replace GB87_class=6 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==32 * Skilled manual (7) replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==63 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==76 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==78 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==79 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==85 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==87 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=90 & GB_OCC87<=95 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==102 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==111 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==114 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==115 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=118 & GB_OCC87<=128 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==130 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==132 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==133 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==139 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==140 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==143 replace GB87_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==998 * Low-skilled manual (8) replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==40 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==77 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==80 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==83 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==89 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=97 & GB_OCC87<=101 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=105 & GB_OCC8<=110 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==112 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==113 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==117 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==129 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==131 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=134 & GB_OCC87<=138 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==141 replace GB87_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=144 & GB_OCC87<=161 * Higher-grade managers and administrators (9) replace GB87_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=1 & GB_OCC87<=3 replace GB87_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==5 replace GB87_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==7 replace GB87_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==9 replace GB87_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=34 & GB_OCC87<=36 replace GB87_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==44 * Lower-grade managers and administrators (10) replace GB87_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=37 & GB_OCC87<=39 replace GB87_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==57 replace GB87_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==60 ***NB: no good differenciation possible between (9) and (10) for manager of "small" entreprises * Skilled clerks (11) replace GB87_class=11 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=45 & GB_OCC87<=46 replace GB87_class=11 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=48 & GB_OCC87<=50 replace GB87_class=11 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=53 & GB_OCC87<=54 * Unskilled clerks (12) replace GB87_class=12 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==51 replace GB87_class=12 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==47 * Socio-cultural professionals (13) replace GB87_class=13 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=10 & GB_OCC87<=11 replace GB87_class=13 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=13 & GB_OCC87<=19 * Socio-cultural semi-professionals (14) replace GB87_class=14 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==12 replace GB87_class=14 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==20 replace GB87_class=14 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==21 replace GB87_class=14 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==29 * Skilled service (15) replace GB87_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==43 replace GB87_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==55 replace GB87_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==56 replace GB87_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==61 replace GB87_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==62 replace GB87_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==64 replace GB87_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==74 * Low-skilled service (16) replace GB87_class=16 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87>=65 & GB_OCC87<=72 replace GB87_class=16 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC87==75 * Not classifiable (0): military + "other occupation" replace GB87_class=0 if GB_OCC87==41 replace GB87_class=0 if GB_OCC87==458 replace GB87_class=. if GB_OCC87==.i replace GB87_class=. if GB_OCC87==.n tab GB87_class if COUNTRY==82601 & YEAR==1987, m ************************************************* * Create Oesch class schema for partner * Create GB87_pclass * Using GB_SOCC87 and SPSELFEM ************************************************* gen GB87_pclass=. * Large employers (1) replace GB87_pclass=1 if SPSELFEM==1 & GB_SOC87==3 replace GB87_pclass=1 if SPSELFEM==1 & GB_SOC87==5 replace GB87_pclass=1 if SPSELFEM==1 & GB_SOC87==7 replace GB87_pclass=1 if SPSELFEM==1 & GB_SOC87==9 replace GB87_pclass=1 if SPSELFEM==1 & GB_SOC87==34 replace GB87_pclass=1 if SPSELFEM==1 & GB_SOC87==36 replace GB87_pclass=1 if SPSELFEM==1 & GB_SOC87==38 replace GB87_pclass=1 if SPSELFEM==1 & GB_SOC87==44 ****NB: no good differenciation possible between (1) and (3) * Self-employed professionals (2) replace GB87_pclass=2 if SPSELFEM==1 & GB_SOC87==1 replace GB87_pclass=2 if SPSELFEM==1 & GB_SOC87==2 replace GB87_pclass=2 if SPSELFEM==1 & GB_SOC87==4 replace GB87_pclass=2 if SPSELFEM==1 & GB_SOC87>=10 & GB_SOC87<=21 replace GB87_pclass=2 if SPSELFEM==1 & GB_SOC87>=24 & GB_SOC87<=33 * Small business owners with employees (3) replace GB87_pclass=3 if SPSELFEM==1 & GB_SOC87==35 replace GB87_pclass=3 if SPSELFEM==1 & GB_SOC87==37 replace GB87_pclass=3 if SPSELFEM==1 & GB_SOC87==39 * Small business owners without employees (4) replace GB87_pclass=4 if SPSELFEM==1 & GB_SOC87==6 replace GB87_pclass=4 if SPSELFEM==1 & GB_SOC87==22 replace GB87_pclass=4 if SPSELFEM==1 & GB_SOC87==32 replace GB87_pclass=4 if SPSELFEM==1 & GB_SOC87==40 replace GB87_pclass=4 if SPSELFEM==1 & GB_SOC87==43 replace GB87_pclass=4 if SPSELFEM==1 & GB_SOC87>=45 & GB_SOC87<=998 * Technical experts (5) replace GB87_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==4 replace GB87_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=24 & GB_SOC87<=28 replace GB87_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==30 replace GB87_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==31 replace GB87_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==33 * Technicians (6) replace GB87_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==6 replace GB87_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==22 replace GB87_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==32 * Skilled manual (7) replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==63 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==76 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==78 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==79 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==85 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==87 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=90 & GB_SOC87<=95 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==102 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==111 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==114 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==115 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=118 & GB_SOC87<=128 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==130 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==132 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==133 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==139 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==140 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==143 replace GB87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==998 * Low-skilled manual (8) replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==40 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==77 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==80 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==83 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==89 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=97 & GB_SOC87<=101 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=105 & GB_OCC8<=110 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==112 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==113 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==117 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==129 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==131 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=134 & GB_SOC87<=138 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==141 replace GB87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=144 & GB_SOC87<=161 * Higher-grade managers and administrators (9) replace GB87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=1 & GB_SOC87<=3 replace GB87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==5 replace GB87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==7 replace GB87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==9 replace GB87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=34 & GB_SOC87<=36 replace GB87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==44 * Lower-grade managers and administrators (10) replace GB87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=37 & GB_SOC87<=39 replace GB87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==57 replace GB87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==60 ****NB: no good differenciation possible between (9) and (10) fpr manager of "small" entreprises * Skilled clerks (11) replace GB87_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=45 & GB_SOC87<=46 replace GB87_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=48 & GB_SOC87<=50 replace GB87_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=53 & GB_SOC87<=54 * Unskilled clerks (12) replace GB87_pclass=12 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==51 replace GB87_pclass=12 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==47 * Socio-cultural professionals (13) replace GB87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=10 & GB_SOC87<=10 replace GB87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=14 & GB_SOC87<=19 replace GB87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==11 * Socio-cultural semi-professionals (14) replace GB87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==12 replace GB87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==13 replace GB87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==20 replace GB87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==21 replace GB87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==29 * Skilled service (15) replace GB87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==43 replace GB87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==55 replace GB87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==56 replace GB87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==61 replace GB87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==62 replace GB87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==64 replace GB87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==74 * Low-skilled service (16) replace GB87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87>=65 & GB_SOC87<=72 replace GB87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & GB_SOC87==75 * Not classifiable (0): military + "other occupation" replace GB87_pclass=0 if GB_SOC87==41 replace GB87_pclass=0 if GB_SOC87==458 replace GB87_pclass=. if GB_SOC87==.i replace GB87_pclass=. if GB_SOC87==.n tab GB87_pclass if COUNTRY==82601 & YEAR==1987, m ********************************************************* * Recode class16_r, class16_p, class8_r, class8_p, class5_r, class5_p * Recode class16, class8, class5 * for Great Britain 1987 ********************************************************* replace class16_r=GB87_class if COUNTRY==82601 & YEAR==1987 replace class16_p=GB87_pclass if COUNTRY==82601 & YEAR==1987 recode class16_r (0=.) recode class16_p (0=.) replace class8_r=class16_r if COUNTRY==82601 & YEAR==1987 recode class8_r (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==82601 & YEAR==1987 replace class8_p=class16_p if COUNTRY==82601 & YEAR==1987 recode class8_p (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==82601 & YEAR==1987 replace class5_r=class16_r if COUNTRY==82601 & YEAR==1987 recode class5_r (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==82601 & YEAR==1987 replace class5_p=class16_p if COUNTRY==82601 & YEAR==1987 recode class5_p (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==82601 & YEAR==1987 replace class16=class16_r if COUNTRY==82601 & YEAR==1987 replace class16=class16_p if class16_r==. & COUNTRY==82601 & YEAR==1987 replace class8=class16 if COUNTRY==82601 & YEAR==1987 recode class8 (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==82601 & YEAR==1987 replace class5=class16 if COUNTRY==82601 & YEAR==1987 recode class5 (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==82601 & YEAR==1987 ******************************************************************************* * SPECIFIC Oesch’s class schema for Great Britain 1992 ******************************************************************************* ************************************************* * Create Oesch class schema for respondent * Create GB92_class * Using GB_OCC92 and SELFEMP ************************************************* ***CLASSES FOR GB 1992 gen GB92_class=. * Large employers (1) replace GB92_class=1 if SELFEMP==1 & GB_OCC92>=10 & GB_OCC92<=19 ***NB: no good differenciation possible between (1) and (3) * Self-employed professionals (2) replace GB92_class=2 if SELFEMP==1 & GB_OCC92>=20 & GB_OCC92<=29 replace GB92_class=2 if SELFEMP==1 & GB_OCC92>=31 & GB_OCC92<=32 replace GB92_class=2 if SELFEMP==1 & GB_OCC92>=34 & GB_OCC92<=37 * Small business owners with employees (3) replace GB92_class=3 if SELFEMP==1 & GB_OCC92==94 * Small business owners without employees (4) replace GB92_class=4 if SELFEMP==1 & GB_OCC92==30 replace GB92_class=4 if SELFEMP==1 & GB_OCC92==33 replace GB92_class=4 if SELFEMP==1 & GB_OCC92>=38 & GB_OCC92<=93 replace GB92_class=4 if SELFEMP==1 & GB_OCC92==95 * Technical experts (5) replace GB92_class=5 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=20 & GB_OCC92<=21 replace GB92_class=5 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==26 * Technicians (6) replace GB92_class=6 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==30 replace GB92_class=6 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==33 * Skilled manual (7) replace GB92_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=50 & GB_OCC92<=59 replace GB92_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==80 replace GB92_class=7 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==90 * Low-skilled manual (8) replace GB92_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=81 & GB_OCC92<=89 replace GB92_class=8 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=91 & GB_OCC92<=93 * Higher-grade managers and administrators (9) replace GB92_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=10 & GB_OCC92<=19 replace GB92_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=24 & GB_OCC92<=25 replace GB92_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==29 replace GB92_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=31 & GB_OCC92<=32 replace GB92_class=9 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=35 & GB_OCC92<=36 * Lower-grade managers and administrators (10) replace GB92_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==39 replace GB92_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==94 replace GB92_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==15 replace GB92_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==70 replace GB92_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==71 replace GB92_class=10 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==94 ****NB: no good differenciation possible between (9) and (10) for manager of "small" entreprises * Skilled clerks (11) replace GB92_class=11 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==40 replace GB92_class=11 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=42 & GB_OCC92<=45 replace GB92_class=11 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=47 & GB_OCC92<=49 * Unskilled clerks (12) replace GB92_class=12 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==41 replace GB92_class=12 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==46 * Socio-cultural professionals (13) replace GB92_class=13 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=22 & GB_OCC92<=23 replace GB92_class=13 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==27 replace GB92_class=13 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==34 replace GB92_class=13 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==64 * Socio-cultural semi-professionals (14) replace GB92_class=14 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=37 & GB_OCC92<=38 replace GB92_class=14 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=22 & GB_OCC92<=23 * Skilled service (15) replace GB92_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==61 replace GB92_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==63 replace GB92_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==69 replace GB92_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=65 & GB_OCC92<=66 replace GB92_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92>=72 & GB_OCC92<=79 replace GB92_class=15 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==95 * Low-skilled service (16) replace GB92_class=16 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==62 replace GB92_class=16 if (SELFEMP==2 | SELFEMP==.a) & GB_OCC92==67 * Not classifiable (0): military + "other occupation" replace GB92_class=0 if GB_OCC92==99 replace GB92_class=0 if GB_OCC92==60 replace GB92_class=. if GB_OCC92==.n tab GB92_class if COUNTRY==82601 & YEAR==1992, m ************************************************* * Create Oesch class schema for partner * Create GB92_pclass * Using GB_SOCC92 and SPSELFEM ************************************************* gen GB92_pclass=. * Large employers (1) replace GB92_pclass=1 if SPSELFEM==1 & GB_SOC92>=10 & GB_SOC92<=19 ****NB: no good differenciation possible between (1) and (3) * Self-employed professionals (2) replace GB92_pclass=2 if SPSELFEM==1 & GB_SOC92>=20 & GB_SOC92<=29 replace GB92_pclass=2 if SPSELFEM==1 & GB_SOC92>=31 & GB_SOC92<=32 replace GB92_pclass=2 if SPSELFEM==1 & GB_SOC92>=34 & GB_SOC92<=37 * Small business owners with employees (3) replace GB92_pclass=3 if SPSELFEM==1 & GB_SOC92==94 * Small business owners without employees (4) replace GB92_pclass=4 if SPSELFEM==1 & GB_SOC92==30 replace GB92_pclass=4 if SPSELFEM==1 & GB_SOC92==33 replace GB92_pclass=4 if SPSELFEM==1 & GB_SOC92>=38 & GB_SOC92<=93 replace GB92_pclass=4 if SPSELFEM==1 & GB_SOC92==95 * Technical experts (5) replace GB92_pclass=5 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=20 & GB_SOC92<=21 replace GB92_pclass=5 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==26 * Technicians (6) replace GB92_pclass=6 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==30 replace GB92_pclass=6 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==33 * Skilled manual (7) replace GB92_pclass=7 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=50 & GB_SOC92<=59 replace GB92_pclass=7 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==80 replace GB92_pclass=7 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==90 * Low-skilled manual (8) replace GB92_pclass=8 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=81 & GB_SOC92<=89 replace GB92_pclass=8 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=91 & GB_SOC92<=93 * Higher-grade managers and administrators (9) replace GB92_pclass=9 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=10 & GB_SOC92<=19 replace GB92_pclass=9 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=24 & GB_SOC92<=25 replace GB92_pclass=9 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==29 replace GB92_pclass=9 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=31 & GB_SOC92<=32 replace GB92_pclass=9 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=35 & GB_SOC92<=36 * Lower-grade managers and administrators (10) replace GB92_pclass=10 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==39 replace GB92_pclass=10 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==94 replace GB92_pclass=10 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==15 replace GB92_pclass=10 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==70 replace GB92_pclass=10 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==71 replace GB92_pclass=10 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==94 ****NB: no good differenciation possible between (9) and (10) fpr manager of "small" entreprises * Skilled clerks (11) replace GB92_pclass=11 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==40 replace GB92_pclass=11 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=42 & GB_SOC92<=45 replace GB92_pclass=11 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=47 & GB_SOC92<=49 * Unskilled clerks (12) replace GB92_pclass=12 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==41 replace GB92_pclass=12 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==46 * Socio-cultural professionals (13) replace GB92_pclass=13 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=22 & GB_SOC92<=23 replace GB92_pclass=13 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==27 replace GB92_pclass=13 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==34 replace GB92_pclass=13 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==64 * Socio-cultural semi-professionals (14) replace GB92_pclass=14 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=37 & GB_SOC92<=38 replace GB92_pclass=14 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=22 & GB_SOC92<=23 * Skilled service (15) replace GB92_pclass=15 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==61 replace GB92_pclass=15 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==63 replace GB92_pclass=15 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==69 replace GB92_pclass=15 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=65 & GB_SOC92<=66 replace GB92_pclass=15 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92>=72 & GB_SOC92<=79 replace GB92_pclass=15 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==95 * Low-skilled service (16) replace GB92_pclass=16 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==62 replace GB92_pclass=16 if SPSELFEM==2 | SPSELFEM==.a & GB_SOC92==67 * Not classifiable (0): military + "other occupation" replace GB92_pclass=. if GB_SOC92==99 replace GB92_pclass=. if GB_SOC92==60 replace GB92_pclass=. if GB_SOC92==.n tab GB92_pclass if COUNTRY==82601 & YEAR==1992, m ********************************************************* * Recode class16_r, class16_p, class8_r, class8_p, class5_r, class5_p * Recode class16, class8, class5 * for Great Britain 1992 ********************************************************* replace class16_r=GB92_class if COUNTRY==82601 & YEAR==1992 replace class16_p=GB92_pclass if COUNTRY==82601 & YEAR==1992 recode class16_r (0=.) recode class16_p (0=.) replace class8_r=class16_r if COUNTRY==82601 & YEAR==1992 recode class8_r (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==82601 & YEAR==1992 replace class8_p=class16_p if COUNTRY==82601 & YEAR==1992 recode class8_p (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==82601 & YEAR==1992 replace class5_r=class16_r if COUNTRY==82601 & YEAR==1992 recode class5_r (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==82601 & YEAR==1992 replace class5_p=class16_p if COUNTRY==82601 & YEAR==1992 recode class5_p (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==82601 & YEAR==1992 replace class16=class16_r if COUNTRY==82601 & YEAR==1992 replace class16=class16_p if class16_r==. & COUNTRY==82601 & YEAR==1992 replace class8=class16 if COUNTRY==82601 & YEAR==1992 recode class8 (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==82601 & YEAR==1992 replace class5=class16 if COUNTRY==82601 & YEAR==1992 recode class5 (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==82601 & YEAR==1992 ******************************************************************************* * SPECIFIC Oesch’s class schema for Sweden 1992 ******************************************************************************* ************************************************* * Create Oesch class schema for respondent * Create SE92_class * Using SE_OCC92 and SELFEMP ************************************************* gen SE92_class=. * Large employers (1) replace SE92_class=1 if SELFEMP==1 & SE_OCC92==221 replace SE92_class=1 if SELFEMP==1 & SE_OCC92==232 ****NB: no good differenciation possible between (1) and (3) * Self-employed professionals (2) replace SE92_class=2 if SELFEMP==1 & SE_OCC92 replace SE92_class=2 if SELFEMP==1 & SE_OCC92>=1 & SE_OCC92<=8 replace SE92_class=2 if SELFEMP==1 & SE_OCC92>=15 & SE_OCC92<=71 replace SE92_class=2 if SELFEMP==1 & SE_OCC92>=76 & SE_OCC92<=104 replace SE92_class=2 if SELFEMP==1 & SE_OCC92>=106 & SE_OCC92<=131 replace SE92_class=2 if SELFEMP==1 & SE_OCC92==155 replace SE92_class=2 if SELFEMP==1 & SE_OCC92==191 replace SE92_class=2 if SELFEMP==1 & SE_OCC92==219 replace SE92_class=2 if SELFEMP==1 & SE_OCC92>=251 & SE_OCC92<=261 * Small business owners with employees (3) replace SE92_class=3 if SELFEMP==1 & SE_OCC92==152 replace SE92_class=3 if SELFEMP==1 & SE_OCC92>=201 & SE_OCC92<=212 replace SE92_class=3 if SELFEMP==1 & SE_OCC92==297 replace SE92_class=3 if SE_OCC92==331 replace SE92_class=3 if SE_OCC92==400 replace SE92_class=3 if SELFEMP==1 & SE_OCC92==404 * Small business owners without employees (4) replace SE92_class=4 if SELFEMP==1 & SE_OCC92>=9 & SE_OCC92<=13 replace SE92_class=4 if SELFEMP==1 & SE_OCC92==74 replace SE92_class=4 if SELFEMP==1 & SE_OCC92==105 replace SE92_class=4 if SELFEMP==1 & SE_OCC92==139 replace SE92_class=4 if SELFEMP==1 & SE_OCC92==151 replace SE92_class=4 if SELFEMP==1 & SE_OCC92==154 replace SE92_class=4 if SELFEMP==1 & SE_OCC92>=159 & SE_OCC92<=169 replace SE92_class=4 if SELFEMP==1 & SE_OCC92>=241 & SE_OCC92<=249 replace SE92_class=4 if SELFEMP==1 & SE_OCC92>=291 & SE_OCC92<=296 replace SE92_class=4 if SELFEMP==1 & SE_OCC92>=299 & SE_OCC92<=321 replace SE92_class=4 if SELFEMP==1 & SE_OCC92>=332 & SE_OCC92<=339 replace SE92_class=4 if SELFEMP==411 & SE_OCC92>=9 & SE_OCC92<=981 * Technical experts (5) replace SE92_class=5 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=1 & SE_OCC92<=8 replace SE92_class=5 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=15 & SE_OCC92<=22 replace SE92_class=5 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==101 replace SE92_class=5 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==251 replace SE92_class=5 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==252 * Technicians (6) replace SE92_class=6 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=9 & SE_OCC92<=13 replace SE92_class=6 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==74 replace SE92_class=6 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==105 replace SE92_class=6 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==162 replace SE92_class=6 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==231 replace SE92_class=6 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==621 * Skilled manual (7) replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==412 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==441 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==611 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==631 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==641 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==652 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==716 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==741 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==744 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==752 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==754 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==755 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==756 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==761 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==764 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==765 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=781 & SE_OCC92<=796 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==801 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==802 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==805 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=819 & SE_OCC92<=829 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==661 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==661 replace SE92_class=7 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==912 * Low-skilled manual (8) replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==411 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==413 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==414 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==664 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==669 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=733 & SE_OCC92<=739 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==749 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==751 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==753 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==759 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==763 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==772 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==777 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==799 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==803 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==809 replace SE92_class=8 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=831 & SE_OCC92<=882 * Higher-grade managers and administrators (9) replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==53 replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==152 replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=201 & SE_OCC92<=203 replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=212 & SE_OCC92<=222 replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==232 replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==261 replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==299 replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==311 replace SE92_class=9 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==404 * Lower-grade managers and administrators (10) replace SE92_class=10 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==211 replace SE92_class=10 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==293 replace SE92_class=10 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==294 replace SE92_class=10 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==297 replace SE92_class=10 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==312 replace SE92_class=10 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==313 replace SE92_class=10 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==321 replace SE92_class=10 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==332 ****NB: no good differenciation possible between (9) and (10) fpr manager of "small" entreprises * Skilled clerks (11) replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==241 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==242 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==249 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==291 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==292 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==295 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==296 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==671 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==673 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==681 replace SE92_class=11 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==904 * Unskilled clerks (12) replace SE92_class=12 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==674 * Socio-cultural professionals (13) replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=30 & SE_OCC92<=32 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==34 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==35 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==37 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==41 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==61 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==103 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==104 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=106 & SE_OCC92<=121 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==131 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==153 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==155 replace SE92_class=13 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==191 * Socio-cultural semi-professionals (14) replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==33 replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==36 replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==39 replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==49 replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==71 replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=76 & SE_OCC92<=79 replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==151 replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==159 replace SE92_class=14 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==169 * Skilled service (15) replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==123 replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==139 replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==333 replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==339 replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==640 replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==642 replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=901 & SE_OCC92<=903 replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==911 replace SE92_class=15 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==941 * Low-skilled service (16) replace SE92_class=16 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==154 replace SE92_class=16 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92==682 replace SE92_class=16 if (SELFEMP==2 | SELFEMP==.a) & SE_OCC92>=913 & SE_OCC92<=932 * Not classifiable (0): military + "other occupation" replace SE92_class=0 if SE_OCC92==981 replace SE92_class=. if SE_OCC92==.i tab SE92_class if COUNTRY==752 & YEAR==1992, m ************************************************* * Create Oesch class schema for partner * Create SE92_pclass * Using SE_SOC92 and SPSELFEM ************************************************* gen SE92_pclass=. * Large employers (1) replace SE92_pclass=1 if SPSELFEM==1 & SE_SOC92==221 replace SE92_pclass=1 if SPSELFEM==1 & SE_SOC92==232 ****NB: no good differenciation possible between (1) and (3) * Self-employed professionals (2) replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92>=1 & SE_SOC92<=8 replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92>=15 & SE_SOC92<=71 replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92>=76 & SE_SOC92<=104 replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92>=106 & SE_SOC92<=131 replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92==155 replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92==191 replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92==219 replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92==229 replace SE92_pclass=2 if SPSELFEM==1 & SE_SOC92>=251 & SE_SOC92<=261 * Small business owners with employees (3) replace SE92_pclass=3 if SPSELFEM==1 & SE_SOC92==152 replace SE92_pclass=3 if SPSELFEM==1 & SE_SOC92>=201 & SE_SOC92<=212 replace SE92_pclass=3 if SPSELFEM==1 & SE_SOC92==297 replace SE92_pclass=3 if SE_SOC92==331 replace SE92_pclass=3 if SE_SOC92==400 replace SE92_pclass=3 if SPSELFEM==1 & SE_SOC92==404 * Small business owners without employees (4) replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92>=9 & SE_SOC92<=13 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==73 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==74 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==105 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==139 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==151 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==154 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92>=159 & SE_SOC92<=169 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==192 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==199 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==239 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92>=241 & SE_SOC92<=249 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==259 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92>=291 & SE_SOC92<=296 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92>=299 & SE_SOC92<=321 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92>=332 & SE_SOC92<=339 replace SE92_pclass=4 if SPSELFEM==1 & SE_SOC92==401 replace SE92_pclass=4 if SPSELFEM==411 & SE_SOC92>=411 & SE_SOC92<=981 * Technical experts (5) replace SE92_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=1 & SE_SOC92<=8 replace SE92_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=15 & SE_SOC92<=22 replace SE92_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==101 replace SE92_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==251 replace SE92_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==252 * Technicians (6) replace SE92_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=9 & SE_SOC92<=13 replace SE92_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==74 replace SE92_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==105 replace SE92_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==162 replace SE92_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==231 replace SE92_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==259 replace SE92_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==621 * Skilled manual (7) replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==401 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==412 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==441 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==501 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==509 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==611 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==631 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==641 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==652 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==716 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==741 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==744 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==752 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==754 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==755 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==756 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==761 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==764 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==765 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=781 & SE_SOC92<=796 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==801 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==802 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==805 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=819 & SE_SOC92<=829 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==661 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==661 replace SE92_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==912 * Low-skilled manual (8) replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==411 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==413 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==414 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==664 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==669 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=733 & SE_SOC92<=739 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==749 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==751 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==753 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==759 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==763 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==772 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==777 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==799 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==803 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==809 replace SE92_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=831 & SE_SOC92<=882 * Higher-grade managers and administrators (9) replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==53 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==102 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==152 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=201 & SE_SOC92<=203 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=212 & SE_SOC92<=222 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==229 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==232 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==261 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==299 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==311 replace SE92_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==404 * Lower-grade managers and administrators (10) replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==211 replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==293 replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==294 replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==297 replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==312 replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==313 replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==319 replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==321 replace SE92_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==332 ****NB: no good differenciation possible between (9) and (10) fpr manager of "small" entreprises * Skilled clerks (11) replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==239 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==241 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==242 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==249 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==291 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==292 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==295 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==296 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==671 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==673 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==681 replace SE92_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==904 * Unskilled clerks (12) replace SE92_pclass=12 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==674 * Socio-cultural professionals (13) replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=30 & SE_SOC92<=32 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==34 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==35 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==37 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==41 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==61 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==63 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==91 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==103 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==104 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=106 & SE_SOC92<=121 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==131 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==153 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==155 replace SE92_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==191 * Socio-cultural semi-professionals (14) replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==33 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==36 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==39 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==49 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==71 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==73 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=76 & SE_SOC92<=79 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==151 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==159 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==169 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==192 replace SE92_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==199 * Skilled service (15) replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==123 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==139 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==333 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==339 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==640 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==642 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=901 & SE_SOC92<=903 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==909 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==911 replace SE92_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==941 * Low-skilled service (16) replace SE92_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==154 replace SE92_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==643 replace SE92_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92==682 replace SE92_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & SE_SOC92>=913 & SE_SOC92<=932 * Not classifiable (0): military + "other occupation" replace SE92_pclass=0 if SE_SOC92==981 replace SE92_pclass=. if SE_SOC92==.i replace SE92_pclass=. if SE_SOC92==.w tab SE92_pclass if COUNTRY==752 & YEAR==1992, m ********************************************************* * Recode class16_r, class16_p, class8_r, class8_p, class5_r, class5_p * Recode class16, class8, class5 * for Sweden 1992 ********************************************************* replace class16_r=SE92_class if COUNTRY==752 & YEAR==1992 replace class16_r=. if SE92_class==0 & COUNTRY==752 & YEAR==1992 replace class16_p=SE92_pclass if COUNTRY==752 & YEAR==1992 replace class16_p=. if SE92_pclass==0 & COUNTRY==752 & YEAR==1992 recode class16_r (0=.) recode class16_p (0=.) replace class8_r=class16_r if COUNTRY==752 & YEAR==1992 recode class8_r (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==752 & YEAR==1992 replace class8_p=class16_p if COUNTRY==752 & YEAR==1992 recode class8_p (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==752 & YEAR==1992 replace class5_r=class16_r if COUNTRY==752 & YEAR==1992 recode class5_r (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==752 & YEAR==1992 replace class5_p=class16_p if COUNTRY==752 & YEAR==1992 recode class5_p (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==752 & YEAR==1992 replace class16=class16_r if COUNTRY==752 & YEAR==1992 replace class16=class16_p if class16_r==. & COUNTRY==752 & YEAR==1992 replace class8=class16 if COUNTRY==752 & YEAR==1992 recode class8 (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==752 & YEAR==1992 replace class5=class16 if COUNTRY==752 & YEAR==1992 recode class5 (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==752 & YEAR==1992 ******************************************************************************* * SPECIFIC Oesch’s class schema for United States 1987 ******************************************************************************* ************************************************* * Create Oesch class schema for respondent * Create US87_class * Using US_OCC87 and SELFEMP ************************************************* gen US87_class=. * Large employers (1) replace US87_class=1 if SELFEMP==1 & US_OCC87>=202 & US_OCC87<=224 replace US87_class=1 if SELFEMP==1 & US_OCC87>=231 & US_OCC87<=233 ****NB: no good differenciation possible between (1) and (3) * Self-employed professionals (2) replace US87_class=2 if SELFEMP==1 & US_OCC87>=1 & US_OCC87<=65 replace US87_class=2 if SELFEMP==1 & US_OCC87>=91 & US_OCC87<=152 replace US87_class=2 if SELFEMP==1 & US_OCC87>=174 & US_OCC87<=201 replace US87_class=2 if SELFEMP==1 & US_OCC87>=240 & US_OCC87<=245 * Small business owners with employees (3) replace US87_class=3 if SELFEMP==1 & US_OCC87==230 replace US87_class=3 if SELFEMP==1 & US_OCC87==801 * Small business owners without employees (4) replace US87_class=4 if SELFEMP==1 & US_OCC87>=74 & US_OCC87<=90 replace US87_class=4 if SELFEMP==1 & US_OCC87>=153 & US_OCC87<=173 replace US87_class=4 if SELFEMP==1 & US_OCC87==225 replace US87_class=4 if SELFEMP==1 & US_OCC87>=260 & US_OCC87<=563 replace US87_class=4 if SELFEMP==1 & US_OCC87>=601 & US_OCC87<=785 replace US87_class=4 if SELFEMP==1 & US_OCC87>=822 & US_OCC87<=984 * Technical experts (5) replace US87_class=5 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=1 & US_OCC87<=25 * Technicians (6) replace US87_class=6 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=153 & US_OCC87<=173 replace US87_class=6 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==450 replace US87_class=6 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==452 replace US87_class=6 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==610 * Skilled manual (7) replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=402 & US_OCC87<=446 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=454 & US_OCC87<=563 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=613 & US_OCC87<=620 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==624 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==645 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==663 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=671 & US_OCC87<=680 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==740 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==752 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==755 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==761 replace US87_class=7 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==763 * Low-skilled manual (8) replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=601 & US_OCC87<=612 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=622 & US_OCC87<=623 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=630 & US_OCC87<=643 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=650 & US_OCC87<=656 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==664 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=690 & US_OCC87<=695 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==706 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==715 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==751 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==753 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==760 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==762 replace US87_class=8 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=764 & US_OCC87<=823 * Higher-grade managers and administrators (9) replace US87_class=9 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==30 replace US87_class=9 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==31 replace US87_class=9 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==91 replace US87_class=9 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=201 & US_OCC87<=224 replace US87_class=9 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=230 & US_OCC87<=233 replace US87_class=9 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==245 * Lower-grade managers and administrators (10) replace US87_class=10 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==225 replace US87_class=10 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==240 replace US87_class=10 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=265 & US_OCC87<=271 replace US87_class=10 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==305 replace US87_class=10 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==964 replace US87_class=10 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==965 * Skilled clerks (11) replace US87_class=11 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==301 replace US87_class=11 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=310 & US_OCC87<=314 replace US87_class=11 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=320 & US_OCC87<=381 replace US87_class=11 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=391 & US_OCC87<=395 * Unskilled clerks (12) replace US87_class=12 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==315 replace US87_class=12 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=384 & US_OCC87<=390 * Socio-cultural professionals (13) replace US87_class=13 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=32 & US_OCC87<=65 replace US87_class=13 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==93 replace US87_class=13 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=110 & US_OCC87<=141 replace US87_class=13 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=144 & US_OCC87<=152 replace US87_class=13 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==174 replace US87_class=13 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==181 replace US87_class=13 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==184 * Socio-cultural semi-professionals (14) replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=74 & US_OCC87<=90 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==100 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==142 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==143 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==175 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==183 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=185 & US_OCC87<=195 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==382 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==922 replace US87_class=14 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==924 * Skilled service (15) replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==226 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==260 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==262 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==280 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==640 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==703 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==912 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==921 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=925 & US_OCC87<=933 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==935 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==942 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==944 replace US87_class=15 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=960 & US_OCC87<=962 * Low-skilled service (16) replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==264 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==705 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==705 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==714 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=901 & US_OCC87<=911 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=913 & US_OCC87<=916 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==934 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==940 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==950 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87==952 replace US87_class=16 if (SELFEMP==2 | SELFEMP==.a) & US_OCC87>=980 & US_OCC87<=984 * Not classifiable (0): military + "other occupation" replace US87_class=0 if US_OCC87==580 replace US87_class=0 if US_OCC87==590 replace US87_class=. if US_OCC87==.a replace US87_class=. if US_OCC87==.c replace US87_class=. if US_OCC87==.n tab US87_class if COUNTRY==840 & YEAR==1987, m ************************************************* * Create Oesch class schema for partner * Create US87_pclass * Using US_SOC87 and SPSELFEM ************************************************* gen US87_pclass=. * Large employers (1) replace US87_pclass=1 if SPSELFEM==1 & US_SOC87>=202 & US_SOC87<=224 replace US87_pclass=1 if SPSELFEM==1 & US_SOC87>=231 & US_SOC87<=233 ****NB: no good differenciation possible between (1) and (3) * Self-employed professionals (2) replace US87_pclass=2 if SPSELFEM==1 & US_SOC87>=1 & US_SOC87<=65 replace US87_pclass=2 if SPSELFEM==1 & US_SOC87>=91 & US_SOC87<=152 replace US87_pclass=2 if SPSELFEM==1 & US_SOC87>=174 & US_SOC87<=201 replace US87_pclass=2 if SPSELFEM==1 & US_SOC87>=240 & US_SOC87<=245 * Small business owners with employees (3) replace US87_pclass=3 if SPSELFEM==1 & US_SOC87==230 replace US87_pclass=3 if SPSELFEM==1 & US_SOC87==801 * Small business owners without employees (4) replace US87_pclass=4 if SPSELFEM==1 & US_SOC87>=74 & US_SOC87<=90 replace US87_pclass=4 if SPSELFEM==1 & US_SOC87>=153 & US_SOC87<=173 replace US87_pclass=4 if SPSELFEM==1 & US_SOC87==225 replace US87_pclass=4 if SPSELFEM==1 & US_SOC87>=260 & US_SOC87<=563 replace US87_pclass=4 if SPSELFEM==1 & US_SOC87>=260 & US_SOC87<=575 replace US87_pclass=4 if SPSELFEM==1 & US_SOC87>=601 & US_SOC87<=785 replace US87_pclass=4 if SPSELFEM==1 & US_SOC87>=822 & US_SOC87<=984 * Technical experts (5) replace US87_pclass=5 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=1 & US_SOC87<=25 * Technicians (6) replace US87_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=153 & US_SOC87<=173 replace US87_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==450 replace US87_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==452 replace US87_pclass=6 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==610 * Skilled manual (7) replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=402 & US_SOC87<=446 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=453 & US_SOC87<=563 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==575 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=613 & US_SOC87<=620 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==624 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==645 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==663 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=671 & US_SOC87<=680 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==740 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==752 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==755 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==761 replace US87_pclass=7 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==763 * Low-skilled manual (8) replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=601 & US_SOC87<=612 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=622 & US_SOC87<=623 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=630 & US_SOC87<=643 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=650 & US_SOC87<=656 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==681 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==664 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=690 & US_SOC87<=695 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==706 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==715 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==751 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==753 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==760 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==762 replace US87_pclass=8 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=764 & US_SOC87<=823 * Higher-grade managers and administrators (9) replace US87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==30 replace US87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==31 replace US87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==91 replace US87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=201 & US_SOC87<=224 replace US87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=230 & US_SOC87<=233 replace US87_pclass=9 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==245 * Lower-grade managers and administrators (10) replace US87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==225 replace US87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==240 replace US87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=265 & US_SOC87<=271 replace US87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==305 replace US87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==964 replace US87_pclass=10 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==965 * Skilled clerks (11) replace US87_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==301 replace US87_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=310 & US_SOC87<=314 replace US87_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=320 & US_SOC87<=381 replace US87_pclass=11 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=391 & US_SOC87<=395 * Unskilled clerks (12) replace US87_pclass=12 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==315 replace US87_pclass=12 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=384 & US_SOC87<=390 * Socio-cultural professionals (13) replace US87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=32 & US_SOC87<=65 replace US87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==93 replace US87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=110 & US_SOC87<=141 replace US87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=144 & US_SOC87<=152 replace US87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==174 replace US87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==181 replace US87_pclass=13 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==184 * Socio-cultural semi-professionals (14) replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=74 & US_SOC87<=90 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==100 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==101 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==142 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==143 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==175 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==183 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=185 & US_SOC87<=195 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==382 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==922 replace US87_pclass=14 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==924 * Skilled service (15) replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==226 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==260 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==262 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==280 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==640 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==703 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==912 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==921 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=925 & US_SOC87<=933 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==935 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==942 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==944 replace US87_pclass=15 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=960 & US_SOC87<=962 * Low-skilled service (16) replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==264 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==705 replace US87_pclass=16 if US_SOC87==711 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==714 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=901 & US_SOC87<=911 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=913 & US_SOC87<=916 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==934 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==940 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==950 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87==952 replace US87_pclass=16 if (SPSELFEM==2 | SPSELFEM==.a) & US_SOC87>=980 & US_SOC87<=984 * Not classifiable (0): military + "other occupation" replace US87_pclass=0 if US_SOC87==580 replace US87_pclass=0 if US_SOC87==590 replace US87_pclass=. if US_SOC87==.a replace US87_pclass=. if US_SOC87==.c replace US87_pclass=. if US_SOC87==.n tab US87_pclass if COUNTRY==840 & YEAR==1987, m ********************************************************* * Recode class16_r, class16_p, class8_r, class8_p, class5_r, class5_p * Recode class16, class8, class5 * for United States 1987 ********************************************************* replace class16_r=US87_class if COUNTRY==840 & YEAR==1987 replace class16_p=US87_pclass if COUNTRY==840 & YEAR==1987 recode class16_r (0=.) recode class16_p (0=.) replace class8_r=class16_r if COUNTRY==840 & YEAR==1987 recode class8_r (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==840 & YEAR==1987 replace class8_p=class16_p if COUNTRY==840 & YEAR==1987 recode class8_p (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==840 & YEAR==1987 replace class5_r=class16_r if COUNTRY==840 & YEAR==1987 recode class5_r (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==840 & YEAR==1987 replace class5_p=class16_p if COUNTRY==840 & YEAR==1987 recode class5_p (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==840 & YEAR==1987 replace class16=class16_r if COUNTRY==840 & YEAR==1987 replace class16=class16_p if class16_r==. & COUNTRY==840 & YEAR==1987 replace class8=class16 if COUNTRY==840 & YEAR==1987 recode class8 (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 14=7)(15 16=8) if COUNTRY==840 & YEAR==1987 replace class5=class16 if COUNTRY==840 & YEAR==1987 recode class5 (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 16=5) if COUNTRY==840 & YEAR==1987 ******************************************************************************* * SPECIFIC Oesch’s class schema for Poland 1987 * NB: Only 5-Class schema can be created + there is no partner information * Recode class5 * Using PL_OCC87 ******************************************************************************* replace class5=1 if (PL_OCC87==1 | PL_OCC87==2) & COUNTRY==616 & YEAR==1987 replace class5=2 if (PL_OCC87==3) & COUNTRY==616 & YEAR==1987 replace class5=3 if (PL_OCC87==6 | PL_OCC87==11) & COUNTRY==616 & YEAR==1987 replace class5=4 if (PL_OCC87==4 | PL_OCC87==5| PL_OCC87==7 |PL_OCC87==8) & COUNTRY==616 & YEAR==1987 replace class5=5 if (PL_OCC87==9 | PL_OCC87==10| PL_OCC87==12) & COUNTRY==616 & YEAR==1987 ******************************************************************************* * SPECIFIC Oesch’s class schema for ITALY 1987 * NB: Due to the lack of information, only 8-Class schema and 5-Class schema can be created ******************************************************************************* ************************************************* * Create Oesch 8-Class schema for respondent * Create IT87_class8 * Using IT_OCC87 and SELFEMP ************************************************* gen IT87_class8=. replace IT87_class8=1 if (IT_OCC87==11 | IT_OCC87==12 | IT_OCC87==14) & SELFEMP==1 replace IT87_class8=2 if (IT_OCC87==44 | IT_OCC87==43 | IT_OCC87==46) & SELFEMP==1 *NB1: an accurate distiction between big business holder (IT87_class8=1) and small business holder (IT87_class8=2) is not possible: all "Entrepreneurs, manufacturers" have been assigned to IT87_class8==1. *NB2: No tecnical experts or tecnicians (IT87_class8=3) can be identified replace IT87_class8=4 if (IT_OCC87==31 | IT_OCC87==34 | IT_OCC87==43) & (SELFEMP==2 | SELFEMP==.) replace IT87_class8=5 if (IT_OCC87==21 | IT_OCC87==24 | IT_OCC87==25 | IT_OCC87==42 | IT_OCC87==46) & (SELFEMP==2 | SELFEMP==.) replace IT87_class8=6 if IT_OCC87==26 & (SELFEMP==2 | SELFEMP==.) replace IT87_class8=7 if (IT_OCC87==13 | IT_OCC87==22 | IT_OCC87==23) & (SELFEMP==2 | SELFEMP==.) replace IT87_class8=8 if (IT_OCC87==33 | IT_OCC87==41 | IT_OCC87==45) & (SELFEMP==2 | SELFEMP==.) replace IT87_class8=. if IT_OCC87==32 ************************************************* * Create Oesch 5-Class schema for respondent * Create IT87_class5 * Using IT_OCC87 and SELFEMP ************************************************* gen IT87_class5=. replace IT87_class5=1 if (IT_OCC87==11 | IT_OCC87==12 | IT_OCC87==14) & SELFEMP==1 *NB1: no accurate distiction between big business holder (IT87_class5=1) and small business holder (IT87_class5=3) is possible: all "Entrepreneurs, manufacturers" have been assigned to IT87_class5==1. replace IT87_class5=1 if (IT_OCC87==21 | IT_OCC87==22 | IT_OCC87==23) & (SELFEMP==2 | SELFEMP==.) replace IT87_class5=2 if (IT_OCC87==13 | IT_OCC87==24 |IT_OCC87==25| IT_OCC87==26 | IT_OCC87==42 | IT_OCC87==46) & (SELFEMP==2 | SELFEMP==.) *NB2: No tecnical experts (IT87_class5=1) or tecnicians (IT87_class5=2) can be identified accordig to the disposable categories in IT_OCC87 replace IT87_class5=3 if (IT_OCC87==43 | IT_OCC87==44 |IT_OCC87==46) & (SELFEMP==1) replace IT87_class5=4 if (IT_OCC87==41) & (SELFEMP==2 | SELFEMP==.) replace IT87_class5=5 if (IT_OCC87==31 | IT_OCC87==33| IT_OCC87==34 | IT_OCC87==45) & (SELFEMP==2 | SELFEMP==.) *NB: no accurate distiction between skilled workers (IT87_class5=4) and unskilled (IT87_class5=5) workers is possible: all "Workers, operatives or similar" has been assigned to IT87_class5=5. ************************************************* * Create Oesch 8-Class schema for partner * Create IT87_pclass8 * Using IT_SOC87 and SPSELFEM ************************************************* gen IT87_pclass8=. replace IT87_pclass8=1 if (IT_SOC87==11 | IT_SOC87==12 | IT_SOC87==14) & SPSELFEM==1 replace IT87_pclass8=2 if (IT_SOC87==44 | IT_SOC87==43 | IT_OCC87==46) & SELFEMP==1 *NB1: no accurate distiction is possible between big business holder (IT87_pclass8=1) and small business holder (IT87_pclass8=2) *NB2: No tecnical experts or tecnicians (IT87_pclass8=3) can be identified replace IT87_pclass8=4 if (IT_SOC87==31 | IT_SOC87==34 | IT_SOC87==43) & (SELFEMP==2 | SELFEMP==.) replace IT87_pclass8=5 if (IT_SOC87==21 | IT_SOC87==24 | IT_SOC87==25 | IT_SOC87==42 | IT_SOC87==46) & (SELFEMP==2 | SELFEMP==.) replace IT87_pclass8=6 if IT_SOC87==26 & (SELFEMP==2 | SELFEMP==.) replace IT87_pclass8=7 if (IT_SOC87==13 | IT_SOC87==22 | IT_SOC87==23) & (SELFEMP==2 | SELFEMP==.) replace IT87_pclass8=8 if (IT_SOC87==33 | IT_SOC87==41 | IT_SOC87==45) & (SELFEMP==2 | SELFEMP==.) replace IT87_pclass8=. if IT_SOC87==32 ************************************************* * Create Oesch 5-Class schema for partner * Create IT87_pclass5 * Using IT_SOC87 and SPSELFEM ************************************************* gen IT87_pclass5=. replace IT87_pclass5=1 if (IT_SOC87==11 | IT_SOC87==12 | IT_SOC87==14) & SPSELFEM==1 *NB1: no accurate distiction is possible between big business holder (IT87_pclass5=1) and small business holder (IT87_pclass5=3): all "Entrepreneurs, manufacturers" have been assigned to IT87_pclass5==1. replace IT87_pclass5=1 if (IT_SOC87==21 | IT_SOC87==22 | IT_SOC87==23) & (SPSELFEM==2 | SPSELFEM==.) replace IT87_pclass5=2 if (IT_SOC87==13 | IT_SOC87==24 |IT_SOC87==25| IT_SOC87==26 | IT_SOC87==42 | IT_SOC87==46) & (SPSELFEM==2 | SPSELFEM==.) *NB2: No tecnical experts (IT87_class5=1) or tecnicians (IT87_class5=2) can be identified accordig to the disposable categories in IT_OCC87 replace IT87_pclass5=3 if (IT_SOC87==43 | IT_SOC87==44 |IT_SOC87==46) & (SPSELFEM==1) replace IT87_pclass5=4 if (IT_SOC87==41) & (SPSELFEM==2 | SPSELFEM==.) replace IT87_pclass5=5 if (IT_SOC87==31 | IT_SOC87==33| IT_SOC87==34 | IT_SOC87==45) & (SPSELFEM==2 | SPSELFEM==.) *NB: no accurate distiction between skilled workers (IT87_pclass5=4) and unskilled (IT87_pclass5=5) workers is possible: all "Workers, operatives or similar" has been assigned to IT87_pclass5=5. ************************************************* *recode class8 and class5 for Italy 1987 *using IT87_class8, IT87_class5, IT87_pclass8 and IT87_pclass5 ************************************************* replace class8_r=IT87_class8 if COUNTRY==380 & YEAR==1987 replace class8_p=IT87_pclass8 if COUNTRY==380 & YEAR==1987 replace class8=IT87_class8 if COUNTRY==380 & YEAR==1987 replace class8=IT87_pclass8 if IT87_class8==. & COUNTRY==380 & YEAR==1987 replace class5_r=IT87_class5 if COUNTRY==380 & YEAR==1987 replace class5_p=IT87_pclass5 if COUNTRY==380 & YEAR==1987 replace class5=IT87_class5 if COUNTRY==380 & YEAR==1987 replace class5=IT87_pclass5 if IT87_class5==. & COUNTRY==380 & YEAR==1987 ******************************************************************************* * SPECIFIC Oesch’s class schema for ITALY 1992 * NB: Due to the lack of information, only 8-Class schema and 5-Class schema can be created ******************************************************************************* ************************************************* * Create Oesch 8-Class schema for respondent * Create IT92_class8 * Using IT_OCC92 and SELFEMP ************************************************* gen IT92_class8=. replace IT92_class8=1 if (IT_OCC92==1 | IT_OCC92==2 | IT_OCC92==4) & SELFEMP==1 replace IT92_class8=2 if (IT_OCC92==19 | IT_OCC92==18 | IT_OCC92==21) & SELFEMP==1 *NB1: no accurate distiction is possible between big business holder (IT92_class8=1) and small business holder (IT92_class8=2): all "Entrepreneurs, manufacturers" have been assigned to IT92_class8==1. *NB2: No tecnical experts or tecnicians (IT92_class8=3) can be identified replace IT92_class8=4 if (IT_OCC92==12 | IT_OCC92==15 | IT_OCC92==18) & (SELFEMP==2 | SELFEMP==.) replace IT92_class8=5 if (IT_OCC92==16 | IT_OCC92==8 | IT_OCC92==9 | IT_OCC92==17 | IT_OCC92==21) & (SELFEMP==2 | SELFEMP==.) replace IT92_class8=6 if IT_OCC92==10 & (SELFEMP==2 | SELFEMP==.) replace IT92_class8=7 if (IT_OCC92==3 | IT_OCC92==6 | IT_OCC92==7) & (SELFEMP==2 | SELFEMP==.) replace IT92_class8=8 if (IT_OCC92==14 | IT_OCC92==16 | IT_OCC92==20 | IT_OCC92==22) & (SELFEMP==2 | SELFEMP==.) replace IT92_class8=. if IT_OCC92==32 ************************************************* * Create Oesch 5-Class schema for respondent * Create IT92_class5 * Using IT_OCC92 and SELFEMP ************************************************* gen IT92_class5=. replace IT92_class5=1 if (IT_OCC92==1 | IT_OCC92==2 | IT_OCC92==4) & SELFEMP==1 *NB1: no accurate distiction is possible between big business holder (IT92_class5=1) and small business holder (IT92_class5=3): all "Entrepreneurs, manufacturers" have been assigned to IT92_class5==1. replace IT92_class5=1 if (IT_OCC92==5 | IT_OCC92==6 | IT_OCC92==7) & (SELFEMP==2 | SELFEMP==.) replace IT92_class5=2 if (IT_OCC92==3 | IT_OCC92==8 |IT_OCC92==9| IT_OCC92==10 | IT_OCC92==17 | IT_OCC92==21) & (SELFEMP==2 | SELFEMP==.) *NB2: No tecnical experts (IT92_class5=1) or tecnicians (IT92_class5=2) can be identified accordig to the disposable categories in IT_OCC92 replace IT92_class5=3 if (IT_OCC92==18 | IT_OCC92==19 |IT_OCC92==21) & (SELFEMP==1) replace IT92_class5=4 if (IT_OCC92==16) & (SELFEMP==2 | SELFEMP==.) replace IT92_class5=5 if (IT_OCC92==12 | IT_OCC92==13| IT_OCC92==15 | IT_OCC92==20) & (SELFEMP==2 | SELFEMP==.) *NB: no accurate distiction between skilled workers (IT92_class5=4) and unskilled (IT92_class5=5) workers is possible: all "Workers, operatives or similar" has been assigned to IT92_class5=5. ************************************************* * Create Oesch 8-Class schema for partner * Create IT92_pclass8 * Using IT_SOC92 and SPSELFEM ************************************************* gen IT92_pclass8=. replace IT92_pclass8=1 if (IT_SOC92==1 | IT_SOC92==2 | IT_SOC92==4) & SPSELFEM==1 replace IT92_pclass8=2 if (IT_SOC92==19 | IT_SOC92==18 | IT_SOC92==21) & SPSELFEM==1 *NB1: no accurate distiction is possible between big business holder (IT92_class8=1) and small business holder (IT92_class8=2): all "Entrepreneurs, manufacturers" have been assigned to IT92_class8==1. *NB2: No tecnical experts or tecnicians (IT92_class8=3) can be identified replace IT92_pclass8=4 if (IT_SOC92==12 | IT_SOC92==15 | IT_SOC92==18) & (SPSELFEM==2 | SELFEMP==.) replace IT92_pclass8=5 if (IT_SOC92==16 | IT_SOC92==8 | IT_SOC92==9 | IT_SOC92==17 | IT_SOC92==21) & (SPSELFEM==2 | SPSELFEM==.) replace IT92_pclass8=6 if IT_SOC92==10 & (SPSELFEM==2 | SPSELFEM==.) replace IT92_pclass8=7 if (IT_SOC92==3 | IT_SOC92==6 | IT_SOC92==7) & (SPSELFEM==2 | SPSELFEM==.) replace IT92_pclass8=8 if (IT_OCC92==14 | IT_OCC92==16 | IT_OCC92==20 | IT_OCC92==22) & (SPSELFEM==2 | SPSELFEM==.) replace IT92_pclass8=. if IT_OCC92==32 ************************************************* * Create Oesch 5-Class schema for partner * Create IT92_pclass5 * Using IT_OCC92 and SPSELFEM ************************************************* gen IT92_pclass5=. replace IT92_pclass5=1 if (IT_SOC92==1 | IT_SOC92==2 | IT_SOC92==4) & SPSELFEM==1 *NB1: no accurate distiction is possible between big business holder (IT92_class5=1) and small business holder (IT92_class5=3): all "Entrepreneurs, manufacturers" have been assigned to IT92_class5==1. replace IT92_pclass5=1 if (IT_SOC92==5 | IT_SOC92==6 | IT_SOC92==7) & (SPSELFEM==2 | SPSELFEM==.) replace IT92_pclass5=2 if (IT_SOC92==3 | IT_SOC92==8 |IT_SOC92==9| IT_SOC92==10 | IT_SOC92==17 | IT_SOC92==21) & (SPSELFEM==2 | SPSELFEM==.) *NB2: No tecnical experts (IT92_class5=1) or tecnicians (IT92_class5=2) can be identified accordig to the disposable categories in IT_OCC92 replace IT92_pclass5=3 if (IT_SOC92==18 | IT_SOC92==19 |IT_SOC92==21) & (SPSELFEM==1) replace IT92_pclass5=4 if (IT_SOC92==16) & (SPSELFEM==2 | SPSELFEM==.) replace IT92_pclass5=5 if (IT_SOC92==12 | IT_SOC92==13| IT_SOC92==15 | IT_SOC92==20) & (SPSELFEM==2 | SPSELFEM==.) *NB: no accurate distiction between skilled workers (IT92_class5=4) and unskilled (IT92_class5=5) workers is possible: all "Workers, operatives or similar" has been assigned to IT92_class5=5. ************************************************* *recode class8 and class5 for Italy 1992 *using IT92_class8, IT92_class5, IT92_pclass8 and IT92_pclass5 ************************************************* replace class8_r=IT92_class8 if COUNTRY==380 & YEAR==1992 replace class8_p=IT92_pclass8 if COUNTRY==380 & YEAR==1992 replace class8=IT92_class8 if COUNTRY==380 & YEAR==1992 replace class8=IT92_pclass8 if IT92_class8==. & COUNTRY==380 & YEAR==1992 replace class5_r=IT92_class5 if COUNTRY==380 & YEAR==1992 replace class5_p=IT92_pclass5 if COUNTRY==380 & YEAR==1992 replace class5=IT92_class5 if COUNTRY==380 & YEAR==1992 replace class5=IT92_pclass5 if IT92_class5==. & COUNTRY==360 & YEAR==1992