* NOTE: You need to set the Stata working directory to the path * where the data file is located. set more off clear quietly infix /// float perwt 1-10 /// byte nchild 11-11 /// byte eldch 12-13 /// byte relate 14-15 /// int related 16-19 /// byte sex 20-20 /// int age 21-23 /// byte marst 24-24 /// byte marrno 25-25 /// int yrmarr 26-29 /// byte hispan 30-30 /// int hispand 31-33 /// byte citizen 34-34 /// byte racamind 35-35 /// byte racasian 36-36 /// byte racblk 37-37 /// byte racpacis 38-38 /// byte educ 39-40 /// int educd 41-43 /// byte empstat 44-44 /// byte empstatd 45-46 /// byte uhrswork 47-48 /// int poverty 49-51 /// byte diffrem 52-52 /// byte diffphys 53-53 /// byte diffmob 54-54 /// byte diffcare 55-55 /// byte diffsens 56-56 /// byte empstat_sp 57-57 /// byte uhrswork_sp 58-59 /// using "[FILENAME]" replace perwt = perwt / 100 format perwt %10.2f label var perwt "Person weight" label var nchild "Number of own children in the household" label var eldch "Age of eldest own child in household" label var relate "Relationship to household head [general version]" label var related "Relationship to household head [detailed version]" label var sex "Sex" label var age "Age" label var marst "Marital status" label var marrno "Times married" label var yrmarr "Year married" label var hispan "Hispanic origin [general version]" label var hispand "Hispanic origin [detailed version]" label var citizen "Citizenship status" label var racamind "Race: American Indian or Alaska Native" label var racasian "Race: Asian" label var racblk "Race: black or African American" label var racpacis "Race: Pacific Islander" label var educ "Educational attainment [general version]" label var educd "Educational attainment [detailed version]" label var empstat "Employment status [general version]" label var empstatd "Employment status [detailed version]" label var uhrswork "Usual hours worked per week" label var poverty "Poverty status" label var diffrem "Cognitive difficulty" label var diffphys "Ambulatory difficulty" label var diffmob "Independent living difficulty" label var diffcare "Self-care difficulty" label var diffsens "Vision or hearing difficulty" label var empstat_sp "Employment status [of spouse; general version]" label var uhrswork_sp "Usual hours worked per week [of spouse]" label define nchild_lbl 0 "0 children present" label define nchild_lbl 1 "1 child present", add label define nchild_lbl 2 "2", add label define nchild_lbl 3 "3", add label define nchild_lbl 4 "4", add label define nchild_lbl 5 "5", add label define nchild_lbl 6 "6", add label define nchild_lbl 7 "7", add label define nchild_lbl 8 "8", add label define nchild_lbl 9 "9+", add label values nchild nchild_lbl label define relate_lbl 01 "Head/Householder" label define relate_lbl 02 "Spouse", add label define relate_lbl 03 "Child", add label define relate_lbl 04 "Child-in-law", add label define relate_lbl 05 "Parent", add label define relate_lbl 06 "Parent-in-Law", add label define relate_lbl 07 "Sibling", add label define relate_lbl 08 "Sibling-in-Law", add label define relate_lbl 09 "Grandchild", add label define relate_lbl 10 "Other relatives", add label define relate_lbl 11 "Partner, friend, visitor", add label define relate_lbl 12 "Other non-relatives", add label define relate_lbl 13 "Institutional inmates", add label values relate relate_lbl label define sex_lbl 1 "Male" label define sex_lbl 2 "Female", add label values sex sex_lbl label define marst_lbl 1 "Married, spouse present" label define marst_lbl 2 "Married, spouse absent", add label define marst_lbl 3 "Separated", add label define marst_lbl 4 "Divorced", add label define marst_lbl 5 "Widowed", add label define marst_lbl 6 "Never married/single", add label values marst marst_lbl label define marrno_lbl 0 "Not Applicable" label define marrno_lbl 1 "Married once", add label define marrno_lbl 2 "Married twice (or more)", add label define marrno_lbl 3 "Married thrice (or more)", add label define marrno_lbl 4 "Four times", add label define marrno_lbl 5 "Five times", add label define marrno_lbl 6 "Six times", add label define marrno_lbl 7 "Unknown", add label define marrno_lbl 8 "Illegible", add label define marrno_lbl 9 "Missing", add label values marrno marrno_lbl label define hispan_lbl 0 "Not Hispanic" label define hispan_lbl 1 "Mexican", add label define hispan_lbl 2 "Puerto Rican", add label define hispan_lbl 3 "Cuban", add label define hispan_lbl 4 "Other", add label define hispan_lbl 9 "Not Reported", add label values hispan hispan_lbl label define citizen_lbl 0 "N/A" label define citizen_lbl 1 "Born abroad of American parents", add label define citizen_lbl 2 "Naturalized citizen", add label define citizen_lbl 3 "Not a citizen", add label define citizen_lbl 4 "Not a citizen, but has received first papers", add label define citizen_lbl 5 "Foreign born, citizenship status not reported", add label values citizen citizen_lbl label define racamind_lbl 1 "No" label define racamind_lbl 2 "Yes", add label values racamind racamind_lbl label define racasian_lbl 1 "No" label define racasian_lbl 2 "Yes", add label values racasian racasian_lbl label define racblk_lbl 1 "No" label define racblk_lbl 2 "Yes", add label values racblk racblk_lbl label define racpacis_lbl 1 "No" label define racpacis_lbl 2 "Yes", add label values racpacis racpacis_lbl label define educd_lbl 000 "N/A or no schooling" label define educd_lbl 001 "N/A", add label define educd_lbl 002 "No schooling completed", add label define educd_lbl 010 "Nursery school to grade 4", add label define educd_lbl 011 "Nursery school, preschool", add label define educd_lbl 012 "Kindergarten", add label define educd_lbl 013 "Grade 1, 2, 3, or 4", add label define educd_lbl 014 "Grade 1", add label define educd_lbl 015 "Grade 2", add label define educd_lbl 016 "Grade 3", add label define educd_lbl 017 "Grade 4", add label define educd_lbl 020 "Grade 5, 6, 7, or 8", add label define educd_lbl 021 "Grade 5 or 6", add label define educd_lbl 022 "Grade 5", add label define educd_lbl 023 "Grade 6", add label define educd_lbl 024 "Grade 7 or 8", add label define educd_lbl 025 "Grade 7", add label define educd_lbl 026 "Grade 8", add label define educd_lbl 030 "Grade 9", add label define educd_lbl 040 "Grade 10", add label define educd_lbl 050 "Grade 11", add label define educd_lbl 060 "Grade 12", add label define educd_lbl 061 "12th grade, no diploma", add label define educd_lbl 062 "High school graduate or GED", add label define educd_lbl 063 "Regular high school diploma", add label define educd_lbl 064 "GED or alternative credential", add label define educd_lbl 065 "Some college, but less than 1 year", add label define educd_lbl 070 "1 year of college", add label define educd_lbl 071 "1 or more years of college credit, no degree", add label define educd_lbl 080 "2 years of college", add label define educd_lbl 081 "Associates degree, type not specified", add label define educd_lbl 082 "Associates degree, occupational program", add label define educd_lbl 083 "Associates degree, academic program", add label define educd_lbl 090 "3 years of college", add label define educd_lbl 100 "4 years of college", add label define educd_lbl 101 "Bachelors degree", add label define educd_lbl 110 "5+ years of college", add label define educd_lbl 111 "6 years of college (6+ in 1960-1970)", add label define educd_lbl 112 "7 years of college", add label define educd_lbl 113 "8+ years of college", add label define educd_lbl 114 "Masters degree", add label define educd_lbl 115 "Professional degree beyond a bachelors degree", add label define educd_lbl 116 "Doctoral degree", add label define educd_lbl 999 "Missing", add label values educd educd_lbl label define empstat_lbl 0 "N/A" label define empstat_lbl 1 "Employed", add label define empstat_lbl 2 "Unemployed", add label define empstat_lbl 3 "Not in labor force", add label values empstat empstat_lbl label define empstatd_lbl 00 "N/A" label define empstatd_lbl 10 "At work", add label define empstatd_lbl 11 "At work, public emerg", add label define empstatd_lbl 12 "Has job, not working", add label define empstatd_lbl 13 "Armed forces", add label define empstatd_lbl 14 "Armed forces--at work", add label define empstatd_lbl 15 "Armed forces--not at work but with job", add label define empstatd_lbl 20 "Unemployed", add label define empstatd_lbl 21 "Unemp, exper worker", add label define empstatd_lbl 22 "Unemp, new worker", add label define empstatd_lbl 30 "Not in Labor Force", add label define empstatd_lbl 31 "NILF, housework", add label define empstatd_lbl 32 "NILF, unable to work", add label define empstatd_lbl 33 "NILF, school", add label define empstatd_lbl 34 "NILF, other", add label values empstatd empstatd_lbl label define diffrem_lbl 0 "N/A" label define diffrem_lbl 1 "No cognitive difficulty", add label define diffrem_lbl 2 "Has cognitive difficulty", add label values diffrem diffrem_lbl label define diffphys_lbl 0 "N/A" label define diffphys_lbl 1 "No ambulatory difficulty", add label define diffphys_lbl 2 "Has ambulatory difficulty", add label values diffphys diffphys_lbl label define diffmob_lbl 0 "N/A" label define diffmob_lbl 1 "No independent living difficulty", add label define diffmob_lbl 2 "Has independent living difficulty", add label values diffmob diffmob_lbl label define diffcare_lbl 0 "N/A" label define diffcare_lbl 1 "No", add label define diffcare_lbl 2 "Yes", add label values diffcare diffcare_lbl label define diffsens_lbl 0 "N/A" label define diffsens_lbl 1 "No vision or hearing difficulty", add label define diffsens_lbl 2 "Has vision or hearing difficulty", add label values diffsens diffsens_lbl label define empstat_sp_lbl 0 "N/A" label define empstat_sp_lbl 1 "Employed", add label define empstat_sp_lbl 2 "Unemployed", add label define empstat_sp_lbl 3 "Not in labor force", add label values empstat_sp empstat_sp_lbl /* ipums case selections: age 18+ nchild>0 married spouse present */ keep if marrno==1 /* limit to first marriages */ gen ftjob = 0 replace ftjob = 1 if empstat==1 & uhrswork >34 gen spftjob = 0 replace spftjob = 1 if empstat_sp ==1 & uhrswork_sp>34 gen jobnorm=0 replace jobnorm=1 if ftjob==1 | spftjob==1 gen hsgrad = 0 replace hsgrad =1 if educd >61 gen badeg = 0 replace badeg = 1 if educd >=101 gen forborn = 0 replace forborn = 1 if citizen >1 gen poor = 0 replace poor = 1 if poverty<100 gen kidyr = 2013-eldch /* year eldest (present) child was born */ gen marbirth = 0 replace marbirth = 1 if kidyr >= yrmarr /* born during or after year of marriage */ gen par21p =0 replace par21p = 1 if (age-eldch)>20 /* born at age 21 or greater */ gen parnorm=0 replace parnorm=1 if marbirth==1 & par21p ==1 gen intwt = int(100*perwt) /* analysis */ tab2 parnorm poor if hsgrad==1 & jobnorm==1 & eldch<18 [weight=intwt], nofreq row logit poor i.marbirth i.par21p i.hsgrad i.jobnorm i.badeg age i.sex i.nchild i.hispan i.forborn i.racamind i.racasian i.racblk i.racpacis uhrswork uhrswork_sp i.diffrem i.diffphys i.diffmob i.diffcare i.diffsens if eldch<18, or margins i.marbirth i.par21p i.hsgrad i.jobnorm i.badeg i.sex i.nchild i.hispan i.forborn i.racamind i.racasian i.racblk i.racpacis i.diffrem i.diffphys i.diffmob i.diffcare i.diffsens, atmeans