* From IMRB: Sept 2017. *get data /type=XLSX/file='D:\_WAS reference\India\2017 India\Work, Attitudes & Spending 2017 Data N=2510 19Sept2017.xlsx' /sheet=name 'SOCIETY 2017' /cellrange=range 'A1:HE2511' /readnames=on. get data /type=XLSX/file='D:\_WAS reference\India\2017 India\Work, Attitudes & Spending 2017 Data N=2510 21Sept2017.xlsx' /sheet=name 'SOCIETY 2017' /cellrange=range 'A1:HE2511' /readnames=on. var lab Q3a "Are you the Chief Income Earner in the family?". rename var (INTNR = ID). if (AOLVAR_5="Mumbai") LIVE_cit = 01 . if (AOLVAR_5="Kolkatta") LIVE_cit = 02 . if (AOLVAR_5="Delhi") LIVE_cit = 03 . if (AOLVAR_5="Chennai") LIVE_cit = 04 . if (AOLVAR_5="Ahmedabad") LIVE_cit = 05 . if (AOLVAR_5="Lucknow") LIVE_cit = 06 . if (AOLVAR_5="Kochi") LIVE_cit = 07 . if (AOLVAR_5="Patna") LIVE_cit = 08 . if (AOLVAR_5="Bhubhneshwar") LIVE_cit = 09 . if (AOLVAR_5="Ludhiana") LIVE_cit = 10 . if (AOLVAR_5="Vijayawada") LIVE_cit = 11 . if (DURABLES_1 ="Mentioned") electric = 1. if (DURABLES_1 ="Not mentioned") electric = 0. if (DURABLES_2 ="Mentioned") fan = 1. if (DURABLES_2 ="Not mentioned") fan = 0. if (DURABLES_3 ="Mentioned") cookrLPG = 1. if (DURABLES_3 ="Not mentioned") cookrLPG = 0. if (DURABLES_4 ="Mentioned") motorcyc = 1. if (DURABLES_4 ="Not mentioned") motorcyc = 0. if (DURABLES_5 ="Mentioned") TVcolour = 1. if (DURABLES_5 ="Not mentioned") TVcolour = 0. if (DURABLES_6 ="Mentioned") fridge = 1. if (DURABLES_6 ="Not mentioned") fridge = 0. if (DURABLES_7 ="Mentioned") WashMach = 1. if (DURABLES_7 ="Not mentioned") WashMach = 0. if (DURABLES_8 ="Mentioned") computer = 1. if (DURABLES_8 ="Not mentioned") computer = 0. if (DURABLES_9 ="Mentioned") car = 1. if (DURABLES_9 ="Not mentioned") car = 0. if (DURABLES_10="Mentioned") air_cond = 1. if (DURABLES_10="Not mentioned") air_cond = 0. if ( AgriLand="Yes") farmLand = 1. if ( AgriLand="No") farmLand = 0. * Are these vars helpful?. * (EDU=educ_CWE_string). *freq H_SECOLkUpPos_2 H_SECOLkUpDt_2 H_SECNLkUpPos_2 H_SECNLkUpDt_2 Q3a Q3b Q3c Q3coth NoOfFamilyMem . *freq OCC. if (Q4ii_1 ="Brother/sister") P1_RELAT = 10 . if (Q4ii_1 ="Grandchild") P1_RELAT = -200 . if (Q4ii_1 ="Grandparent") P1_RELAT = 200 . if (Q4ii_1 ="Husband/wife") P1_RELAT = 1 . if (Q4ii_1 ="Other") P1_RELAT = 996 . if (Q4ii_1 ="Parent") P1_RELAT = 100 . if (Q4ii_1 ="related to spouse") P1_RELAT = 997 . if (Q4ii_1 ="Respondent") P1_RELAT = 0 . if (Q4ii_1 ="Son/daughter") P1_RELAT = -100 . if (Q4iii_1 ="Female") P1_SEX = 1. if (Q4iii_1 ="Male") P1_SEX = 0. rename var (Q4iv_1 = P1_AGE). if (Q4v_1 ="College, but not graduate") P1_EDUC = 6. if (Q4v_1 ="Grad/postgraduate-general") P1_EDUC = 7. if (Q4v_1 ="Grad/postgraduate-professional") P1_EDUC = 8. if (Q4v_1 ="Illiterate") P1_EDUC = 1. if (Q4v_1 ="Not disclosed") P1_EDUC = 9. if (Q4v_1 ="School 5-7 years") P1_EDUC = 3. if (Q4v_1 ="School 8-9 years") P1_EDUC = 4. if (Q4v_1 ="School up to 4 years") P1_EDUC = 2. if (Q4v_1 ="SSC/HSC") P1_EDUC = 5. if (Q4vi_1 ="Businessman/industrialist") P1_JOB = 5. if (Q4vi_1 ="Clerical/salesperson") P1_JOB = 7. if (Q4vi_1 ="Housewife: never been employed") P1_JOB = 11. if (Q4vi_1 ="Housewife: used to have a job") P1_JOB = 12. if (Q4vi_1 ="not disclosed") P1_JOB = 16. if (Q4vi_1 ="Officer/exec: mid/senior") P1_JOB = 10. if (Q4vi_1 ="Officer/executive: junior") P1_JOB = 9. if (Q4vi_1 ="Petty trader") P1_JOB = 3. if (Q4vi_1 ="Retired") P1_JOB = 14. if (Q4vi_1 ="Self-employed professional") P1_JOB = 6. if (Q4vi_1 ="Shop owner") P1_JOB = 4. if (Q4vi_1 ="Skilled worker") P1_JOB = 2. if (Q4vi_1 ="Student") P1_JOB = 13. if (Q4vi_1 ="Supervisory level") P1_JOB = 8. if (Q4vi_1 ="Unemployed") P1_JOB = 15. if (Q4vi_1 ="Unskilled worker") P1_JOB = 1. if (Q4ii_2 ="Brother/sister") P2_RELAT = 10 . if (Q4ii_2 ="Grandchild") P2_RELAT = -200 . if (Q4ii_2 ="Grandparent") P2_RELAT = 200 . if (Q4ii_2 ="Husband/wife") P2_RELAT = 1 . if (Q4ii_2 ="Other") P2_RELAT = 996 . if (Q4ii_2 ="Parent") P2_RELAT = 100 . if (Q4ii_2 ="related to spouse") P2_RELAT = 997 . if (Q4ii_2 ="Respondent") P2_RELAT = 0 . if (Q4ii_2 ="Son/daughter") P2_RELAT = -100 . if (Q4iii_2 ="Female") P2_SEX = 1. if (Q4iii_2 ="Male") P2_SEX = 0. rename var (Q4iv_2 = P2_AGE). if (Q4v_2 ="College, but not graduate") P2_EDUC = 6. if (Q4v_2 ="Grad/postgraduate-general") P2_EDUC = 7. if (Q4v_2 ="Grad/postgraduate-professional") P2_EDUC = 8. if (Q4v_2 ="Illiterate") P2_EDUC = 1. if (Q4v_2 ="Not disclosed") P2_EDUC = 9. if (Q4v_2 ="School 5-7 years") P2_EDUC = 3. if (Q4v_2 ="School 8-9 years") P2_EDUC = 4. if (Q4v_2 ="School up to 4 years") P2_EDUC = 2. if (Q4v_2 ="SSC/HSC") P2_EDUC = 5. if (Q4vi_2 ="Businessman/industrialist") P2_JOB = 5. if (Q4vi_2 ="Clerical/salesperson") P2_JOB = 7. if (Q4vi_2 ="Housewife: never been employed") P2_JOB = 11. if (Q4vi_2 ="Housewife: used to have a job") P2_JOB = 12. if (Q4vi_2 ="not disclosed") P2_JOB = 16. if (Q4vi_2 ="Officer/exec: mid/senior") P2_JOB = 10. if (Q4vi_2 ="Officer/executive: junior") P2_JOB = 9. if (Q4vi_2 ="Petty trader") P2_JOB = 3. if (Q4vi_2 ="Retired") P2_JOB = 14. if (Q4vi_2 ="Self-employed professional") P2_JOB = 6. if (Q4vi_2 ="Shop owner") P2_JOB = 4. if (Q4vi_2 ="Skilled worker") P2_JOB = 2. if (Q4vi_2 ="Student") P2_JOB = 13. if (Q4vi_2 ="Supervisory level") P2_JOB = 8. if (Q4vi_2 ="Unemployed") P2_JOB = 15. if (Q4vi_2 ="Unskilled worker") P2_JOB = 1. if (Q4ii_3 ="Brother/sister") P3_RELAT = 10 . if (Q4ii_3 ="Grandchild") P3_RELAT = -200 . if (Q4ii_3 ="Grandparent") P3_RELAT = 200 . if (Q4ii_3 ="Husband/wife") P3_RELAT = 1 . if (Q4ii_3 ="Other") P3_RELAT = 996 . if (Q4ii_3 ="Parent") P3_RELAT = 100 . if (Q4ii_3 ="related to spouse") P3_RELAT = 997 . if (Q4ii_3 ="Respondent") P3_RELAT = 0 . if (Q4ii_3 ="Son/daughter") P3_RELAT = -100 . if (Q4iii_3 ="Female") P3_SEX = 1. if (Q4iii_3 ="Male") P3_SEX = 0. rename var (Q4iv_3 = P3_AGE). if (Q4v_3 ="College, but not graduate") P3_EDUC = 6. if (Q4v_3 ="Grad/postgraduate-general") P3_EDUC = 7. if (Q4v_3 ="Grad/postgraduate-professional") P3_EDUC = 8. if (Q4v_3 ="Illiterate") P3_EDUC = 1. if (Q4v_3 ="Not disclosed") P3_EDUC = 9. if (Q4v_3 ="School 5-7 years") P3_EDUC = 3. if (Q4v_3 ="School 8-9 years") P3_EDUC = 4. if (Q4v_3 ="School up to 4 years") P3_EDUC = 2. if (Q4v_3 ="SSC/HSC") P3_EDUC = 5. if (Q4vi_3 ="Businessman/industrialist") P3_JOB = 5. if (Q4vi_3 ="Clerical/salesperson") P3_JOB = 7. if (Q4vi_3 ="Housewife: never been employed") P3_JOB = 11. if (Q4vi_3 ="Housewife: used to have a job") P3_JOB = 12. if (Q4vi_3 ="not disclosed") P3_JOB = 16. if (Q4vi_3 ="Officer/exec: mid/senior") P3_JOB = 10. if (Q4vi_3 ="Officer/executive: junior") P3_JOB = 9. if (Q4vi_3 ="Petty trader") P3_JOB = 3. if (Q4vi_3 ="Retired") P3_JOB = 14. if (Q4vi_3 ="Self-employed professional") P3_JOB = 6. if (Q4vi_3 ="Shop owner") P3_JOB = 4. if (Q4vi_3 ="Skilled worker") P3_JOB = 2. if (Q4vi_3 ="Student") P3_JOB = 13. if (Q4vi_3 ="Supervisory level") P3_JOB = 8. if (Q4vi_3 ="Unemployed") P3_JOB = 15. if (Q4vi_3 ="Unskilled worker") P3_JOB = 1. if (Q4ii_4 ="Brother/sister") P4_RELAT = 10 . if (Q4ii_4 ="Grandchild") P4_RELAT = -200 . if (Q4ii_4 ="Grandparent") P4_RELAT = 200 . if (Q4ii_4 ="Husband/wife") P4_RELAT = 1 . if (Q4ii_4 ="Other") P4_RELAT = 996 . if (Q4ii_4 ="Parent") P4_RELAT = 100 . if (Q4ii_4 ="related to spouse") P4_RELAT = 997 . if (Q4ii_4 ="Respondent") P4_RELAT = 0 . if (Q4ii_4 ="Son/daughter") P4_RELAT = -100 . if (Q4iii_4 ="Female") P4_SEX = 1. if (Q4iii_4 ="Male") P4_SEX = 0. rename var (Q4iv_4 = P4_AGE). if (Q4v_4 ="College, but not graduate") P4_EDUC = 6. if (Q4v_4 ="Grad/postgraduate-general") P4_EDUC = 7. if (Q4v_4 ="Grad/postgraduate-professional") P4_EDUC = 8. if (Q4v_4 ="Illiterate") P4_EDUC = 1. if (Q4v_4 ="Not disclosed") P4_EDUC = 9. if (Q4v_4 ="School 5-7 years") P4_EDUC = 3. if (Q4v_4 ="School 8-9 years") P4_EDUC = 4. if (Q4v_4 ="School up to 4 years") P4_EDUC = 2. if (Q4v_4 ="SSC/HSC") P4_EDUC = 5. if (Q4vi_4 ="Businessman/industrialist") P4_JOB = 5. if (Q4vi_4 ="Clerical/salesperson") P4_JOB = 7. if (Q4vi_4 ="Housewife: never been employed") P4_JOB = 11. if (Q4vi_4 ="Housewife: used to have a job") P4_JOB = 12. if (Q4vi_4 ="not disclosed") P4_JOB = 16. if (Q4vi_4 ="Officer/exec: mid/senior") P4_JOB = 10. if (Q4vi_4 ="Officer/executive: junior") P4_JOB = 9. if (Q4vi_4 ="Petty trader") P4_JOB = 3. if (Q4vi_4 ="Retired") P4_JOB = 14. if (Q4vi_4 ="Self-employed professional") P4_JOB = 6. if (Q4vi_4 ="Shop owner") P4_JOB = 4. if (Q4vi_4 ="Skilled worker") P4_JOB = 2. if (Q4vi_4 ="Student") P4_JOB = 13. if (Q4vi_4 ="Supervisory level") P4_JOB = 8. if (Q4vi_4 ="Unemployed") P4_JOB = 15. if (Q4vi_4 ="Unskilled worker") P4_JOB = 1. if (Q4ii_5 ="Brother/sister") P5_RELAT = 10 . if (Q4ii_5 ="Grandchild") P5_RELAT = -200 . if (Q4ii_5 ="Grandparent") P5_RELAT = 200 . if (Q4ii_5 ="Husband/wife") P5_RELAT = 1 . if (Q4ii_5 ="Other") P5_RELAT = 996 . if (Q4ii_5 ="Parent") P5_RELAT = 100 . if (Q4ii_5 ="related to spouse") P5_RELAT = 997 . if (Q4ii_5 ="Respondent") P5_RELAT = 0 . if (Q4ii_5 ="Son/daughter") P5_RELAT = -100 . if (Q4iii_5 ="Female") P5_SEX = 1. if (Q4iii_5 ="Male") P5_SEX = 0. rename var (Q4iv_5 = P5_AGE). if (Q4v_5 ="College, but not graduate") P5_EDUC = 6. if (Q4v_5 ="Grad/postgraduate-general") P5_EDUC = 7. if (Q4v_5 ="Grad/postgraduate-professional") P5_EDUC = 8. if (Q4v_5 ="Illiterate") P5_EDUC = 1. if (Q4v_5 ="Not disclosed") P5_EDUC = 9. if (Q4v_5 ="School 5-7 years") P5_EDUC = 3. if (Q4v_5 ="School 8-9 years") P5_EDUC = 4. if (Q4v_5 ="School up to 4 years") P5_EDUC = 2. if (Q4v_5 ="SSC/HSC") P5_EDUC = 5. if (Q4vi_5 ="Businessman/industrialist") P5_JOB = 5. if (Q4vi_5 ="Clerical/salesperson") P5_JOB = 7. if (Q4vi_5 ="Housewife: never been employed") P5_JOB = 11. if (Q4vi_5 ="Housewife: used to have a job") P5_JOB = 12. if (Q4vi_5 ="not disclosed") P5_JOB = 16. if (Q4vi_5 ="Officer/exec: mid/senior") P5_JOB = 10. if (Q4vi_5 ="Officer/executive: junior") P5_JOB = 9. if (Q4vi_5 ="Petty trader") P5_JOB = 3. if (Q4vi_5 ="Retired") P5_JOB = 14. if (Q4vi_5 ="Self-employed professional") P5_JOB = 6. if (Q4vi_5 ="Shop owner") P5_JOB = 4. if (Q4vi_5 ="Skilled worker") P5_JOB = 2. if (Q4vi_5 ="Student") P5_JOB = 13. if (Q4vi_5 ="Supervisory level") P5_JOB = 8. if (Q4vi_5 ="Unemployed") P5_JOB = 15. if (Q4vi_5 ="Unskilled worker") P5_JOB = 1. if (Q4ii_6 ="Brother/sister") P6_RELAT = 10 . if (Q4ii_6 ="Grandchild") P6_RELAT = -200 . if (Q4ii_6 ="Grandparent") P6_RELAT = 200 . if (Q4ii_6 ="Husband/wife") P6_RELAT = 1 . if (Q4ii_6 ="Other") P6_RELAT = 996 . if (Q4ii_6 ="Parent") P6_RELAT = 100 . if (Q4ii_6 ="related to spouse") P6_RELAT = 997 . if (Q4ii_6 ="Respondent") P6_RELAT = 0 . if (Q4ii_6 ="Son/daughter") P6_RELAT = -100 . if (Q4iii_6 ="Female") P6_SEX = 1. if (Q4iii_6 ="Male") P6_SEX = 0. rename var (Q4iv_6 = P6_AGE). if (Q4v_6 ="College, but not graduate") P6_EDUC = 6. if (Q4v_6 ="Grad/postgraduate-general") P6_EDUC = 7. if (Q4v_6 ="Grad/postgraduate-professional") P6_EDUC = 8. if (Q4v_6 ="Illiterate") P6_EDUC = 1. if (Q4v_6 ="Not disclosed") P6_EDUC = 9. if (Q4v_6 ="School 5-7 years") P6_EDUC = 3. if (Q4v_6 ="School 8-9 years") P6_EDUC = 4. if (Q4v_6 ="School up to 4 years") P6_EDUC = 2. if (Q4v_6 ="SSC/HSC") P6_EDUC = 5. if (Q4vi_6 ="Businessman/industrialist") P6_JOB = 5. if (Q4vi_6 ="Clerical/salesperson") P6_JOB = 7. if (Q4vi_6 ="Housewife: never been employed") P6_JOB = 11. if (Q4vi_6 ="Housewife: used to have a job") P6_JOB = 12. if (Q4vi_6 ="not disclosed") P6_JOB = 16. if (Q4vi_6 ="Officer/exec: mid/senior") P6_JOB = 10. if (Q4vi_6 ="Officer/executive: junior") P6_JOB = 9. if (Q4vi_6 ="Petty trader") P6_JOB = 3. if (Q4vi_6 ="Retired") P6_JOB = 14. if (Q4vi_6 ="Self-employed professional") P6_JOB = 6. if (Q4vi_6 ="Shop owner") P6_JOB = 4. if (Q4vi_6 ="Skilled worker") P6_JOB = 2. if (Q4vi_6 ="Student") P6_JOB = 13. if (Q4vi_6 ="Supervisory level") P6_JOB = 8. if (Q4vi_6 ="Unemployed") P6_JOB = 15. if (Q4vi_6 ="Unskilled worker") P6_JOB = 1. if (Q4ii_7 ="Brother/sister") P7_RELAT = 10 . if (Q4ii_7 ="Grandchild") P7_RELAT = -200 . if (Q4ii_7 ="Grandparent") P7_RELAT = 200 . if (Q4ii_7 ="Husband/wife") P7_RELAT = 1 . if (Q4ii_7 ="Other") P7_RELAT = 996 . if (Q4ii_7 ="Parent") P7_RELAT = 100 . if (Q4ii_7 ="related to spouse") P7_RELAT = 997 . if (Q4ii_7 ="Respondent") P7_RELAT = 0 . if (Q4ii_7 ="Son/daughter") P7_RELAT = -100 . if (Q4iii_7 ="Female") P7_SEX = 1. if (Q4iii_7 ="Male") P7_SEX = 0. rename var (Q4iv_7 = P7_AGE). if (Q4v_7 ="College, but not graduate") P7_EDUC = 6. if (Q4v_7 ="Grad/postgraduate-general") P7_EDUC = 7. if (Q4v_7 ="Grad/postgraduate-professional") P7_EDUC = 8. if (Q4v_7 ="Illiterate") P7_EDUC = 1. if (Q4v_7 ="Not disclosed") P7_EDUC = 9. if (Q4v_7 ="School 5-7 years") P7_EDUC = 3. if (Q4v_7 ="School 8-9 years") P7_EDUC = 4. if (Q4v_7 ="School up to 4 years") P7_EDUC = 2. if (Q4v_7 ="SSC/HSC") P7_EDUC = 5. if (Q4vi_7 ="Businessman/industrialist") P7_JOB = 5. if (Q4vi_7 ="Clerical/salesperson") P7_JOB = 7. if (Q4vi_7 ="Housewife: never been employed") P7_JOB = 11. if (Q4vi_7 ="Housewife: used to have a job") P7_JOB = 12. if (Q4vi_7 ="not disclosed") P7_JOB = 16. if (Q4vi_7 ="Officer/exec: mid/senior") P7_JOB = 10. if (Q4vi_7 ="Officer/executive: junior") P7_JOB = 9. if (Q4vi_7 ="Petty trader") P7_JOB = 3. if (Q4vi_7 ="Retired") P7_JOB = 14. if (Q4vi_7 ="Self-employed professional") P7_JOB = 6. if (Q4vi_7 ="Shop owner") P7_JOB = 4. if (Q4vi_7 ="Skilled worker") P7_JOB = 2. if (Q4vi_7 ="Student") P7_JOB = 13. if (Q4vi_7 ="Supervisory level") P7_JOB = 8. if (Q4vi_7 ="Unemployed") P7_JOB = 15. if (Q4vi_7 ="Unskilled worker") P7_JOB = 1. if (Q4ii_8 ="Brother/sister") P8_RELAT = 10 . if (Q4ii_8 ="Grandchild") P8_RELAT = -200 . if (Q4ii_8 ="Grandparent") P8_RELAT = 200 . if (Q4ii_8 ="Husband/wife") P8_RELAT = 1 . if (Q4ii_8 ="Other") P8_RELAT = 996 . if (Q4ii_8 ="Parent") P8_RELAT = 100 . if (Q4ii_8 ="related to spouse") P8_RELAT = 997 . if (Q4ii_8 ="Respondent") P8_RELAT = 0 . if (Q4ii_8 ="Son/daughter") P8_RELAT = -100 . if (Q4iii_8 ="Female") P8_SEX = 1. if (Q4iii_8 ="Male") P8_SEX = 0. rename var (Q4iv_8 = P8_AGE). if (Q4v_8 ="College, but not graduate") P8_EDUC = 6. if (Q4v_8 ="Grad/postgraduate-general") P8_EDUC = 7. if (Q4v_8 ="Grad/postgraduate-professional") P8_EDUC = 8. if (Q4v_8 ="Illiterate") P8_EDUC = 1. if (Q4v_8 ="Not disclosed") P8_EDUC = 9. if (Q4v_8 ="School 5-7 years") P8_EDUC = 3. if (Q4v_8 ="School 8-9 years") P8_EDUC = 4. if (Q4v_8 ="School up to 4 years") P8_EDUC = 2. if (Q4v_8 ="SSC/HSC") P8_EDUC = 5. if (Q4vi_8 ="Businessman/industrialist") P8_JOB = 5. if (Q4vi_8 ="Clerical/salesperson") P8_JOB = 7. if (Q4vi_8 ="Housewife: never been employed") P8_JOB = 11. if (Q4vi_8 ="Housewife: used to have a job") P8_JOB = 12. if (Q4vi_8 ="not disclosed") P8_JOB = 16. if (Q4vi_8 ="Officer/exec: mid/senior") P8_JOB = 10. if (Q4vi_8 ="Officer/executive: junior") P8_JOB = 9. if (Q4vi_8 ="Petty trader") P8_JOB = 3. if (Q4vi_8 ="Retired") P8_JOB = 14. if (Q4vi_8 ="Self-employed professional") P8_JOB = 6. if (Q4vi_8 ="Shop owner") P8_JOB = 4. if (Q4vi_8 ="Skilled worker") P8_JOB = 2. if (Q4vi_8 ="Student") P8_JOB = 13. if (Q4vi_8 ="Supervisory level") P8_JOB = 8. if (Q4vi_8 ="Unemployed") P8_JOB = 15. if (Q4vi_8 ="Unskilled worker") P8_JOB = 1. if (Q4ii_9 ="Brother/sister") P9_RELAT = 10 . if (Q4ii_9 ="Grandchild") P9_RELAT = -200 . if (Q4ii_9 ="Grandparent") P9_RELAT = 200 . if (Q4ii_9 ="Husband/wife") P9_RELAT = 1 . if (Q4ii_9 ="Other") P9_RELAT = 996 . if (Q4ii_9 ="Parent") P9_RELAT = 100 . if (Q4ii_9 ="related to spouse") P9_RELAT = 997 . if (Q4ii_9 ="Respondent") P9_RELAT = 0 . if (Q4ii_9 ="Son/daughter") P9_RELAT = -100 . if (Q4iii_9 ="Female") P9_SEX = 1. if (Q4iii_9 ="Male") P9_SEX = 0. rename var (Q4iv_9 = P9_AGE). if (Q4v_9 ="College, but not graduate") P9_EDUC = 6. if (Q4v_9 ="Grad/postgraduate-general") P9_EDUC = 7. if (Q4v_9 ="Grad/postgraduate-professional") P9_EDUC = 8. if (Q4v_9 ="Illiterate") P9_EDUC = 1. if (Q4v_9 ="Not disclosed") P9_EDUC = 9. if (Q4v_9 ="School 5-7 years") P9_EDUC = 3. if (Q4v_9 ="School 8-9 years") P9_EDUC = 4. if (Q4v_9 ="School up to 4 years") P9_EDUC = 2. if (Q4v_9 ="SSC/HSC") P9_EDUC = 5. if (Q4vi_9 ="Businessman/industrialist") P9_JOB = 5. if (Q4vi_9 ="Clerical/salesperson") P9_JOB = 7. if (Q4vi_9 ="Housewife: never been employed") P9_JOB = 11. if (Q4vi_9 ="Housewife: used to have a job") P9_JOB = 12. if (Q4vi_9 ="not disclosed") P9_JOB = 16. if (Q4vi_9 ="Officer/exec: mid/senior") P9_JOB = 10. if (Q4vi_9 ="Officer/executive: junior") P9_JOB = 9. if (Q4vi_9 ="Petty trader") P9_JOB = 3. if (Q4vi_9 ="Retired") P9_JOB = 14. if (Q4vi_9 ="Self-employed professional") P9_JOB = 6. if (Q4vi_9 ="Shop owner") P9_JOB = 4. if (Q4vi_9 ="Skilled worker") P9_JOB = 2. if (Q4vi_9 ="Student") P9_JOB = 13. if (Q4vi_9 ="Supervisory level") P9_JOB = 8. if (Q4vi_9 ="Unemployed") P9_JOB = 15. if (Q4vi_9 ="Unskilled worker") P9_JOB = 1. if (Q4ii_10 ="Brother/sister") P10RELAT = 10 . if (Q4ii_10 ="Grandchild") P10RELAT = -200 . if (Q4ii_10 ="Grandparent") P10RELAT = 200 . if (Q4ii_10 ="Husband/wife") P10RELAT = 1 . if (Q4ii_10 ="Other") P10RELAT = 996 . if (Q4ii_10 ="Parent") P10RELAT = 100 . if (Q4ii_10 ="related to spouse") P10RELAT = 997 . if (Q4ii_10 ="Respondent") P10RELAT = 0 . if (Q4ii_10 ="Son/daughter") P10RELAT = -100 . if (Q4iii_10 ="Female") P10SEX = 1. if (Q4iii_10 ="Male") P10SEX = 0. rename var (Q4iv_10 = P10AGE). if (Q4v_10 ="College, but not graduate") P10EDUC = 6. if (Q4v_10 ="Grad/postgraduate-general") P10EDUC = 7. if (Q4v_10 ="Grad/postgraduate-professional") P10EDUC = 8. if (Q4v_10 ="Illiterate") P10EDUC = 1. if (Q4v_10 ="Not disclosed") P10EDUC = 9. if (Q4v_10 ="School 5-7 years") P10EDUC = 3. if (Q4v_10 ="School 8-9 years") P10EDUC = 4. if (Q4v_10 ="School up to 4 years") P10EDUC = 2. if (Q4v_10 ="SSC/HSC") P10EDUC = 5. if (Q4vi_10 ="Businessman/industrialist") P10JOB = 5. if (Q4vi_10 ="Clerical/salesperson") P10JOB = 7. if (Q4vi_10 ="Housewife: never been employed") P10JOB = 11. if (Q4vi_10 ="Housewife: used to have a job") P10JOB = 12. if (Q4vi_10 ="not disclosed") P10JOB = 16. if (Q4vi_10 ="Officer/exec: mid/senior") P10JOB = 10. if (Q4vi_10 ="Officer/executive: junior") P10JOB = 9. if (Q4vi_10 ="Petty trader") P10JOB = 3. if (Q4vi_10 ="Retired") P10JOB = 14. if (Q4vi_10 ="Self-employed professional") P10JOB = 6. if (Q4vi_10 ="Shop owner") P10JOB = 4. if (Q4vi_10 ="Skilled worker") P10JOB = 2. if (Q4vi_10 ="Student") P10JOB = 13. if (Q4vi_10 ="Supervisory level") P10JOB = 8. if (Q4vi_10 ="Unemployed") P10JOB = 15. if (Q4vi_10 ="Unskilled worker") P10JOB = 1. if (Q4ii_11 ="Brother/sister") P11RELAT = 10 . if (Q4ii_11 ="Grandchild") P11RELAT = -200 . if (Q4ii_11 ="Grandparent") P11RELAT = 200 . if (Q4ii_11 ="Husband/wife") P11RELAT = 1 . if (Q4ii_11 ="Other") P11RELAT = 996 . if (Q4ii_11 ="Parent") P11RELAT = 100 . if (Q4ii_11 ="related to spouse") P11RELAT = 997 . if (Q4ii_11 ="Respondent") P11RELAT = 0 . if (Q4ii_11 ="Son/daughter") P11RELAT = -100 . if (Q4iii_11 ="Female") P11SEX = 1. if (Q4iii_11 ="Male") P11SEX = 0. rename var (Q4iv_11 = P11AGE). if (Q4v_11 ="College, but not graduate") P11EDUC = 6. if (Q4v_11 ="Grad/postgraduate-general") P11EDUC = 7. if (Q4v_11 ="Grad/postgraduate-professional") P11EDUC = 8. if (Q4v_11 ="Illiterate") P11EDUC = 1. if (Q4v_11 ="Not disclosed") P11EDUC = 9. if (Q4v_11 ="School 5-7 years") P11EDUC = 3. if (Q4v_11 ="School 8-9 years") P11EDUC = 4. if (Q4v_11 ="School up to 4 years") P11EDUC = 2. if (Q4v_11 ="SSC/HSC") P11EDUC = 5. if (Q4vi_11 ="Businessman/industrialist") P11JOB = 5. if (Q4vi_11 ="Clerical/salesperson") P11JOB = 7. if (Q4vi_11 ="Housewife: never been employed") P11JOB = 11. if (Q4vi_11 ="Housewife: used to have a job") P11JOB = 12. if (Q4vi_11 ="not disclosed") P11JOB = 16. if (Q4vi_11 ="Officer/exec: mid/senior") P11JOB = 10. if (Q4vi_11 ="Officer/executive: junior") P11JOB = 9. if (Q4vi_11 ="Petty trader") P11JOB = 3. if (Q4vi_11 ="Retired") P11JOB = 14. if (Q4vi_11 ="Self-employed professional") P11JOB = 6. if (Q4vi_11 ="Shop owner") P11JOB = 4. if (Q4vi_11 ="Skilled worker") P11JOB = 2. if (Q4vi_11 ="Student") P11JOB = 13. if (Q4vi_11 ="Supervisory level") P11JOB = 8. if (Q4vi_11 ="Unemployed") P11JOB = 15. if (Q4vi_11 ="Unskilled worker") P11JOB = 1. if (Q4ii_12 ="Brother/sister") P12RELAT = 10 . if (Q4ii_12 ="Grandchild") P12RELAT = -200 . if (Q4ii_12 ="Grandparent") P12RELAT = 200 . if (Q4ii_12 ="Husband/wife") P12RELAT = 1 . if (Q4ii_12 ="Other") P12RELAT = 996 . if (Q4ii_12 ="Parent") P12RELAT = 100 . if (Q4ii_12 ="related to spouse") P12RELAT = 997 . if (Q4ii_12 ="Respondent") P12RELAT = 0 . if (Q4ii_12 ="Son/daughter") P12RELAT = -100 . if (Q4iii_12 ="Female") P12SEX = 1. if (Q4iii_12 ="Male") P12SEX = 0. rename var (Q4iv_12 = P12AGE). if (Q4v_12 ="College, but not graduate") P12EDUC = 6. if (Q4v_12 ="Grad/postgraduate-general") P12EDUC = 7. if (Q4v_12 ="Grad/postgraduate-professional") P12EDUC = 8. if (Q4v_12 ="Illiterate") P12EDUC = 1. if (Q4v_12 ="Not disclosed") P12EDUC = 9. if (Q4v_12 ="School 5-7 years") P12EDUC = 3. if (Q4v_12 ="School 8-9 years") P12EDUC = 4. if (Q4v_12 ="School up to 4 years") P12EDUC = 2. if (Q4v_12 ="SSC/HSC") P12EDUC = 5. if (Q4vi_12 ="Businessman/industrialist") P12JOB = 5. if (Q4vi_12 ="Clerical/salesperson") P12JOB = 7. if (Q4vi_12 ="Housewife: never been employed") P12JOB = 11. if (Q4vi_12 ="Housewife: used to have a job") P12JOB = 12. if (Q4vi_12 ="not disclosed") P12JOB = 16. if (Q4vi_12 ="Officer/exec: mid/senior") P12JOB = 10. if (Q4vi_12 ="Officer/executive: junior") P12JOB = 9. if (Q4vi_12 ="Petty trader") P12JOB = 3. if (Q4vi_12 ="Retired") P12JOB = 14. if (Q4vi_12 ="Self-employed professional") P12JOB = 6. if (Q4vi_12 ="Shop owner") P12JOB = 4. if (Q4vi_12 ="Skilled worker") P12JOB = 2. if (Q4vi_12 ="Student") P12JOB = 13. if (Q4vi_12 ="Supervisory level") P12JOB = 8. if (Q4vi_12 ="Unemployed") P12JOB = 15. if (Q4vi_12 ="Unskilled worker") P12JOB = 1. if (Q4ii_13 ="Brother/sister") P13RELAT = 10 . if (Q4ii_13 ="Grandchild") P13RELAT = -200 . if (Q4ii_13 ="Grandparent") P13RELAT = 200 . if (Q4ii_13 ="Husband/wife") P13RELAT = 1 . if (Q4ii_13 ="Other") P13RELAT = 996 . if (Q4ii_13 ="Parent") P13RELAT = 100 . if (Q4ii_13 ="related to spouse") P13RELAT = 997 . if (Q4ii_13 ="Respondent") P13RELAT = 0 . if (Q4ii_13 ="Son/daughter") P13RELAT = -100 . if (Q4iii_13 ="Female") P13SEX = 1. if (Q4iii_13 ="Male") P13SEX = 0. rename var (Q4iv_13 = P13AGE). if (Q4v_13 ="College, but not graduate") P13EDUC = 6. if (Q4v_13 ="Grad/postgraduate-general") P13EDUC = 7. if (Q4v_13 ="Grad/postgraduate-professional") P13EDUC = 8. if (Q4v_13 ="Illiterate") P13EDUC = 1. if (Q4v_13 ="Not disclosed") P13EDUC = 9. if (Q4v_13 ="School 5-7 years") P13EDUC = 3. if (Q4v_13 ="School 8-9 years") P13EDUC = 4. if (Q4v_13 ="School up to 4 years") P13EDUC = 2. if (Q4v_13 ="SSC/HSC") P13EDUC = 5. if (Q4vi_13 ="Businessman/industrialist") P13JOB = 5. if (Q4vi_13 ="Clerical/salesperson") P13JOB = 7. if (Q4vi_13 ="Housewife: never been employed") P13JOB = 11. if (Q4vi_13 ="Housewife: used to have a job") P13JOB = 12. if (Q4vi_13 ="not disclosed") P13JOB = 16. if (Q4vi_13 ="Officer/exec: mid/senior") P13JOB = 10. if (Q4vi_13 ="Officer/executive: junior") P13JOB = 9. if (Q4vi_13 ="Petty trader") P13JOB = 3. if (Q4vi_13 ="Retired") P13JOB = 14. if (Q4vi_13 ="Self-employed professional") P13JOB = 6. if (Q4vi_13 ="Shop owner") P13JOB = 4. if (Q4vi_13 ="Skilled worker") P13JOB = 2. if (Q4vi_13 ="Student") P13JOB = 13. if (Q4vi_13 ="Supervisory level") P13JOB = 8. if (Q4vi_13 ="Unemployed") P13JOB = 15. if (Q4vi_13 ="Unskilled worker") P13JOB = 1. *freq Q4ii_14 and Qii_15 etc: All cases are missing. value label P1_sex,P2_sex,P3_sex,P4_sex,P5_sex,P6_sex,P7_sex,P8_sex,P9_sex,P10sex P11sex,P12sex,P13sex 0 'male' 1 'female'. if (p13relat=0) sex = p13sex. if (p12relat=0) sex = p12sex. if (p11relat=0) sex = p11sex. if (p10relat=0) sex = p10sex. if (p9_relat=0) sex = p9_sex. if (p8_relat=0) sex = p8_sex. if (p7_relat=0) sex = p7_sex. if (p6_relat=0) sex = p6_sex. if (p5_relat=0) sex = p5_sex. if (p4_relat=0) sex = p4_sex. if (p3_relat=0) sex = p3_sex. if (p2_relat=0) sex = p2_sex. if (p1_relat=0) sex = p1_sex. var lab sex 'Gender of respondent'. val lab sex 0 'male' 1 'female'. recode sex (sysmis = -9). *freq sex. rename var (Q7_1=paid_hus)(Q7_2 =paid_wif)(Q7_3 =cook_hus)(Q7_4 =cook_wif)(Q7_5 =shop_hus)(Q7_6 =shop_wif)(Q7_7 =laundHus)(Q7_8=laundWif) (Q7_9=clothHus )(Q7_10=clothWif)(Q7_11=cleanHus)(Q7_12=cleanWif)(Q7_13=mind_hus)(Q7_14=mind_wif)(Q7_15=leisuHus)(Q7_16=leisuWif). if (q8a="No income") earn_hus = 0. if (q8a="Not specified / not disclosed") earn_hus = 99. if (q8a="Rs. 501 - 750/-") earn_hus = 2. if (q8a="Rs. 751 - 1000/-") earn_hus = 3. if (q8a="Rs. 1001 - 1500/-") earn_hus = 4. if (q8a="Rs. 1501 - 2000/-") earn_hus = 5. if (q8a="Rs. 2001 - 2500/-") earn_hus = 6. if (q8a="Rs. 2501 - 3000/-") earn_hus = 7. if (q8a="Rs. 3001 - 4000/-") earn_hus = 8. if (q8a="Rs. 4001 - 5000/-") earn_hus = 9. if (q8a="Rs. 5001 - 6000/-") earn_hus = 10. if (q8a="Rs. 6001 - 8000/-") earn_hus = 11. if (q8a="Rs. 8001 - 10000/-") earn_hus = 12. if (q8a="Rs.10001 - 15000/-") earn_hus = 13. if (q8a="Rs.15001 - 20000/-") earn_hus = 14. if (q8a="Rs.20001 - 30000/-") earn_hus = 15. if (q8a="Rs.30001 - 40000/-") earn_hus = 16. if (q8a="Rs.40001 - 50000/-") earn_hus = 17. if (q8a="Rs.50001 and above") earn_hus = 18. if (q8a="up to Rs. 500/-") earn_hus = 1. *. if (q8b="No income") earn_wif = 0. if (q8b="Not specified / not disclosed") earn_wif = 99. if (q8b="Rs. 501 - 750/-") earn_wif = 2. if (q8b="Rs. 751 - 1000/-") earn_wif = 3. if (q8b="Rs. 1001 - 1500/-") earn_wif = 4. if (q8b="Rs. 1501 - 2000/-") earn_wif = 5. if (q8b="Rs. 2001 - 2500/-") earn_wif = 6. if (q8b="Rs. 2501 - 3000/-") earn_wif = 7. if (q8b="Rs. 3001 - 4000/-") earn_wif = 8. if (q8b="Rs. 4001 - 5000/-") earn_wif = 9. if (q8b="Rs. 5001 - 6000/-") earn_wif = 10. if (q8b="Rs. 6001 - 8000/-") earn_wif = 11. if (q8b="Rs. 8001 - 10000/-") earn_wif = 12. if (q8b="Rs.10001 - 15000/-") earn_wif = 13. if (q8b="Rs.15001 - 20000/-") earn_wif = 14. if (q8b="Rs.20001 - 30000/-") earn_wif = 15. if (q8b="Rs.30001 - 40000/-") earn_wif = 16. if (q8b="Rs.40001 - 50000/-") earn_wif = 17. if (q8b="Rs.50001 and above") earn_wif = 18. if (q8b="up to Rs. 500/-") earn_wif = 1. *. if (q8c="No income") HHincome = 0. if (q8c="Not specified / not disclosed") HHincome = 99. if (q8c="Rs. 501 - 750/-") HHincome = 2. if (q8c="Rs. 751 - 1000/-") HHincome = 3. if (q8c="Rs. 1001 - 1500/-") HHincome = 4. if (q8c="Rs. 1501 - 2000/-") HHincome = 5. if (q8c="Rs. 2001 - 2500/-") HHincome = 6. if (q8c="Rs. 2501 - 3000/-") HHincome = 7. if (q8c="Rs. 3001 - 4000/-") HHincome = 8. if (q8c="Rs. 4001 - 5000/-") HHincome = 9. if (q8c="Rs. 5001 - 6000/-") HHincome = 10. if (q8c="Rs. 6001 - 8000/-") HHincome = 11. if (q8c="Rs. 8001 - 10000/-") HHincome = 12. if (q8c="Rs.10001 - 15000/-") HHincome = 13. if (q8c="Rs.15001 - 20000/-") HHincome = 14. if (q8c="Rs.20001 - 30000/-") HHincome = 15. if (q8c="Rs.30001 - 40000/-") HHincome = 16. if (q8c="Rs.40001 - 50000/-") HHincome = 17. if (q8c="Rs.50001 and above") HHincome = 18. if (q8c="up to Rs. 500/-") HHincome = 1. * Try to fill in some of the gaps in sex & relat etc, where 2 people are deiscribed as 'husband/wife' but neither as 'respondent'. * * EDU is education-level of chief wage earner. if (EDU="some college (include diploma) but not graduate" & p1_relat=1 & q4v_1 ="College, but not graduate") match_EDUp1_ = 1. if (EDU="Graduate/ Post Graduate: general" & p1_relat=1 & q4v_1 ="Grad/postgraduate-general") match_EDUp1_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p1_relat=1 & q4v_1 ="Grad/postgraduate-professional") match_EDUp1_ = 1. if (EDU="Illiterate" & p1_relat=1 & q4v_1 ="Illiterate") match_EDUp1_ = 1. if (EDU="School 5 – 9 years" & p1_relat=1 & q4v_1 ="School 5-7 years") match_EDUp1_ = 1. if (EDU="School 5 – 9 years" & p1_relat=1 & q4v_1 ="School 8-9 years") match_EDUp1_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p1_relat=1 & q4v_1 ="School up to 4 years") match_EDUp1_ = 1. if (EDU="SSC/ HSC" & p1_relat=1 & q4v_1 ="SSC/HSC") match_EDUp1_ = 1. if (EDU="some college (include diploma) but not graduate" & p2_relat=1 & q4v_2 ="College, but not graduate") match_EDUp2_ = 1. if (EDU="Graduate/ Post Graduate: general" & p2_relat=1 & q4v_2 ="Grad/postgraduate-general") match_EDUp2_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p2_relat=1 & q4v_2 ="Grad/postgraduate-professional") match_EDUp2_ = 1. if (EDU="Illiterate" & p2_relat=1 & q4v_2 ="Illiterate") match_EDUp2_ = 1. if (EDU="School 5 – 9 years" & p2_relat=1 & q4v_2 ="School 5-7 years") match_EDUp2_ = 1. if (EDU="School 5 – 9 years" & p2_relat=1 & q4v_2 ="School 8-9 years") match_EDUp2_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p2_relat=1 & q4v_2 ="School up to 4 years") match_EDUp2_ = 1. if (EDU="SSC/ HSC" & p2_relat=1 & q4v_2 ="SSC/HSC") match_EDUp2_ = 1. if (EDU="some college (include diploma) but not graduate" & p3_relat=1 & q4v_3 ="College, but not graduate") match_EDUp3_ = 1. if (EDU="Graduate/ Post Graduate: general" & p3_relat=1 & q4v_3 ="Grad/postgraduate-general") match_EDUp3_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p3_relat=1 & q4v_3 ="Grad/postgraduate-professional") match_EDUp3_ = 1. if (EDU="Illiterate" & p3_relat=1 & q4v_3 ="Illiterate") match_EDUp3_ = 1. if (EDU="School 5 – 9 years" & p3_relat=1 & q4v_3 ="School 5-7 years") match_EDUp3_ = 1. if (EDU="School 5 – 9 years" & p3_relat=1 & q4v_3 ="School 8-9 years") match_EDUp3_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p3_relat=1 & q4v_3 ="School up to 4 years") match_EDUp3_ = 1. if (EDU="SSC/ HSC" & p3_relat=1 & q4v_3 ="SSC/HSC") match_EDUp3_ = 1. if (EDU="some college (include diploma) but not graduate" & p4_relat=1 & q4v_4 ="College, but not graduate") match_EDUp4_ = 1. if (EDU="Graduate/ Post Graduate: general" & p4_relat=1 & q4v_4 ="Grad/postgraduate-general") match_EDUp4_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p4_relat=1 & q4v_4 ="Grad/postgraduate-professional") match_EDUp4_ = 1. if (EDU="Illiterate" & p4_relat=1 & q4v_4 ="Illiterate") match_EDUp4_ = 1. if (EDU="School 5 – 9 years" & p4_relat=1 & q4v_4 ="School 5-7 years") match_EDUp4_ = 1. if (EDU="School 5 – 9 years" & p4_relat=1 & q4v_4 ="School 8-9 years") match_EDUp4_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p4_relat=1 & q4v_4 ="School up to 4 years") match_EDUp4_ = 1. if (EDU="SSC/ HSC" & p4_relat=1 & q4v_4 ="SSC/HSC") match_EDUp4_ = 1. if (EDU="some college (include diploma) but not graduate" & p5_relat=1 & q4v_5 ="College, but not graduate") match_EDUp5_ = 1. if (EDU="Graduate/ Post Graduate: general" & p5_relat=1 & q4v_5 ="Grad/postgraduate-general") match_EDUp5_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p5_relat=1 & q4v_5 ="Grad/postgraduate-professional") match_EDUp5_ = 1. if (EDU="Illiterate" & p5_relat=1 & q4v_5 ="Illiterate") match_EDUp5_ = 1. if (EDU="School 5 – 9 years" & p5_relat=1 & q4v_5 ="School 5-7 years") match_EDUp5_ = 1. if (EDU="School 5 – 9 years" & p5_relat=1 & q4v_5 ="School 8-9 years") match_EDUp5_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p5_relat=1 & q4v_5 ="School up to 4 years") match_EDUp5_ = 1. if (EDU="SSC/ HSC" & p5_relat=1 & q4v_5 ="SSC/HSC") match_EDUp5_ = 1. if (EDU="some college (include diploma) but not graduate" & p6_relat=1 & q4v_6 ="College, but not graduate") match_EDUp6_ = 1. if (EDU="Graduate/ Post Graduate: general" & p6_relat=1 & q4v_6 ="Grad/postgraduate-general") match_EDUp6_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p6_relat=1 & q4v_6 ="Grad/postgraduate-professional") match_EDUp6_ = 1. if (EDU="Illiterate" & p6_relat=1 & q4v_6 ="Illiterate") match_EDUp6_ = 1. if (EDU="School 5 – 9 years" & p6_relat=1 & q4v_6 ="School 5-7 years") match_EDUp6_ = 1. if (EDU="School 5 – 9 years" & p6_relat=1 & q4v_6 ="School 8-9 years") match_EDUp6_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p6_relat=1 & q4v_6 ="School up to 4 years") match_EDUp6_ = 1. if (EDU="SSC/ HSC" & p6_relat=1 & q4v_6 ="SSC/HSC") match_EDUp6_ = 1. if (EDU="some college (include diploma) but not graduate" & p7_relat=1 & q4v_7 ="College, but not graduate") match_EDUp7_ = 1. if (EDU="Graduate/ Post Graduate: general" & p7_relat=1 & q4v_7 ="Grad/postgraduate-general") match_EDUp7_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p7_relat=1 & q4v_7 ="Grad/postgraduate-professional") match_EDUp7_ = 1. if (EDU="Illiterate" & p7_relat=1 & q4v_7 ="Illiterate") match_EDUp7_ = 1. if (EDU="School 5 – 9 years" & p7_relat=1 & q4v_7 ="School 5-7 years") match_EDUp7_ = 1. if (EDU="School 5 – 9 years" & p7_relat=1 & q4v_7 ="School 8-9 years") match_EDUp7_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p7_relat=1 & q4v_7 ="School up to 4 years") match_EDUp7_ = 1. if (EDU="SSC/ HSC" & p7_relat=1 & q4v_7 ="SSC/HSC") match_EDUp7_ = 1. if (EDU="some college (include diploma) but not graduate" & p8_relat=1 & q4v_8 ="College, but not graduate") match_EDUp8_ = 1. if (EDU="Graduate/ Post Graduate: general" & p8_relat=1 & q4v_8 ="Grad/postgraduate-general") match_EDUp8_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p8_relat=1 & q4v_8 ="Grad/postgraduate-professional") match_EDUp8_ = 1. if (EDU="Illiterate" & p8_relat=1 & q4v_8 ="Illiterate") match_EDUp8_ = 1. if (EDU="School 5 – 9 years" & p8_relat=1 & q4v_8 ="School 5-7 years") match_EDUp8_ = 1. if (EDU="School 5 – 9 years" & p8_relat=1 & q4v_8 ="School 8-9 years") match_EDUp8_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p8_relat=1 & q4v_8 ="School up to 4 years") match_EDUp8_ = 1. if (EDU="SSC/ HSC" & p8_relat=1 & q4v_8 ="SSC/HSC") match_EDUp8_ = 1. if (EDU="some college (include diploma) but not graduate" & p9_relat=1 & q4v_9 ="College, but not graduate") match_EDUp9_ = 1. if (EDU="Graduate/ Post Graduate: general" & p9_relat=1 & q4v_9 ="Grad/postgraduate-general") match_EDUp9_ = 1. if (EDU="Graduate/ Post Graduate: professional" & p9_relat=1 & q4v_9 ="Grad/postgraduate-professional") match_EDUp9_ = 1. if (EDU="Illiterate" & p9_relat=1 & q4v_9 ="Illiterate") match_EDUp9_ = 1. if (EDU="School 5 – 9 years" & p9_relat=1 & q4v_9 ="School 5-7 years") match_EDUp9_ = 1. if (EDU="School 5 – 9 years" & p9_relat=1 & q4v_9 ="School 8-9 years") match_EDUp9_ = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p9_relat=1 & q4v_9 ="School up to 4 years") match_EDUp9_ = 1. if (EDU="SSC/ HSC" & p9_relat=1 & q4v_9 ="SSC/HSC") match_EDUp9_ = 1. if (EDU="some college (include diploma) but not graduate" & p10relat=1 & q4v_10="College, but not graduate") match_EDUp10 = 1. if (EDU="Graduate/ Post Graduate: general" & p10relat=1 & q4v_10="Grad/postgraduate-general") match_EDUp10 = 1. if (EDU="Graduate/ Post Graduate: professional" & p10relat=1 & q4v_10="Grad/postgraduate-professional") match_EDUp10 = 1. if (EDU="Illiterate" & p10relat=1 & q4v_10="Illiterate") match_EDUp10 = 1. if (EDU="School 5 – 9 years" & p10relat=1 & q4v_10="School 5-7 years") match_EDUp10 = 1. if (EDU="School 5 – 9 years" & p10relat=1 & q4v_10="School 8-9 years") match_EDUp10 = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p10relat=1 & q4v_10="School up to 4 years") match_EDUp10 = 1. if (EDU="SSC/ HSC" & p10relat=1 & q4v_10="SSC/HSC") match_EDUp10 = 1. if (EDU="some college (include diploma) but not graduate" & p11relat=1 & q4v_11="College, but not graduate") match_EDUp11 = 1. if (EDU="Graduate/ Post Graduate: general" & p11relat=1 & q4v_11="Grad/postgraduate-general") match_EDUp11 = 1. if (EDU="Graduate/ Post Graduate: professional" & p11relat=1 & q4v_11="Grad/postgraduate-professional") match_EDUp11 = 1. if (EDU="Illiterate" & p11relat=1 & q4v_11="Illiterate") match_EDUp11 = 1. if (EDU="School 5 – 9 years" & p11relat=1 & q4v_11="School 5-7 years") match_EDUp11 = 1. if (EDU="School 5 – 9 years" & p11relat=1 & q4v_11="School 8-9 years") match_EDUp11 = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p11relat=1 & q4v_11="School up to 4 years") match_EDUp11 = 1. if (EDU="SSC/ HSC" & p11relat=1 & q4v_11="SSC/HSC") match_EDUp11 = 1. if (EDU="some college (include diploma) but not graduate" & p12relat=1 & q4v_12="College, but not graduate") match_EDUp12 = 1. if (EDU="Graduate/ Post Graduate: general" & p12relat=1 & q4v_12="Grad/postgraduate-general") match_EDUp12 = 1. if (EDU="Graduate/ Post Graduate: professional" & p12relat=1 & q4v_12="Grad/postgraduate-professional") match_EDUp12 = 1. if (EDU="Illiterate" & p12relat=1 & q4v_12="Illiterate") match_EDUp12 = 1. if (EDU="School 5 – 9 years" & p12relat=1 & q4v_12="School 5-7 years") match_EDUp12 = 1. if (EDU="School 5 – 9 years" & p12relat=1 & q4v_12="School 8-9 years") match_EDUp12 = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p12relat=1 & q4v_12="School up to 4 years") match_EDUp12 = 1. if (EDU="SSC/ HSC" & p12relat=1 & q4v_12="SSC/HSC") match_EDUp12 = 1. if (EDU="some college (include diploma) but not graduate" & p13relat=1 & q4v_13="College, but not graduate") match_EDUp13 = 1. if (EDU="Graduate/ Post Graduate: general" & p13relat=1 & q4v_13="Grad/postgraduate-general") match_EDUp13 = 1. if (EDU="Graduate/ Post Graduate: professional" & p13relat=1 & q4v_13="Grad/postgraduate-professional") match_EDUp13 = 1. if (EDU="Illiterate" & p13relat=1 & q4v_13="Illiterate") match_EDUp13 = 1. if (EDU="School 5 – 9 years" & p13relat=1 & q4v_13="School 5-7 years") match_EDUp13 = 1. if (EDU="School 5 – 9 years" & p13relat=1 & q4v_13="School 8-9 years") match_EDUp13 = 1. if (EDU="Literate but no formal schooling /school up to 4 years" & p13relat=1 & q4v_13="School up to 4 years") match_EDUp13 = 1. if (EDU="SSC/ HSC" & p13relat=1 & q4v_13="SSC/HSC") match_EDUp13 = 1. *. * OCC is job of chief wage earner. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p1_relat=1 & Q4vi_1 = "Businessman/industrialist") match_OCCp1_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p1_relat=1 & Q4vi_1 = "Businessman/industrialist") match_OCCp1_ = 1. if (OCC = "Clerical / Salesman" & p1_relat=1 & Q4vi_1 = "Clerical/salesperson") match_OCCp1_ = 1. if (OCC = "Officer/Executive - Junior" & p1_relat=1 & Q4vi_1 = "Officer/executive: junior") match_OCCp1_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p1_relat=1 & Q4vi_1 = "Officer/exec: mid/senior") match_OCCp1_ = 1. if (OCC = "Petty trader" & p1_relat=1 & Q4vi_1 = "Petty trader") match_OCCp1_ = 1. if (OCC = "Self Employed Professional" & p1_relat=1 & Q4vi_1 = "Self-employed professional") match_OCCp1_ = 1. if (OCC = "Shop owner" & p1_relat=1 & Q4vi_1 = "Shop owner") match_OCCp1_ = 1. if (OCC = "Skilled worker" & p1_relat=1 & Q4vi_1 = "Skilled worker") match_OCCp1_ = 1. if (OCC = "Supervisory Level" & p1_relat=1 & Q4vi_1 = "Supervisory level") match_OCCp1_ = 1. if (OCC = "Unskilled worker" & p1_relat=1 & Q4vi_1 = "Unskilled worker") match_OCCp1_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p2_relat=1 & Q4vi_2 = "Businessman/industrialist") match_OCCp2_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p2_relat=1 & Q4vi_2 = "Businessman/industrialist") match_OCCp2_ = 1. if (OCC = "Clerical / Salesman" & p2_relat=1 & Q4vi_2 = "Clerical/salesperson") match_OCCp2_ = 1. if (OCC = "Officer/Executive - Junior" & p2_relat=1 & Q4vi_2 = "Officer/executive: junior") match_OCCp2_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p2_relat=1 & Q4vi_2 = "Officer/exec: mid/senior") match_OCCp2_ = 1. if (OCC = "Petty trader" & p2_relat=1 & Q4vi_2 = "Petty trader") match_OCCp2_ = 1. if (OCC = "Self Employed Professional" & p2_relat=1 & Q4vi_2 = "Self-employed professional") match_OCCp2_ = 1. if (OCC = "Shop owner" & p2_relat=1 & Q4vi_2 = "Shop owner") match_OCCp2_ = 1. if (OCC = "Skilled worker" & p2_relat=1 & Q4vi_2 = "Skilled worker") match_OCCp2_ = 1. if (OCC = "Supervisory Level" & p2_relat=1 & Q4vi_2 = "Supervisory level") match_OCCp2_ = 1. if (OCC = "Unskilled worker" & p2_relat=1 & Q4vi_2 = "Unskilled worker") match_OCCp2_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p3_relat=1 & Q4vi_3 = "Businessman/industrialist") match_OCCp3_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p3_relat=1 & Q4vi_3 = "Businessman/industrialist") match_OCCp3_ = 1. if (OCC = "Clerical / Salesman" & p3_relat=1 & Q4vi_3 = "Clerical/salesperson") match_OCCp3_ = 1. if (OCC = "Officer/Executive - Junior" & p3_relat=1 & Q4vi_3 = "Officer/executive: junior") match_OCCp3_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p3_relat=1 & Q4vi_3 = "Officer/exec: mid/senior") match_OCCp3_ = 1. if (OCC = "Petty trader" & p3_relat=1 & Q4vi_3 = "Petty trader") match_OCCp3_ = 1. if (OCC = "Self Employed Professional" & p3_relat=1 & Q4vi_3 = "Self-employed professional") match_OCCp3_ = 1. if (OCC = "Shop owner" & p3_relat=1 & Q4vi_3 = "Shop owner") match_OCCp3_ = 1. if (OCC = "Skilled worker" & p3_relat=1 & Q4vi_3 = "Skilled worker") match_OCCp3_ = 1. if (OCC = "Supervisory Level" & p3_relat=1 & Q4vi_3 = "Supervisory level") match_OCCp3_ = 1. if (OCC = "Unskilled worker" & p3_relat=1 & Q4vi_3 = "Unskilled worker") match_OCCp3_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p4_relat=1 & Q4vi_4 = "Businessman/industrialist") match_OCCp4_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p4_relat=1 & Q4vi_4 = "Businessman/industrialist") match_OCCp4_ = 1. if (OCC = "Clerical / Salesman" & p4_relat=1 & Q4vi_4 = "Clerical/salesperson") match_OCCp4_ = 1. if (OCC = "Officer/Executive - Junior" & p4_relat=1 & Q4vi_4 = "Officer/executive: junior") match_OCCp4_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p4_relat=1 & Q4vi_4 = "Officer/exec: mid/senior") match_OCCp4_ = 1. if (OCC = "Petty trader" & p4_relat=1 & Q4vi_4 = "Petty trader") match_OCCp4_ = 1. if (OCC = "Self Employed Professional" & p4_relat=1 & Q4vi_4 = "Self-employed professional") match_OCCp4_ = 1. if (OCC = "Shop owner" & p4_relat=1 & Q4vi_4 = "Shop owner") match_OCCp4_ = 1. if (OCC = "Skilled worker" & p4_relat=1 & Q4vi_4 = "Skilled worker") match_OCCp4_ = 1. if (OCC = "Supervisory Level" & p4_relat=1 & Q4vi_4 = "Supervisory level") match_OCCp4_ = 1. if (OCC = "Unskilled worker" & p4_relat=1 & Q4vi_4 = "Unskilled worker") match_OCCp4_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p5_relat=1 & Q4vi_5 = "Businessman/industrialist") match_OCCp5_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p5_relat=1 & Q4vi_5 = "Businessman/industrialist") match_OCCp5_ = 1. if (OCC = "Clerical / Salesman" & p5_relat=1 & Q4vi_5 = "Clerical/salesperson") match_OCCp5_ = 1. if (OCC = "Officer/Executive - Junior" & p5_relat=1 & Q4vi_5 = "Officer/executive: junior") match_OCCp5_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p5_relat=1 & Q4vi_5 = "Officer/exec: mid/senior") match_OCCp5_ = 1. if (OCC = "Petty trader" & p5_relat=1 & Q4vi_5 = "Petty trader") match_OCCp5_ = 1. if (OCC = "Self Employed Professional" & p5_relat=1 & Q4vi_5 = "Self-employed professional") match_OCCp5_ = 1. if (OCC = "Shop owner" & p5_relat=1 & Q4vi_5 = "Shop owner") match_OCCp5_ = 1. if (OCC = "Skilled worker" & p5_relat=1 & Q4vi_5 = "Skilled worker") match_OCCp5_ = 1. if (OCC = "Supervisory Level" & p5_relat=1 & Q4vi_5 = "Supervisory level") match_OCCp5_ = 1. if (OCC = "Unskilled worker" & p5_relat=1 & Q4vi_5 = "Unskilled worker") match_OCCp5_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p6_relat=1 & Q4vi_6 = "Businessman/industrialist") match_OCCp6_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p6_relat=1 & Q4vi_6 = "Businessman/industrialist") match_OCCp6_ = 1. if (OCC = "Clerical / Salesman" & p6_relat=1 & Q4vi_6 = "Clerical/salesperson") match_OCCp6_ = 1. if (OCC = "Officer/Executive - Junior" & p6_relat=1 & Q4vi_6 = "Officer/executive: junior") match_OCCp6_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p6_relat=1 & Q4vi_6 = "Officer/exec: mid/senior") match_OCCp6_ = 1. if (OCC = "Petty trader" & p6_relat=1 & Q4vi_6 = "Petty trader") match_OCCp6_ = 1. if (OCC = "Self Employed Professional" & p6_relat=1 & Q4vi_6 = "Self-employed professional") match_OCCp6_ = 1. if (OCC = "Shop owner" & p6_relat=1 & Q4vi_6 = "Shop owner") match_OCCp6_ = 1. if (OCC = "Skilled worker" & p6_relat=1 & Q4vi_6 = "Skilled worker") match_OCCp6_ = 1. if (OCC = "Supervisory Level" & p6_relat=1 & Q4vi_6 = "Supervisory level") match_OCCp6_ = 1. if (OCC = "Unskilled worker" & p6_relat=1 & Q4vi_6 = "Unskilled worker") match_OCCp6_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p7_relat=1 & Q4vi_7 = "Businessman/industrialist") match_OCCp7_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p7_relat=1 & Q4vi_7 = "Businessman/industrialist") match_OCCp7_ = 1. if (OCC = "Clerical / Salesman" & p7_relat=1 & Q4vi_7 = "Clerical/salesperson") match_OCCp7_ = 1. if (OCC = "Officer/Executive - Junior" & p7_relat=1 & Q4vi_7 = "Officer/executive: junior") match_OCCp7_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p7_relat=1 & Q4vi_7 = "Officer/exec: mid/senior") match_OCCp7_ = 1. if (OCC = "Petty trader" & p7_relat=1 & Q4vi_7 = "Petty trader") match_OCCp7_ = 1. if (OCC = "Self Employed Professional" & p7_relat=1 & Q4vi_7 = "Self-employed professional") match_OCCp7_ = 1. if (OCC = "Shop owner" & p7_relat=1 & Q4vi_7 = "Shop owner") match_OCCp7_ = 1. if (OCC = "Skilled worker" & p7_relat=1 & Q4vi_7 = "Skilled worker") match_OCCp7_ = 1. if (OCC = "Supervisory Level" & p7_relat=1 & Q4vi_7 = "Supervisory level") match_OCCp7_ = 1. if (OCC = "Unskilled worker" & p7_relat=1 & Q4vi_7 = "Unskilled worker") match_OCCp7_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p8_relat=1 & Q4vi_8 = "Businessman/industrialist") match_OCCp8_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p8_relat=1 & Q4vi_8 = "Businessman/industrialist") match_OCCp8_ = 1. if (OCC = "Clerical / Salesman" & p8_relat=1 & Q4vi_8 = "Clerical/salesperson") match_OCCp8_ = 1. if (OCC = "Officer/Executive - Junior" & p8_relat=1 & Q4vi_8 = "Officer/executive: junior") match_OCCp8_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p8_relat=1 & Q4vi_8 = "Officer/exec: mid/senior") match_OCCp8_ = 1. if (OCC = "Petty trader" & p8_relat=1 & Q4vi_8 = "Petty trader") match_OCCp8_ = 1. if (OCC = "Self Employed Professional" & p8_relat=1 & Q4vi_8 = "Self-employed professional") match_OCCp8_ = 1. if (OCC = "Shop owner" & p8_relat=1 & Q4vi_8 = "Shop owner") match_OCCp8_ = 1. if (OCC = "Skilled worker" & p8_relat=1 & Q4vi_8 = "Skilled worker") match_OCCp8_ = 1. if (OCC = "Supervisory Level" & p8_relat=1 & Q4vi_8 = "Supervisory level") match_OCCp8_ = 1. if (OCC = "Unskilled worker" & p8_relat=1 & Q4vi_8 = "Unskilled worker") match_OCCp8_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p9_relat=1 & Q4vi_9 = "Businessman/industrialist") match_OCCp9_ = 1. if (OCC = "Businessman/Industrialist with - No employees" & p9_relat=1 & Q4vi_9 = "Businessman/industrialist") match_OCCp9_ = 1. if (OCC = "Clerical / Salesman" & p9_relat=1 & Q4vi_9 = "Clerical/salesperson") match_OCCp9_ = 1. if (OCC = "Officer/Executive - Junior" & p9_relat=1 & Q4vi_9 = "Officer/executive: junior") match_OCCp9_ = 1. if (OCC = "Officer/Executive - Senior / Middle" & p9_relat=1 & Q4vi_9 = "Officer/exec: mid/senior") match_OCCp9_ = 1. if (OCC = "Petty trader" & p9_relat=1 & Q4vi_9 = "Petty trader") match_OCCp9_ = 1. if (OCC = "Self Employed Professional" & p9_relat=1 & Q4vi_9 = "Self-employed professional") match_OCCp9_ = 1. if (OCC = "Shop owner" & p9_relat=1 & Q4vi_9 = "Shop owner") match_OCCp9_ = 1. if (OCC = "Skilled worker" & p9_relat=1 & Q4vi_9 = "Skilled worker") match_OCCp9_ = 1. if (OCC = "Supervisory Level" & p9_relat=1 & Q4vi_9 = "Supervisory level") match_OCCp9_ = 1. if (OCC = "Unskilled worker" & p9_relat=1 & Q4vi_9 = "Unskilled worker") match_OCCp9_ = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p10relat=1 & Q4vi_10= "Businessman/industrialist") match_OCCp10 = 1. if (OCC = "Businessman/Industrialist with - No employees" & p10relat=1 & Q4vi_10= "Businessman/industrialist") match_OCCp10 = 1. if (OCC = "Clerical / Salesman" & p10relat=1 & Q4vi_10= "Clerical/salesperson") match_OCCp10 = 1. if (OCC = "Officer/Executive - Junior" & p10relat=1 & Q4vi_10= "Officer/executive: junior") match_OCCp10 = 1. if (OCC = "Officer/Executive - Senior / Middle" & p10relat=1 & Q4vi_10= "Officer/exec: mid/senior") match_OCCp10 = 1. if (OCC = "Petty trader" & p10relat=1 & Q4vi_10= "Petty trader") match_OCCp10 = 1. if (OCC = "Self Employed Professional" & p10relat=1 & Q4vi_10= "Self-employed professional") match_OCCp10 = 1. if (OCC = "Shop owner" & p10relat=1 & Q4vi_10= "Shop owner") match_OCCp10 = 1. if (OCC = "Skilled worker" & p10relat=1 & Q4vi_10= "Skilled worker") match_OCCp10 = 1. if (OCC = "Supervisory Level" & p10relat=1 & Q4vi_10= "Supervisory level") match_OCCp10 = 1. if (OCC = "Unskilled worker" & p10relat=1 & Q4vi_10= "Unskilled worker") match_OCCp10 = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p11relat=1 & Q4vi_11= "Businessman/industrialist") match_OCCp11 = 1. if (OCC = "Businessman/Industrialist with - No employees" & p11relat=1 & Q4vi_11= "Businessman/industrialist") match_OCCp11 = 1. if (OCC = "Clerical / Salesman" & p11relat=1 & Q4vi_11= "Clerical/salesperson") match_OCCp11 = 1. if (OCC = "Officer/Executive - Junior" & p11relat=1 & Q4vi_11= "Officer/executive: junior") match_OCCp11 = 1. if (OCC = "Officer/Executive - Senior / Middle" & p11relat=1 & Q4vi_11= "Officer/exec: mid/senior") match_OCCp11 = 1. if (OCC = "Petty trader" & p11relat=1 & Q4vi_11= "Petty trader") match_OCCp11 = 1. if (OCC = "Self Employed Professional" & p11relat=1 & Q4vi_11= "Self-employed professional") match_OCCp11 = 1. if (OCC = "Shop owner" & p11relat=1 & Q4vi_11= "Shop owner") match_OCCp11 = 1. if (OCC = "Skilled worker" & p11relat=1 & Q4vi_11= "Skilled worker") match_OCCp11 = 1. if (OCC = "Supervisory Level" & p11relat=1 & Q4vi_11= "Supervisory level") match_OCCp11 = 1. if (OCC = "Unskilled worker" & p11relat=1 & Q4vi_11= "Unskilled worker") match_OCCp11 = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p12relat=1 & Q4vi_12= "Businessman/industrialist") match_OCCp12 = 1. if (OCC = "Businessman/Industrialist with - No employees" & p12relat=1 & Q4vi_12= "Businessman/industrialist") match_OCCp12 = 1. if (OCC = "Clerical / Salesman" & p12relat=1 & Q4vi_12= "Clerical/salesperson") match_OCCp12 = 1. if (OCC = "Officer/Executive - Junior" & p12relat=1 & Q4vi_12= "Officer/executive: junior") match_OCCp12 = 1. if (OCC = "Officer/Executive - Senior / Middle" & p12relat=1 & Q4vi_12= "Officer/exec: mid/senior") match_OCCp12 = 1. if (OCC = "Petty trader" & p12relat=1 & Q4vi_12= "Petty trader") match_OCCp12 = 1. if (OCC = "Self Employed Professional" & p12relat=1 & Q4vi_12= "Self-employed professional") match_OCCp12 = 1. if (OCC = "Shop owner" & p12relat=1 & Q4vi_12= "Shop owner") match_OCCp12 = 1. if (OCC = "Skilled worker" & p12relat=1 & Q4vi_12= "Skilled worker") match_OCCp12 = 1. if (OCC = "Supervisory Level" & p12relat=1 & Q4vi_12= "Supervisory level") match_OCCp12 = 1. if (OCC = "Unskilled worker" & p12relat=1 & Q4vi_12= "Unskilled worker") match_OCCp12 = 1. if (OCC = "Businessman/Industrialist with - 1-9 employees" & p13relat=1 & Q4vi_13= "Businessman/industrialist") match_OCCp13 = 1. if (OCC = "Businessman/Industrialist with - No employees" & p13relat=1 & Q4vi_13= "Businessman/industrialist") match_OCCp13 = 1. if (OCC = "Clerical / Salesman" & p13relat=1 & Q4vi_13= "Clerical/salesperson") match_OCCp13 = 1. if (OCC = "Officer/Executive - Junior" & p13relat=1 & Q4vi_13= "Officer/executive: junior") match_OCCp13 = 1. if (OCC = "Officer/Executive - Senior / Middle" & p13relat=1 & Q4vi_13= "Officer/exec: mid/senior") match_OCCp13 = 1. if (OCC = "Petty trader" & p13relat=1 & Q4vi_13= "Petty trader") match_OCCp13 = 1. if (OCC = "Self Employed Professional" & p13relat=1 & Q4vi_13= "Self-employed professional") match_OCCp13 = 1. if (OCC = "Shop owner" & p13relat=1 & Q4vi_13= "Shop owner") match_OCCp13 = 1. if (OCC = "Skilled worker" & p13relat=1 & Q4vi_13= "Skilled worker") match_OCCp13 = 1. if (OCC = "Supervisory Level" & p13relat=1 & Q4vi_13= "Supervisory level") match_OCCp13 = 1. if (OCC = "Unskilled worker" & p13relat=1 & Q4vi_13= "Unskilled worker") match_OCCp13 = 1. *. if (match_OCCp1_ =1 and match_EDUp1_ =1) match_p1_ = 1. if (match_OCCp2_ =1 and match_EDUp2_ =1) match_p2_ = 1. if (match_OCCp3_ =1 and match_EDUp3_ =1) match_p3_ = 1. if (match_OCCp4_ =1 and match_EDUp4_ =1) match_p4_ = 1. if (match_OCCp5_ =1 and match_EDUp5_ =1) match_p5_ = 1. if (match_OCCp6_ =1 and match_EDUp6_ =1) match_p6_ = 1. if (match_OCCp7_ =1 and match_EDUp7_ =1) match_p7_ = 1. if (match_OCCp8_ =1 and match_EDUp8_ =1) match_p8_ = 1. if (match_OCCp9_ =1 and match_EDUp9_ =1) match_p9_ = 1. if (match_OCCp10 =1 and match_EDUp10 =1) match_p10 = 1. if (match_OCCp11 =1 and match_EDUp11 =1) match_p11 = 1. if (match_OCCp12 =1 and match_EDUp12 =1) match_p12 = 1. if (match_OCCp13 =1 and match_EDUp13 =1) match_p13 = 1. freq match_p1_ match_p2_ match_p3_ match_p4_ match_p5_ match_p6_ match_p7_ match_p9_ . /* p8_ and p10 to p13 all empty. *cros match_p1_ by match_p2_ . /* 7 ambiguous cases. *cros match_p3_ by match_p4_ . /* 1 ambiguous case. compute respondent_person_num = -9. if (p13relat=0) respondent_person_num = 13. if (p12relat=0) respondent_person_num = 12. if (p11relat=0) respondent_person_num = 11. if (p10relat=0) respondent_person_num = 10. if (p9_relat=0) respondent_person_num = 9. if (p8_relat=0) respondent_person_num = 8. if (p7_relat=0) respondent_person_num = 7. if (p6_relat=0) respondent_person_num = 6. if (p5_relat=0) respondent_person_num = 5. if (p4_relat=0) respondent_person_num = 4. if (p3_relat=0) respondent_person_num = 3. if (p2_relat=0) respondent_person_num = 2. if (p1_relat=0) respondent_person_num = 1. cros respondent_person_num by q3a. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="Yes" and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="Yes" and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="Yes" and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="Yes" and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="Yes" and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="Yes" and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="Yes" and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="Yes" and p9_relat=1) p9_relat = 0. *. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and match_p1_ = 1 and Q3a="No" and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and match_p2_ = 1 and Q3a="No" and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and match_p3_ = 1 and Q3a="No" and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and match_p4_ = 1 and Q3a="No" and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and match_p5_ = 1 and Q3a="No" and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and match_p6_ = 1 and Q3a="No" and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and match_p7_ = 1 and Q3a="No" and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and match_p9_ = 1 and Q3a="No" and p13relat=1) p13relat = 0. compute respondent_person_num = -9. if (p13relat=0) respondent_person_num = 13. if (p12relat=0) respondent_person_num = 12. if (p11relat=0) respondent_person_num = 11. if (p10relat=0) respondent_person_num = 10. if (p9_relat=0) respondent_person_num = 9. if (p8_relat=0) respondent_person_num = 8. if (p7_relat=0) respondent_person_num = 7. if (p6_relat=0) respondent_person_num = 6. if (p5_relat=0) respondent_person_num = 5. if (p4_relat=0) respondent_person_num = 4. if (p3_relat=0) respondent_person_num = 3. if (p2_relat=0) respondent_person_num = 2. if (p1_relat=0) respondent_person_num = 1. cros respondent_person_num by q3a. compute p1_hasJb = p1_job. compute p2_hasJb = p2_job. compute p3_hasJb = p3_job. compute p4_hasJb = p4_job. compute p5_hasJb = p5_job. compute p6_hasJb = p6_job. compute p7_hasJb = p7_job. compute p8_hasJb = p8_job. compute p9_hasJb = p9_job. compute p10hasJb = p10job. compute p11hasJb = p11job. compute p12hasJb = p12job. compute p13hasJb = p13job. recode p1_hasJb p2_hasJb p3_hasJb p4_hasJb p5_hasJb p6_hasJb p7_hasJb p8_hasJb p9_hasJb p10hasJb p11hasJb p12hasJb p13hasJb (1 thru 10=1)(11 thru 15=0)(16=sysmis). *If 2 spouses in hh & don't know who's respondent <--- spouse i has job ---> <--spouse j has no job --> {spouse j must be respondent, because Q3a shows respondent is NOT the main earner}. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p1_hasJb=1 & p1_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJb=1 & p2_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJb=1 & p3_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJb=1 & p4_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJb=1 & p5_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJb=1 & p6_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJb=1 & p7_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJb=1 & p8_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJb=1 & p9_relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJb=1 & p10relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJb=1 & p11relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJb=1 & p12relat=1 and p13hasJb=0 & p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p1_hasJb=0 & p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p2_hasJb=0 & p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p3_hasJb=0 & p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p4_hasJb=0 & p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p5_hasJb=0 & p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p6_hasJb=0 & p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p7_hasJb=0 & p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p8_hasJb=0 & p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p10hasJb=0 & p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p11hasJb=0 & p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJb=1 & p13relat=1 and p12hasJb=0 & p12relat=1) p12relat = 0. *. compute respondent_person_num = -9. if (p13relat=0) respondent_person_num = 13. if (p12relat=0) respondent_person_num = 12. if (p11relat=0) respondent_person_num = 11. if (p10relat=0) respondent_person_num = 10. if (p9_relat=0) respondent_person_num = 9. if (p8_relat=0) respondent_person_num = 8. if (p7_relat=0) respondent_person_num = 7. if (p6_relat=0) respondent_person_num = 6. if (p5_relat=0) respondent_person_num = 5. if (p4_relat=0) respondent_person_num = 4. if (p3_relat=0) respondent_person_num = 3. if (p2_relat=0) respondent_person_num = 2. if (p1_relat=0) respondent_person_num = 1. cros respondent_person_num by q3a. *If 2 spouses in hh & don't know who's respondent <--- spouse i has job ---> <--spouse j has no job --> {spouse i must be respondent, because Q3a shows respondent IS the main earner}. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p2_hasJb=0 & p2_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p3_hasJb=0 & p3_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p4_hasJb=0 & p4_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p5_hasJb=0 & p5_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p6_hasJb=0 & p6_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p7_hasJb=0 & p7_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p8_hasJb=0 & p8_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p9_hasJb=0 & p9_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p10hasJb=0 & p10relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p11hasJb=0 & p11relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p12hasJb=0 & p12relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p1_hasJb=1 & p1_relat=1 and p13hasJb=0 & p13relat=1) p1_relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p1_hasJb=0 & p1_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p3_hasJb=0 & p3_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p4_hasJb=0 & p4_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p5_hasJb=0 & p5_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p6_hasJb=0 & p6_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p7_hasJb=0 & p7_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p8_hasJb=0 & p8_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p9_hasJb=0 & p9_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p10hasJb=0 & p10relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p11hasJb=0 & p11relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p12hasJb=0 & p12relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p2_hasJb=1 & p2_relat=1 and p13hasJb=0 & p13relat=1) p2_relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p1_hasJb=0 & p1_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p2_hasJb=0 & p2_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p4_hasJb=0 & p4_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p5_hasJb=0 & p5_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p6_hasJb=0 & p6_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p7_hasJb=0 & p7_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p8_hasJb=0 & p8_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p9_hasJb=0 & p9_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p10hasJb=0 & p10relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p11hasJb=0 & p11relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p12hasJb=0 & p12relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p3_hasJb=1 & p3_relat=1 and p13hasJb=0 & p13relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p1_hasJb=0 & p1_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p2_hasJb=0 & p2_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p3_hasJb=0 & p3_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p5_hasJb=0 & p5_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p6_hasJb=0 & p6_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p7_hasJb=0 & p7_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p8_hasJb=0 & p8_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p9_hasJb=0 & p9_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p10hasJb=0 & p10relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p11hasJb=0 & p11relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p12hasJb=0 & p12relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p4_hasJb=1 & p4_relat=1 and p13hasJb=0 & p13relat=1) p4_relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p1_hasJb=0 & p1_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p2_hasJb=0 & p2_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p3_hasJb=0 & p3_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p4_hasJb=0 & p4_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p6_hasJb=0 & p6_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p7_hasJb=0 & p7_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p8_hasJb=0 & p8_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p9_hasJb=0 & p9_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p10hasJb=0 & p10relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p11hasJb=0 & p11relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p12hasJb=0 & p12relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p5_hasJb=1 & p5_relat=1 and p13hasJb=0 & p13relat=1) p5_relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p1_hasJb=0 & p1_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p2_hasJb=0 & p2_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p3_hasJb=0 & p3_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p4_hasJb=0 & p4_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p5_hasJb=0 & p5_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p7_hasJb=0 & p7_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p8_hasJb=0 & p8_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p9_hasJb=0 & p9_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p10hasJb=0 & p10relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p11hasJb=0 & p11relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p12hasJb=0 & p12relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p6_hasJb=1 & p6_relat=1 and p13hasJb=0 & p13relat=1) p6_relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p1_hasJb=0 & p1_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p2_hasJb=0 & p2_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p3_hasJb=0 & p3_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p4_hasJb=0 & p4_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p5_hasJb=0 & p5_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p6_hasJb=0 & p6_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p8_hasJb=0 & p8_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p9_hasJb=0 & p9_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p10hasJb=0 & p10relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p11hasJb=0 & p11relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p12hasJb=0 & p12relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p7_hasJb=1 & p7_relat=1 and p13hasJb=0 & p13relat=1) p7_relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p1_hasJb=0 & p1_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p2_hasJb=0 & p2_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p3_hasJb=0 & p3_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p4_hasJb=0 & p4_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p5_hasJb=0 & p5_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p6_hasJb=0 & p6_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p7_hasJb=0 & p7_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p9_hasJb=0 & p9_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p10hasJb=0 & p10relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p11hasJb=0 & p11relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p12hasJb=0 & p12relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p8_hasJb=1 & p8_relat=1 and p13hasJb=0 & p13relat=1) p8_relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p1_hasJb=0 & p1_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p2_hasJb=0 & p2_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p3_hasJb=0 & p3_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p4_hasJb=0 & p4_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p5_hasJb=0 & p5_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p6_hasJb=0 & p6_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p7_hasJb=0 & p7_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p9_hasJb=0 & p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p10hasJb=0 & p10relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p11hasJb=0 & p11relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p12hasJb=0 & p12relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p9_hasJb=1 & p9_relat=1 and p13hasJb=0 & p13relat=1) p9_relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p1_hasJb=0 & p1_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p2_hasJb=0 & p2_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p3_hasJb=0 & p3_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p4_hasJb=0 & p4_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p5_hasJb=0 & p5_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p6_hasJb=0 & p6_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p7_hasJb=0 & p7_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p8_hasJb=0 & p8_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p9_hasJb=0 & p9_relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p11hasJb=0 & p11relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p12hasJb=0 & p12relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p10hasJb=1 & p10relat=1 and p13hasJb=0 & p13relat=1) p10relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p1_hasJb=0 & p1_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p2_hasJb=0 & p2_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p3_hasJb=0 & p3_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p4_hasJb=0 & p4_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p5_hasJb=0 & p5_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p6_hasJb=0 & p6_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p7_hasJb=0 & p7_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p8_hasJb=0 & p8_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p9_hasJb=0 & p9_relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p10hasJb=0 & p10relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p12hasJb=0 & p12relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p11hasJb=1 & p11relat=1 and p13hasJb=0 & p13relat=1) p11relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p1_hasJb=0 & p1_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p2_hasJb=0 & p2_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p3_hasJb=0 & p3_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p4_hasJb=0 & p4_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p5_hasJb=0 & p5_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p6_hasJb=0 & p6_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p7_hasJb=0 & p7_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p8_hasJb=0 & p8_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p9_hasJb=0 & p9_relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p10hasJb=0 & p10relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p11hasJb=0 & p11relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p12hasJb=1 & p12relat=1 and p13hasJb=0 & p13relat=1) p12relat = 0. *. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p1_hasJb=0 & p1_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p2_hasJb=0 & p2_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p3_hasJb=0 & p3_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p4_hasJb=0 & p4_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p5_hasJb=0 & p5_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p6_hasJb=0 & p6_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p7_hasJb=0 & p7_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p8_hasJb=0 & p8_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p9_hasJb=0 & p9_relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p10hasJb=0 & p10relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p11hasJb=0 & p11relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and p13hasJb=1 & p13relat=1 and p12hasJb=0 & p12relat=1) p13relat = 0. compute respondent_person_num = -9. if (p13relat=0) respondent_person_num = 13. if (p12relat=0) respondent_person_num = 12. if (p11relat=0) respondent_person_num = 11. if (p10relat=0) respondent_person_num = 10. if (p9_relat=0) respondent_person_num = 9. if (p8_relat=0) respondent_person_num = 8. if (p7_relat=0) respondent_person_num = 7. if (p6_relat=0) respondent_person_num = 6. if (p5_relat=0) respondent_person_num = 5. if (p4_relat=0) respondent_person_num = 4. if (p3_relat=0) respondent_person_num = 3. if (p2_relat=0) respondent_person_num = 2. if (p1_relat=0) respondent_person_num = 1. cros respondent_person_num by q3a. *if (earn_hus > earn_wif) earnMore = 0. *if (earn_hus < earn_wif) earnMore = 2. *val lab earnMore 0 'hus earns more' 2 'wif earns more'. *cros earnMore by sex by Q3a. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p1_sex=0 and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p2_sex=0 and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p3_sex=0 and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p4_sex=0 and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p5_sex=0 and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p6_sex=0 and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p7_sex=0 and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p8_sex=0 and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p9_sex=0 and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p10sex=0 and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p11sex=0 and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p12sex=0 and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_hus>earn_wif & p13sex=0 and p13relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and earn_husearn_wif & p1_sex=1 and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p2_sex=1 and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p3_sex=1 and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p4_sex=1 and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p5_sex=1 and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p6_sex=1 and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p7_sex=1 and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p8_sex=1 and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p9_sex=1 and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p10sex=1 and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p11sex=1 and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p12sex=1 and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus>earn_wif & p13sex=1 and p13relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="No" and earn_hus0 & paid_wif=0 & p1_sex=0 and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p2_sex=0 and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p3_sex=0 and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p4_sex=0 and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p5_sex=0 and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p6_sex=0 and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p7_sex=0 and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p8_sex=0 and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p9_sex=0 and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p10sex=0 and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p11sex=0 and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p12sex=0 and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus>0 & paid_wif=0 & p13sex=0 and p13relat=1) p13relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p1_sex=1 and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p2_sex=1 and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p3_sex=1 and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p4_sex=1 and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p5_sex=1 and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p6_sex=1 and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p7_sex=1 and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p8_sex=1 and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p9_sex=1 and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p10sex=1 and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p11sex=1 and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p12sex=1 and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="Yes" and paid_hus=0 & paid_wif>0 & p13sex=1 and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p1_sex=1 and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p2_sex=1 and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p3_sex=1 and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p4_sex=1 and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p5_sex=1 and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p6_sex=1 and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p7_sex=1 and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p8_sex=1 and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p9_sex=1 and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p10sex=1 and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p11sex=1 and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p12sex=1 and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus>0 & paid_wif=0 & p13sex=1 and p13relat=1) p13relat = 0. *. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p1_sex=0 and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p2_sex=0 and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p3_sex=0 and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p4_sex=0 and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p5_sex=0 and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p6_sex=0 and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p7_sex=0 and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p8_sex=0 and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p9_sex=0 and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p10sex=0 and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p11sex=0 and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p12sex=0 and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and paid_hus=0 & paid_wif>0 & p13sex=0 and p13relat=1) p13relat = 0. * Re-run these lines, now I've added more cases to [p1_relat=0], [p2_relat=0], etc:. if (p13relat = 0) sex = p13sex. if (p12relat = 0) sex = p12sex. if (p11relat = 0) sex = p11sex. if (p10relat = 0) sex = p10sex. if (p9_relat = 0) sex = p9_sex. if (p8_relat = 0) sex = p8_sex. if (p7_relat = 0) sex = p7_sex. if (p6_relat = 0) sex = p6_sex. if (p5_relat = 0) sex = p5_sex. if (p4_relat = 0) sex = p4_sex. if (p3_relat = 0) sex = p3_sex. if (p2_relat = 0) sex = p2_sex. if (p1_relat = 0) sex = p1_sex. *freq sex. /* Still missing cases of sex. compute respondent_person_num = -9. if (p13relat=0) respondent_person_num = 13. if (p12relat=0) respondent_person_num = 12. if (p11relat=0) respondent_person_num = 11. if (p10relat=0) respondent_person_num = 10. if (p9_relat=0) respondent_person_num = 9. if (p8_relat=0) respondent_person_num = 8. if (p7_relat=0) respondent_person_num = 7. if (p6_relat=0) respondent_person_num = 6. if (p5_relat=0) respondent_person_num = 5. if (p4_relat=0) respondent_person_num = 4. if (p3_relat=0) respondent_person_num = 3. if (p2_relat=0) respondent_person_num = 2. if (p1_relat=0) respondent_person_num = 1. *cros respondent_person_num by q3a. if (respondent_person_num = -9 and Q3a="No" and p1_hasJB=0 and p1_relat=1) p1_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p2_hasJB=0 and p2_relat=1) p2_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p3_hasJB=0 and p3_relat=1) p3_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p4_hasJB=0 and p4_relat=1) p4_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p5_hasJB=0 and p5_relat=1) p5_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p6_hasJB=0 and p6_relat=1) p6_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p7_hasJB=0 and p7_relat=1) p7_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p8_hasJB=0 and p8_relat=1) p8_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p9_hasJB=0 and p9_relat=1) p9_relat = 0. if (respondent_person_num = -9 and Q3a="No" and p10hasJB=0 and p10relat=1) p10relat = 0. if (respondent_person_num = -9 and Q3a="No" and p11hasJB=0 and p11relat=1) p11relat = 0. if (respondent_person_num = -9 and Q3a="No" and p12hasJB=0 and p12relat=1) p12relat = 0. if (respondent_person_num = -9 and Q3a="No" and p13hasJB=0 and p13relat=1) p13relat = 0. * Re-run these lines, now I've added more cases to [p1_relat=0], [p2_relat=0], etc:. if (p13relat = 0) sex = p13sex. if (p12relat = 0) sex = p12sex. if (p11relat = 0) sex = p11sex. if (p10relat = 0) sex = p10sex. if (p9_relat = 0) sex = p9_sex. if (p8_relat = 0) sex = p8_sex. if (p7_relat = 0) sex = p7_sex. if (p6_relat = 0) sex = p6_sex. if (p5_relat = 0) sex = p5_sex. if (p4_relat = 0) sex = p4_sex. if (p3_relat = 0) sex = p3_sex. if (p2_relat = 0) sex = p2_sex. if (p1_relat = 0) sex = p1_sex. freq sex. /* Still missing cases of sex. compute respondent_person_num = -9. if (p13relat=0) respondent_person_num = 13. if (p12relat=0) respondent_person_num = 12. if (p11relat=0) respondent_person_num = 11. if (p10relat=0) respondent_person_num = 10. if (p9_relat=0) respondent_person_num = 9. if (p8_relat=0) respondent_person_num = 8. if (p7_relat=0) respondent_person_num = 7. if (p6_relat=0) respondent_person_num = 6. if (p5_relat=0) respondent_person_num = 5. if (p4_relat=0) respondent_person_num = 4. if (p3_relat=0) respondent_person_num = 3. if (p2_relat=0) respondent_person_num = 2. if (p1_relat=0) respondent_person_num = 1. cros respondent_person_num by q3a. *cros OCC by sex. /* if OCC is missing, does this tell me anything?. *recode match_OCCp1_ match_EDUp1_ (sysmis = 0). *cros sex by match_OCCp1_ by match_EDUp1_ . *recode match_OCCp2_ match_EDUp2_ (sysmis = 0). *cros sex by match_OCCp2_ by match_EDUp2_ . * Could adapt syntax abov, to match if same OCC (or same EDU, but needn't be both): . *if (match_OCCp1_ =1 and match_EDUp1_ =1) match_p1_ = 1. *if (match_OCCp2_ =1 and match_EDUp2_ =1) match_p2_ = 1. *if (match_OCCp3_ =1 and match_EDUp3_ =1) match_p3_ = 1. *if (match_OCCp4_ =1 and match_EDUp4_ =1) match_p4_ = 1. *if (match_OCCp5_ =1 and match_EDUp5_ =1) match_p5_ = 1. *if (match_OCCp6_ =1 and match_EDUp6_ =1) match_p6_ = 1. *if (match_OCCp7_ =1 and match_EDUp7_ =1) match_p7_ = 1. *if (match_OCCp8_ =1 and match_EDUp8_ =1) match_p8_ = 1. *if (match_OCCp9_ =1 and match_EDUp9_ =1) match_p9_ = 1. *if (match_OCCp10 =1 and match_EDUp10 =1) match_p10 = 1. *if (match_OCCp11 =1 and match_EDUp11 =1) match_p11 = 1. *if (match_OCCp12 =1 and match_EDUp12 =1) match_p12 = 1. *if (match_OCCp13 =1 and match_EDUp13 =1) match_p13 = 1. if (earn_hus=0 & earn_wif=0) earn_any = 1. if (earn_hus=0 & earn_wif>0) earn_any = 2. if (earn_hus>0 & earn_wif=0) earn_any = 3. if (earn_hus>0 & earn_wif>0) earn_any = 4. val lab earn_any 1 'neither' 2 'only wife earns' 3 'only husband earns' 4 'both earn'. *cros earn_any by sex. *cros earn_any by sex by Q3a. if (sex = -9 & earn_any=3 & Q3a="Yes") sex = 0. if (sex = -9 & earn_any=2 & Q3a="Yes") sex = 1. if (sex = -9 & earn_any=3 & Q3a="No" ) sex = 1. if (sex = -9 & earn_any=2 & Q3a="No" ) sex = 0. * ' zzz I think I can modify the above 4 lines, so they replace p??relat=1 by p??relat=0 for respondent (as in above syntax). cros sex by Q3a. /* Could assume Chief Income Earner is male, if I have no other evidence. recode sex (-9 = sysmis). /* There are still 74 cases where I can't tell if respondent is male or female. Can I identify if male or female, e.g. by asking IMRB?. recode p1_educ,p2_educ,p3_educ,p4_educ,p5_educ,p6_educ,p7_educ,p8_educ,p9_educ,p10educ,p11educ,p12educ,p13educ (1=0)(2=10)(3=20)(4=30)(5=55)(6=65)(7=80)(8=90)(9= -2)(else=sysmis). val label p1_educ p2_educ p3_educ p4_educ p5_educ p6_educ p7_educ p8_educ p9_educ p10educ p11educ p12educ p13educ 0 "no school/illiterate" 10 "school up to 4 years" 20 "over 4 years primary school" 30 "primary school completed, some secondary" 40 "secondary school, incomplete" 55 "matric/Secondary School Cert/O or A-level" 65 "college not graduate (eg technical)" 72 "college: diploma/secretarial qual" 75 "higher college diploma/degree (eg HND)" 77 "incomplete degree" 80 "graduate/above, general" 90 "postgrad (e.g. MA); graduate professional" 59 "other" -2 "not disclosed" -3 "too young to be at school". /* "school 5 - 9 years" is included in educ=20; SSC/HSC is included with educ=55. * My education scale: 0=no school to 100=20years. 30 seems similar to 40. Educ=30 (formerly =35) should be equivalent to '5 to 9 years of educ' in IMRB 1997 & 2002. recode P1_job,P2_job,P3_job,P4_job,P5_job,P6_job,P7_job,P8_job,P9_job,P10job,P11job,P12job,P13job (1=21)(2=29)(3=51)(4=59)(5=83)(6=75)(7=35)(8=45)(9=92)(10=98)(11=7) (12=9) (13=15)(14=0)(15=3)(16=-2). val label P1_job,P2_job,P3_job,P4_job,P5_job,P6_job,P7_job,P8_job,P9_job,P10job,P11job,P12job,P13job 98 "mid/senior officer/executive", 95 "officer/executive", 92 "junior officer/executive" 86 "manager: 10+ employees", 84 "manager:1-9 employees" 83 "manager", 82 "manager: 0 employees", 75 "professional (often self-employed)", 65 "self-employed: unspecified", 59 "shop owner", 51 "petty trader", 45 "supervisory", 40 "civil servant", 35 "clerical/sales", 29 "manual: skilled", 28 "farmer", 27 "employed: unspecified", 25 "manual: unspecified", 24 "manual: semi-skilled", 21 "manual: unskilled", 20 "farm worker", 15 "student", 9 "housewife: was employed", 8 "housewife: dk if ever employed", 7 "housewife: never employed", 5 "unemployed: was employed", 4 "unemployed: never employed", 3 "unemployed: no details", 2 "unemployed: seeking work", 1 "unemployed: not seeking work", 0 "retired", -8 "too young to be employed", -2 "not disclosed", -1"don't know", -9 "missing/no answer/wild". *freq q5oth. /* Could include these few values. *freq q6aoth. /* Could include these few values. *freq q6both. /* Could include these few values. if (Q5 ="Husband and wife manage these expenses separately") managMon = 4. if (Q5 ="Husband and wife manage these expenses together") managMon = 3. if (Q5 ="Husband usually looks after all these expenses") managMon = 1. if (Q5 ="Other") managMon = 5. if (Q5 ="Wife usually looks after all these expenses") managMon = 2. *. if (Q6a="Parents") finalSay = 4. if (Q6a="Husband and wife together") finalSay = 3. if (Q6a="Husband") finalSay = 1. if (Q6a="Other") finalSay = 5. if (Q6a="Wife") finalSay = 2. *. if (Q6b="Parents") at_final = 4. if (Q6b="Husband and wife together") at_final = 3. if (Q6b="Husband") at_final = 1. if (Q6b="Other") at_final = 5. if (Q6b="Wife") at_final = 2. if (Q6bOth="self" & q4ii_1="Respondent" & Q4iii_1="Female") at_final = 2. if (Q6bOth="everybody should contribute") at_final = 993. if (Q6c = "Almost every month") skipMeal = 1. if (Q6c = "Don’t know / Can’t say") skipMeal = 9. if (Q6c = "Never") skipMeal = 4. if (Q6c = "Only one or two months") skipMeal = 3. if (Q6c = "Some months but not every month") skipMeal = 2. rename var (Q9a_1 =sp_cerea)(Q9a_2 =sp_dairy)(Q9a_3 =sp_veget )(Q9a_4 =sp_meatF)(Q9a_5 =sp_oil )(Q9a_6 =sp_bread)(Q9b_1 =sp_insta)(Q9b_2 =sp_drink)(Q9b_3 =sp_tobac)(Q9b_4 =sp_fMeal) (Q9b_5 =sp_snack)(Q9b_6 =sp_cloth)(Q9c_1 =sp_gambl)(Q9c_2 =sp_gas )(Q9c_3 =sp_el_wa)(Q9c_4 =sp_rent )(Q9c_5 =sp_maid)(Q9c_6 =sp_laund)(Q9c_7 =sp_trans )(Q9c_8=sp_phone). *breakd sp_cerea sp_dairy sp_veget sp_meatF sp_oil sp_bread sp_insta sp_drink sp_tobac sp_fMeal sp_snack sp_cloth sp_gambl sp_gas sp_el_wa sp_rent sp_maid sp_laund sp_trans sp_phone /cells mean count. *breakd HHincome by live_cit /cells mean count. if (Q10 = "Can go on your own") canGoOut = 1. if (Q10 = "Can’t go out without permission") canGoOut = 4. if (Q10 = "Don’t know / Can’t say") canGoOut = 9. if (Q10 = "Only with another adult") canGoOut = 3. if (Q10 = "Only with children") canGoOut = 2. if (Q11a="1 day a week" ) out_resp = 1. if (Q11a="2 days a week") out_resp = 2. if (Q11a="3 days a week") out_resp = 3. if (Q11a="4 days a week") out_resp = 4. if (Q11a="5 days a week") out_resp = 5. if (Q11a="6 days a week") out_resp = 6. if (Q11a="DK/ refused" ) out_resp = 9. if (Q11a="Every day" ) out_resp = 7. if (Q11a="Never" ) out_resp = 0. if (Q11b="1 day a week" ) out_spou = 1. if (Q11b="2 days a week") out_spou = 2. if (Q11b="3 days a week") out_spou = 3. if (Q11b="4 days a week") out_spou = 4. if (Q11b="5 days a week") out_spou = 5. if (Q11b="6 days a week") out_spou = 6. if (Q11b="DK/ refused" ) out_spou = 9. if (Q11b="Every day" ) out_spou = 7. if (Q11b="Never" ) out_spou = 0. recode out_resp out_spou (9= -1). * Many out_spou missing - most, but not all, of these respondents have no spouse. But if have spouse, set (out_spou=0) ?. *recode out_spou ( sysmis = -77). *if (married=1 & ( out_spou = -77)) out_spou=0. *recode out_spou ( -77 = sysmis). if (sex=0) out_hus = out_resp. if (sex=0) out_wif = out_spou. if (sex=1) out_wif = out_resp. if (sex=1) out_hus = out_spou. var label out_resp 'Number of times respondent goes out to bar/club (per week)'. var label out_spou 'Number of times spouse goes out to bar/club (per week)'. var label out_hus 'Number of times husband goes out to bar/club (per week)'. var label out_wif 'Number of times wife goes out to bar/club (per week)'. value lab out_resp, out_spou, out_hus, out_wif 0 'never' 7 'every day'. if (Q12_1 ="DK /CS" ) AT_jbSGL = 4. if (Q12_1 ="Full time" ) AT_jbSGL = 1. if (Q12_1 ="Not at all") AT_jbSGL = 3. if (Q12_1 ="Part time") AT_jbSGL = 2. if (Q12_2 ="DK /CS" ) AT_jbNoK = 4. if (Q12_2 ="Full time" ) AT_jbNoK = 1. if (Q12_2 ="Not at all") AT_jbNoK = 3. if (Q12_2 ="Part time") AT_jbNoK = 2. if (Q12_3 ="DK /CS" ) AT_jbINF = 4. if (Q12_3 ="Full time" ) AT_jbINF = 1. if (Q12_3 ="Not at all") AT_jbINF = 3. if (Q12_3 ="Part time") AT_jbINF = 2. if (Q12_4 ="DK /CS" ) AT_jbKID = 4. if (Q12_4 ="Full time" ) AT_jbKID = 1. if (Q12_4 ="Not at all") AT_jbKID = 3. if (Q12_4 ="Part time") AT_jbKID = 2. if (Q13_1 ="Agree Somewhat") at_wHapy = 4. if (Q13_1 ="Disagree Somewhat") at_wHapy = 2. if (Q13_1 ="Disagree strongly") at_wHapy = 1. if (Q13_1 ="DK / Refused") at_wHapy = 9. if (Q13_1 ="Neither agree nor disagree") at_wHapy = 3. if (Q13_1 ="Strongly agree") at_wHapy = 5. if (Q13_2 ="Agree Somewhat") AT_oHapy = 4. if (Q13_2 ="Disagree Somewhat") AT_oHapy = 2. if (Q13_2 ="Disagree strongly") AT_oHapy = 1. if (Q13_2 ="DK / Refused") AT_oHapy = 9. if (Q13_2 ="Neither agree nor disagree") AT_oHapy = 3. if (Q13_2 ="Strongly agree") AT_oHapy = 5. if (Q13_3 ="Agree Somewhat") at_obey = 4. if (Q13_3 ="Disagree Somewhat") at_obey = 2. if (Q13_3 ="Disagree strongly") at_obey = 1. if (Q13_3 ="DK / Refused") at_obey = 9. if (Q13_3 ="Neither agree nor disagree") at_obey = 3. if (Q13_3 ="Strongly agree") at_obey = 5. if (Q13_4 ="Agree Somewhat") at_w_say = 4. if (Q13_4 ="Disagree Somewhat") at_w_say = 2. if (Q13_4 ="Disagree strongly") at_w_say = 1. if (Q13_4 ="DK / Refused") at_w_say = 9. if (Q13_4 ="Neither agree nor disagree") at_w_say = 3. if (Q13_4 ="Strongly agree") at_w_say = 5. if (Q13_5 ="Agree Somewhat") at_order = 4. if (Q13_5 ="Disagree Somewhat") at_order = 2. if (Q13_5 ="Disagree strongly") at_order = 1. if (Q13_5 ="DK / Refused") at_order = 9. if (Q13_5 ="Neither agree nor disagree") at_order = 3. if (Q13_5 ="Strongly agree") at_order = 5. if (Q13_6 ="Agree Somewhat") at_allow = 4. if (Q13_6 ="Disagree Somewhat") at_allow = 2. if (Q13_6 ="Disagree strongly") at_allow = 1. if (Q13_6 ="DK / Refused") at_allow = 9. if (Q13_6 ="Neither agree nor disagree") at_allow = 3. if (Q13_6 ="Strongly agree") at_allow = 5. * Q13_7 to Q13_18: missing. if (Q13_19 ="Agree Somewhat") at_letMe = 4. if (Q13_19 ="Disagree Somewhat") at_letMe = 2. if (Q13_19 ="Disagree strongly") at_letMe = 1. if (Q13_19 ="DK / Refused") at_letMe = 9. if (Q13_19 ="Neither agree nor disagree") at_letMe = 3. if (Q13_19 ="Strongly agree") at_letMe = 5. if (Q13_20 ="Agree Somewhat") at_sEarn = 4. if (Q13_20 ="Disagree Somewhat") at_sEarn = 2. if (Q13_20 ="Disagree strongly") at_sEarn = 1. if (Q13_20 ="DK / Refused") at_sEarn = 9. if (Q13_20 ="Neither agree nor disagree") at_sEarn = 3. if (Q13_20 ="Strongly agree") at_sEarn = 5. if (Q13_21 ="Agree Somewhat") at_roles = 4. if (Q13_21 ="Disagree Somewhat") at_roles = 2. if (Q13_21 ="Disagree strongly") at_roles = 1. if (Q13_21 ="DK / Refused") at_roles = 9. if (Q13_21 ="Neither agree nor disagree") at_roles = 3. if (Q13_21 ="Strongly agree") at_roles = 5. if (Q13_22 ="Agree Somewhat") at_iEarn = 4. if (Q13_22 ="Disagree Somewhat") at_iEarn = 2. if (Q13_22 ="Disagree strongly") at_iEarn = 1. if (Q13_22 ="DK / Refused") at_iEarn = 9. if (Q13_22 ="Neither agree nor disagree") at_iEarn = 3. if (Q13_22 ="Strongly agree") at_iEarn = 5. if (Q13_23 ="Agree Somewhat") at_okHit = 4. if (Q13_23 ="Disagree Somewhat") at_okHit = 2. if (Q13_23 ="Disagree strongly") at_okHit = 1. if (Q13_23 ="DK / Refused") at_okHit = 9. if (Q13_23 ="Neither agree nor disagree") at_okHit = 3. if (Q13_23 ="Strongly agree") at_okHit = 5. if (Q13_24 ="Agree Somewhat") at_putUp = 4. if (Q13_24 ="Disagree Somewhat") at_putUp = 2. if (Q13_24 ="Disagree strongly") at_putUp = 1. if (Q13_24 ="DK / Refused") at_putUp = 9. if (Q13_24 ="Neither agree nor disagree") at_putUp = 3. if (Q13_24 ="Strongly agree") at_putUp = 5. *freq at_putup. /* New variable, in 2017. if (Q14 = "Don’t know / Can’t say") control = 9. if (Q14 = "Equal control") control = 3. if (Q14 = "Most control") control = 4. if (Q14 = "No control") control = 1. if (Q14 = "Some control") control = 2. if (Q14 = "Total control") control = 5. if (Q15_1 = "DK/CS") AT_DIV_D = 9. if (Q15_1 = "NO") AT_DIV_D = 2. if (Q15_1 = "YES") AT_DIV_D = 1. if (Q15_2 = "DK/CS") AT_DIV_V = 9. if (Q15_2 = "NO") AT_DIV_V = 2. if (Q15_2 = "YES") AT_DIV_V = 1. if (Q15_3 = "DK/CS") AT_DIV_U = 9. if (Q15_3 = "NO") AT_DIV_U = 2. if (Q15_3 = "YES") AT_DIV_U = 1. if (Q16atoQ16e_1 = "DK/CS") argument = -9. if (Q16atoQ16e_1 = "NO") argument = 2. if (Q16atoQ16e_1 = "YES") argument = 1. if (Q16atoQ16e_2 = "DK/CS") viol_hit = -9. if (Q16atoQ16e_2 = "NO") viol_hit = 2. if (Q16atoQ16e_2 = "YES") viol_hit = 1. if (Q16atoQ16e_3 = "DK/CS") violHitB = -9. if (Q16atoQ16e_3 = "NO") violHitB = 2. if (Q16atoQ16e_3 = "YES") violHitB = 1. if (Q16atoQ16e_4 = "DK/CS") vioM_hit = -9. if (Q16atoQ16e_4 = "NO") vioM_hit = 2. if (Q16atoQ16e_4 = "YES") vioM_hit = 1. if (Q16atoQ16e_5 = "DK/CS") vioMHitB = -9. if (Q16atoQ16e_5 = "NO") vioMHitB = 2. if (Q16atoQ16e_5 = "YES") vioMHitB = 1. recode argument viol_hit violHitB vioM_hit vioMHitB (1=1)(2=0)(-9 = -9). value labels argument viol_hit violHitB vioM_hit vioMHitB 0 'no' 1 'yes'. recode viol_hit violHitB vioM_hit vioMHitB (sysmis= -33). if (argument=0 & viol_hit < 0) viol_hit = 0. if (argument=0 & violHitB < 0) violHitB = 0. if (argument=0 & vioM_hit < 0) vioM_hit = 0. if (argument=0 & vioMHitB< 0) vioMHitB = 0. recode viol_hit violHitB vioM_hit vioMHitB ( -33=sysmis). freq viol_hit violHitB vioM_hit vioMHitB. if (Q17 = "Buddhism") religion = 5. if (Q17 = "Christian") religion = 4. if (Q17 = "Do not believe in religion") religion = 9. if (Q17 = "Hindu") religion = 1. if (Q17 = "Jainism") religion = 6. if (Q17 = "Muslim") religion = 2. if (Q17 = "Others") religion = 10. if (Q17 = "Parsis / Zoroastrism") religion = 7. if (Q17 = "Sikh") religion = 3. if (Q17oth="convert christain") religion = 4. if (Q17oth="hindu") religion = 1. * I don't understand these answers to Q17oth: bengali Gujrathi kannad telgu. if (QQ1_1 = "Not present") presSpou = 2. if (QQ1_1 = "Present") presSpou = 1. if (QQ1_2 = "Not present") presAdul = 2. if (QQ1_2 = "Present") presAdul = 1. if (QQ1_3 = "Not present") presKids = 2. if (QQ1_3 = "Present") presKids = 1. if (QQ2 = "Bungalow / independent house") homeType = 1. if (QQ2 = "Flat") homeType = 2. if (QQ2 = "Kuchcha jhuggi / JJ Colony") homeType = 3. if (QQ2 = "Pavement dweller") homeType = 5. if (QQ2 = "Pucca jhuggi / JJ colony") homeType = 4. if (QQ3 = "Female") INTfemal = 2. if (QQ3 = "Male" ) INTfemal = 1. if (SECold = "SEC A1") IMRBclas = 1 . if (SECold = "SEC A2") IMRBclas = 2 . if (SECold = "SEC B1") IMRBclas = 3 . if (SECold = "SEC B2") IMRBclas = 4 . if (SECold = "SEC C" ) IMRBclas = 5 . if (SECold = "SEC D" ) IMRBclas = 6 . if (SECold = "SEC E1") IMRBclas = 7 . if (SECold = "SEC E2") IMRBclas = 8 . val lab IMRBclas 1 'A1' 2 'A2' 1.5 'AB' 2.1 'A3' 3 'B1' 4 'B2' 5 'C' 5.1 'C1' 5.2 'C2' 6 'D' 6.1 'D1' 6.2 'D2' 7 'E1' 8 'E2' 9 'E3'. * IMRB redefined their definition of social class in 2011. It is fairly similar to earlier years; but there are now more codes: A3, D1, D2, and E3. SECnew is available in 2017. if (Q3a="Yes") resp_HoH = 1. if (Q3a="No") resp_HoH = 0. val lab resp_HoH 1 'respondent is HoH' 0 'respondent is spouse of HoH'. /* To be precise, this is 'Chief Wage Earner' (which I assume is the head-of-household). *frequencies managMon finalSay at_final. recode MANAGmon FINALsay,AT_final (7 thru hi = sysmis). /* India 2012 only: I don't know what codes 7 to 13 mean; I could ask IMRB. recode MANAGmon (1=1.1)(2=1.2)(3=2)(4= 3 )(5=5)(6= -1). recode FINALsay,AT_final (1=1.1)(2=1.2)(3=2)(4= 999 )(5=5)(6= -1). value label MANAGmon FINALsay,AT_final p1_relat,p2_relat,p3_relat,p4_relat,p5_relat,p6_relat,p7_relat,p8_relat,p9_relat,p10relat, p11relat,p12relat,p13relat 200"Grandparent" 210"Great-aunt/uncle" 201"Grandparent of spouse" 100"Parent" 110"Aunt/uncle" 101"Parent of spouse" 111"Aunt/uncle of spouse" 102"Parent's spouse (step-parent)" 000"Respondent" 010"Sibling" 030"Cousin" 001"Respondent's spouse" 011"Sibling's spouse" 021"Spouse's sibling" 012"Brother/sister-in-law" -100"Child" -103"adopted child" -110"Nephew/neice" -101"Child of spouse" -121"Nephew/neice of spouse" -102"Child's spouse" -200"Grandchild" -210"Great-nephew/neice" -201"Grandchild of spouse" -221"Spouse's sib's grandchild" 991 "head-of-household" 992 "main earner" -300"Great-grandchild" 993 "all in household" 994 "self & other(s), e.g. self & child" 995 "non-relative, e.g. friend or lodger" 996 "other(s): unspecified" 997 "other in-law; or spouse & in-law(s)" 998 "other relative(s)" 999 "elders, e.g. parents" 1.1 "husband", 1.2 "wife" 2 "husband & wife together" 3 "husband & wife separately" 4 "husband's 2nd wife" 5 "other, not just husband & wife" 801 "child's parents" 802 "no children in hh" 803 "maid/baby-sitter" -3 "no earnings". * Make LIVE_cit compatible with bm92 & bmdc97 & bmdcpk2002 & 2007. recode LIVE_cit (1=1)(2=4)(3=3)(4=2)(5=7)(6=8)(7=6)(8=5)(9=9)(10=10)(11=11). val lab LIVE_cit 1 'Mumbai (Bombay)' 2 'Chennai (Madras)' 3 'Delhi' 4 'Kolkatta (Calcutta)' 5 'Patna' 6 'Kochi (Kerala)' 7 'Ahmedabad' 8 'Lucknow' 9 'Bhubhneshwar' 10 'Ludhiana' 11 'Vijayawada'. freq LIVE_cit. *recode resp_HoH (sysmis = 0). /* It's not clear if missing data means spouse, or some other relative. *var labels resp_HoH "If respondent is the head-of-household". /* This is CWE, in IMRB 2012. *value labels resp_HoH 1 "Respondent is the HoH" 0 "Respondent is spouse of HoH" -4 "Respondent is neither HoH or spouse". recode skipMeal (4=0)(3=1)(2=2)(1=3)(9= -1). var label skipMeal 'Frequency of cutting meals in the last year'. val labels skipMeal 0'never' 1'only 1 or 2 months' 2'some months, but not every month' 3'almost every month'. recode PAID_hus COOK_hus SHOP_hus LAUNDhus CLOTHhus CLEANhus MIND_hus LEISUhus PAID_wif COOK_wif SHOP_wif LAUNDwif CLOTHwif CLEANwif MIND_wif LEISUwif (99=sysmis). *cros PAID_hus COOK_hus SHOP_hus LAUNDhus CLOTHhus CLEANhus MIND_hus LEISUhus PAID_wif COOK_wif SHOP_wif LAUNDwif CLOTHwif CLEANwif MIND_wif LEISUwif by live_cit. cros COOK_hus by live_cit. * The next line is for India2007: very few cases have zero time-use data in Madras,& few for Bombay. Set all missing=zero (risk of counting "don't know" as zero). All respondents are married. *recode PAID_hus COOK_hus SHOP_hus LAUNDhus CLOTHhus CLEANhus MIND_hus LEISUhus PAID_wif COOK_wif SHOP_wif LAUNDwif CLOTHwif CLEANwif MIND_wif LEISUwif (sysmis=0). var label PAID_HUS "Hours of paid work (per week): self/husband". var label PAID_WIF "Hours of paid work (per week): self/wife". var label COOK_HUS 'Hours spent cooking (per week): self/husband'. var label COOK_WIF 'Hours spent cooking (per week): self/wife'. var label SHOP_HUS 'Hours spent shopping (per week): self/husband'. var label SHOP_WIF 'Hours spent shopping (per week): self/wife'. var label laundHUS 'Hours spent cleaning clothes (per week): self/husband'. var label laundWIF 'Hours spent cleaning clothes (per week): self/wife'. var label clothHUS 'Hours making/mending clothes (per week): self/husband'. var label clothWIF 'Hours making/mending clothes (per week): self/wife'. var label cleanHUS 'Hours spent cleaning home (per week): self/husband'. var label cleanWIF 'Hours spent cleaning home (per week): self/wife'. var label MIND_HUS 'Hours spent minding children (per week): self/husband'. var label MIND_WIF 'Hours spent minding children (per week): self/wife'. var label leisuHUS 'Hours spent on leisure (per week): self/husband'. var label leisuWIF 'Hours spent on leisure (per week): self/wife'. *freq earn_hus earn_wif. recode earn_hus earn_wif HHincome (0=0)(1=250)(2=625)(3=875)(4=1250)(5=1750)(6=2250)(7=2750)(8=3500)(9=4500)(10=5500) (11=7000)(12=9000)(13=12500)(14=17500)(15=25000)(16=35000)(17=45000)(18=60000) (99=sysmis). var lab earn_hus "Husband's earnings (Rupees per month)". /* IMRB's variable label is misleading, so use this. var lab earn_wif "Wife's earnings (Rupees per month)". /* IMRB's variable label is misleading, so use this. * Like BM92, assume income at midpoint of each range. Assume last (open) interval is twice as wide as the previous income band, as some statistics textbooks suggest. compute sp_FOOD = sp_cerea+sp_dairy +sp_veget+sp_meatF+sp_oil +sp_bread +sp_insta +sp_snack. compute sp_TOTAL = sp_FOOD +sp_drink +sp_tobac+sp_fmeal +sp_cloth +sp_gambl +sp_gas +sp_el_wa+sp_rent +sp_maid +sp_laund +sp_trans +sp_phone. compute sp_ENERG = sp_gas +sp_el_wa. var label sp_cerea 'HH spending (per month): cereals eg rice, corn, wheat flour'. var label sp_dairy 'HH spending (per month): milk, dairy products, milk food drinks'. var label sp_veget 'HH spending (per month): vegetables/fruit'. var label sp_meatF 'HH spending (per month): meat and fish'. var label sp_oil 'HH spending (per month): cooking oil, margerine'. var label sp_bread 'HH spending (per month): bread, chapattis, roti, etc'. var label sp_insta 'HH spending (per month): instant foods'. var label sp_drink 'HH spending (per month): alcoholic drinks'. var label sp_tobac 'HH spending (per month): tobacco'. var label sp_Fmeal 'HH spending (per month): restaurant meals'. var label sp_snack 'HH spending (per month): snacks from street-stalls'. var label sp_cloth 'HH spending (per month): clothes/footwear inc repairs'. var label sp_FOOD 'HH spending (per month): ALL FOOD excluding restauraunts'. var label sp_gambl 'HH spending (per month): gambling, lottery'. var label sp_gas 'HH spending (per month): gas/kerosene'. var label sp_el_wa 'HH spending (per month): electricity + water'. var label sp_ENERG 'HH spending (per month): gas+electricity'. var label sp_rent 'HH spending (per month): house rent/costs'. var label sp_maid 'HH spending (per month): servant/maid'. var label sp_laund 'HH spending (per month): laundry services'. var label sp_trans 'HH spending (per month): transport'. var label sp_phone 'HH spending (per month): telephone bill (including mobile)'. var label sp_TOTAL 'Total HH spending (per month)'. compute married = 1. value label married 1 'married'. variable label married 'Marital status of respondent'. recode canGoOut (4=0)(3=30)(2=50)(1=100) (9= -1). value labels canGoOut 0"can't go out at all" 30"can go with another adult" 50"can go with children" 100"can go alone". recode AT_jbSGL AT_jbNOK AT_jbINF AT_jbKID (4= -1). *freq AT_jbSG L AT_jbNOK AT_jbINF AT_jbKID. * CHANGE THE DEFINITION OF ATTITUDE VARIABLES, for 'derive_variables.sps': in other WAS surveys, all Likert scale variables use 1'totally agree' to 5'totally disagree'. Make India 2012 match. recode at_wHapy,at_oHapy,at_obey,at_w_say at_order at_allow at_letMe at_sEarn at_roles at_iEarn AT_okHit at_putUp (1=5)(2=4)(3=3)(4=2)(5=1) (9= -1). value labels at_wHapy,at_oHapy,at_obey,at_w_say at_order at_allow at_letMe at_sEarn at_roles at_iEarn AT_okHit at_putUp 1'agree strongly' 2'agree' 3'neither agree/disagree' 4'disagree' 5'disagree strongly'. recode CONTROL (1=0)(2=25)(3=50)(4=75)(5=100)(9= -1). /* Make control consistent with SA2000 data. value label CONTROL 0 'no control' 15 'little control' 25 'some control' 35 'some control' 50 'equal control' 65 'a lot of control' 75 'most of the control' 85 'most of the control' 100 'complete control'. /* 25 & 75 for IN & NG & EG only; 15, 35, 65 & 85 only for other WAS surveys. *cros CONTROL by r_sex /cells col. recode AT_DIV_D AT_DIV_V AT_DIV_U (1=1)(2=0)(9 = -1). value labels AT_DIV_D AT_DIV_V AT_DIV_U 1 'yes' 0 'no' -1 'DK/CS'. *cros AT_DIV_V by at_okhit /cells col. /* Surprisingly weak link between these vars. Control for kids in HH?. recode RELIGION (1=50)(2=30)(3=51)(4=10)(5=60)(6=61)(7=70)(8=40)(9=0)(10 thru hi=90). value labels RELIGION 0'No religion/atheist' 10'Christian (unspecified)' 11'Protestant' 12'Presbyterian' 13'Evangelical/Wesleyan/Baptist' 14'Messianica' 15'Christa do reino de Deus' 16'7th Day Adventist' 18'Orthodox' 19'Roman Catholic' 20'Christian-related' 21'Rosicrucian' 22'Mormon' 23"Jehovah's Witness" 30'Muslim' 40'Jewish' 50'Hindu/Vaisnavist' 51'Sikh' 60'Buddhist' 61'Jain' 70'Parsi/Zoroastrian' 80'Animist (unspecified)' 81'Traditional African' 82'Independent African' 83'Candomble' 84'Umbanda' 89'Spiritualist' 90'Other (unspecified)' 91'Soicho-Noye (Brazil)' 92'Teluja (India)' 93'Koli (India)' 94'Nepali (India)'. if (presSpou=2 and presAdul=2 and presKids=2) INT_PRES=1. if (presSpou=1 and presAdul=2 and presKids=2) INT_PRES=2. if (presSpou=2 and presAdul=1 and presKids=2) INT_PRES=3. if (presSpou=2 and presAdul=2 and presKids=1) INT_PRES=4. if (presSpou=1 and presAdul=1 and presKids=2) INT_PRES=5. if (presSpou=1 and presAdul=2 and presKids=1) INT_PRES=6. if (presSpou=2 and presAdul=1 and presKids=1) INT_PRES=7. if (presSpou=1 and presAdul=1 and presKids=1) INT_PRES=8. var label INT_PRES 'If anyone except respondent present at interview, who?'. val label INT_PRES 1'resp only' 2'spouse' 3'other adult(s)' 4'child(ren)' 5'spouse and other adult' 6'spouse & child(ren)' 7'children/other adult' 8'spouse/child/other'. * Could use phone to assess if home is permanent - but home with a phone number could have a mobile phone. recode hometype (1=100)(2=90)(3=20)(4=10)(5=0) (6=sysmis). val lab hometype 100 'bungalow/independent house' 90 'flat' 20 'pukka house' 10 'kuchcha house' 0 'pavement dweller'. *breakdown HHincome by hometype. *breakdown sp_rent by hometype. /* suspicious: why are pavement dwellers spending so much on rent?. compute INT_year = 2017. var label INT_year 'Year of interview'. compute INT_mnth = 9. /* Some may have been in August? Check with IMRB. var label INT_mnth 'Month of interview'. * zzz add this. *var label INT_day 'Day of month of interview'. * zzz add this. recode INTfemal (1=0)(2=1). var label INTfemal 'Gender of interviewer'. val label INTfemal 0 'male interviewer' 1 'female interviewer'. * add INT_lang: . *recode INT_lang (1= 60208009.02)(2= 60203013.11)(3=60203011.01)(4=60203017.01)(5=110202022.01)(6=110202013.01) (7=110202022.02)(8=60203013.08)(9 10 11= -9). *val lab INT_lang 60203011.01 "INDO-HITTITE {INDO-EUROPEAN} INDO-IRANIAN: Marathi" 60203013.08 "INDO-HITTITE {INDO-EUROPEAN} INDO-IRANIAN: Gujarati" 60203013.11 "INDO-HITTITE {INDO-EUROPEAN} INDO-IRANIAN: Hindi" 60203017.01 "INDO-HITTITE {INDO-EUROPEAN} INDO-IRANIAN: Bengali" 60208009.02 "INDO-HITTITE {INDO-EUROPEAN} GERMANIC: English" 110202013.01 "ELAMO-DRAVIDIAN {DRAVIDIAN} DRAVIDIAN PROPER: Telugu" 110202022.01 "ELAMO-DRAVIDIAN {DRAVIDIAN} DRAVIDIAN PROPER: Tamil" 110202022.02 "ELAMO-DRAVIDIAN {DRAVIDIAN} DRAVIDIAN PROPER: Malayalam" -9 "other". *freq int_lang.