marital_spouselinks DDI-MWI-MEIRU-SPOUSELINKS-2002-v01 Malawi Epidemiology and Intervention Research Unit Estelle McLean Chifundo Kanjala Jacky Saul Kieth Branson Joseph Kamanga Dominic Nzundah 2020-07-23 Nesstar Publisher version 1 (July, 2020) Cleaned spouse and marriage data MWI-MEIRU-SPOUSELINKS-2002-v01 Professor Amelia (Mia) Crampin Nesstar Publisher Sample Survey Malawi Individual Malawi Epidemiology and Intervention Research Unit Face-to-face [f2f] MEIRU Malawi Epidemiology and Intervention Research Unit all_marital_reports.NSDstat 263339 16 Nesstar 200801 Malawi Epidemiology and Interventions Research Unit all_spouse_pairs_full.NSDstat 196403 33 Nesstar 200801 Malawi Epidemiology and Interventions Research Unit all_spouse_pairs_clean_summarised.NSDstat 22800 32 Nesstar 200801 Malawi Epidemiology and Interventions Research Unit marital_status_episodes.NSDstat 134177 32 Nesstar 200801 Malawi Epidemiology and Interventions Research Unit Unique identifier 263339 0 Unique identifier variable: ident (table[s]: ahs_ahs1, cen_individ, crs_cenm, gp_gpform, css_sei, tb_tbh, tb_tbo, tb_tboto2007, tb_tbx, tb_tbxto2007) Date of interview 263339 Date of interview variable: intdate (table[s]: ahs_ahs1, cen_individ, crs_cenm, gp_gpform, css_sei, tb_tbh, tb_tbo, tb_tboto2007, tb_tbx, tb_tbxto2007) Source of data (D) 263339 0 Source of data 263339 0 From population representative survey Self or proxy report (D) 263195 144 Self or proxy report -1 Unknown 1165 0 Proxy-report 210895 1 Self-report 51135 Sysmiss 144 gen slf=1 recode slf .=-1 replace slf=0 if self==0 | informtid~="" replace slf=1 if self==1 recode slf .=-1 replace slf=0 if self==0 | (infmtype~=. & infmtype~=6) //6=self replace slf=1 if self==1 | infmtype==6 recode slf .=-1 replace slf=0 if self==0 | informtid~="" replace slf=1 if self==1 recode slf .=-1 replace slf=0 if infmtype2~=1 & infmtype2~=99 & infmtype~=6 replace slf=1 if infmtype2==1 | infmtype==6 recode slf .=-1 replace slf=0 if self==0 replace slf=1 if self==1 recode slf .=-1 replace slf=0 if self==0 replace slf=1 if self==1 recode slf .=-1 replace slf=0 if (relinform~=8 & relinform~=.) | informtid~="" replace slf=1 if relinform==8]]> Marital status (D) 259912 3427 Marital status 0 Never married 84882 1 Married 141125 2 Divorced/separated 18136 3 Widowed 15769 4 N/A (dead) 0 8 Unknown 0 9 Missing 3414 Sysmiss 13 =1 & spoucur~=. & marital==. replace marital=2 if spoucur==0 & spoupast>=1 & spoupast~=. & marital==. replace marital=0 if maridill==0 /*just assumed that not married is never married for these ones for now*/ replace marital=1 if maridill==1 replace marital=1 if idspouse~="" & marendyr==.]]> Number of current spouses (D) 112388 150951 Number of current spouses 97 Not applicable 98 Unknown 99 Missing Spouse id (1) 138401 0 Spouse id Spouse id (2) 11388 0 Spouse id Spouse id (3) 1827 0 Spouse id Spouse id (4) 382 0 Spouse id Spouse id (5) 26 0 Spouse id Spouse id (6) 8 0 Spouse id Spouse id (7) 6 0 Spouse id Spouse id (8) 2 0 Spouse id Spouse id (9) 1 0 Spouse id Unique identifier of wife (D) 196403 0 Unique identifier of wife Unique identifier of husband (D) 196403 0 Type of data (D) 196403 0 Type of data 1 marstatus 158094 2 residency 38309 Created when making the separate datasets and appending them together. Summary date for record (D) 196403 Union ever reported by (D) 193050 3353 Union ever reported by 1 wife 12540 2 husband 2958 3 both 177552 Sysmiss 3353 Both partners report the union at least once (D) 193050 3353 Age difference between spouses (D) 196385 18 Union has same sex error (D) 196403 0 Union has under 12 years error (D) 196403 0 Union has under 12 years error Union has incest error (D) 196403 0 Partners ever CRS members (D) 188811 7592 1 wife 7473 2 husband 774 3 both 180564 Sysmiss 7592 use ${gendata}\crs_residency_episodes_clean_nopoly, clear bys ident: egen lastincrs=max(stopdate) bys ident (stopdate): gen laststop=stoptype[_N] format %td lastincrs keep ident lastincrs laststop duplicates drop gen crs=1 save ${tempfiles}\allcrsmembers, replace merge m:1 ident using ${tempfiles}\allcrsmembers, keep(master match) keepusing(crs) nogen merge m:1 ident using ${tempfiles}\indices_lafd, keep(master match) nogen rename (ident husband lastalive firstdead crs) (wife ident w_lastalive w_firstdead w_crs) merge m:1 ident using ${tempfiles}\allcrsmembers, keep(master match) keepusing(crs) nogen merge m:1 ident using ${tempfiles}\indices_lafd, keep(master match) nogen rename (ident lastalive firstdead crs) (husband h_lastalive h_firstdead h_crs) gen crs=1 if w_crs==1 & h_crs~=1 replace crs=2 if w_crs~=1 & h_crs==1 replace crs=3 if w_crs==1 & h_crs==1 la val crs repby]]> Partnership only from co-parent link (D) 196403 0 Partnership only from co-parent link use ${newstata}\gen_identity_clean, clear replace idmoth="" if idmoth=="UUUUUUU" replace idfath="" if idfath=="UUUUUUU" keep if idmoth~="" & idfath~="" rename (idmoth idfath) (ident idspouse) gen parlink=1 recode parlink .=0 bys wife husband: egen newparlink=min(parlink)]]> Source of marstatus record (D) 158094 0 variable: ques (table[s]: all_marital_reports [derived table]) Source is population representative (D) 193050 3353 Source is population representative variable: poprep (table[s]: all_marital_reports [derived table]) Interview date of marstatus record (D) 158094 variable: date (table[s]: all_marital_reports [derived table]) Informant of marstatus record (D) 158094 38309 1 wife 85559 2 husband 72535 3 both 0 Sysmiss 38309 variable: informant (table[s]: all_marital_reports [derived table]) Whether partner reports union in same round (D) 158094 38309 0 Matched 128948 1 Missing data 25335 2 Mismatch 3811 Sysmiss 38309 foreach spouse in wife husband { preserve if "`spouse'"=="wife" { local sexi=1 local sexs=0 local S="H" } if "`spouse'"=="husband" { local sexi=0 local sexs=1 local S="W" } *create dataset of what the spouse 2 (idspouse) reports drop if ident_sex==`sexi' rename (idspouse ident marital) (x`spouse' idspouse xmarital) keep idspouse x`spouse' rd xmarital bys idspouse rd: gen n=_n sum n local max=r(max) reshape wide xmarital x`spouse' ,i(idspouse rd) j(n) save ${tempfiles}\gen_spouse_`sexs', replace restore preserve *create dataset of what spouse 1 (ident) reports and merge with the spouse 2 dataset drop if ident_sex==`sexs' drop if idspouse=="" | idspouse=="noid" merge m:1 idspouse rd using ${tempfiles}\gen_spouse_`sexs', keep(master match) nogen *create match var gen match=. forvalues x=1/`max' { replace match=0 if ident==x`spouse'`x' } replace match=1 if match==. &(xmarital1==. | (xmarital1~=0 & x`spouse'1=="")) replace match=2 if match==. & x`spouse'1~="" | xmarital1==0 lab def match 0 "Matched" 1 "Missing data" 2 "Mismatch" la val match match drop x* save ${tempfiles}\spouse_match_`sexi', replace restore }]]> Max number of spouses husband reports while in this union (D) 164160 32243 Union was ever polygamous (D) 164160 32243 Union was ever polygamous (D) Union ever reported to be current (D) 193050 3353 gen evercur=marital==1 Marriage date (15-April of reported year) (D) 118254 gen mardate=mdy(4,15,marstyr) if marstyr~=. & marstyr<9998 Last date still reported to be married (D) 139996 gen stillmardate=intdate if wife~="" & husband~="" & marendyr==. Separation date (15-Aug of reported year) (D) 15846 gen sepdate=mdy(8,15,marendyr) if marendyr~=. & marendyr<9998 Partner who moved in/out (D) 38309 158094 1 wife 6535 2 husband 2127 3 both 29647 Sysmiss 158094 use ${tempfiles}\parlinks_checked, clear *add in spouse links append using ${tempfiles}\spouse_pairs_all_data, keep(wife husband) duplicates drop drop if wife=="" | husband=="" rename wife ident *merge to residency data (wife) joinby ident using ${gendata}\crs_residency_episodes_clean_poly, unmatched(both) _merge(wifem) rename (ident startdate stopdate starttype stoptype rsnmovecenm rsnmovedep crshse) (wife w_startdate w_stopdate w_starttype w_stoptype w_rsnstart w_rsnstop w_crshse) drop sex birth_date rename husband ident joinby ident using ${gendata}\crs_residency_episodes_clean_poly, unmatched(both) _merge(husbandm) rename (ident startdate stopdate starttype stoptype rsnmovecenm rsnmovedep crshse) (husband h_startdate h_stopdate h_starttype h_stoptype h_rsnstart h_rsnstop h_crshse) drop sex birth_date keep if w_crshse==h_crshse & h_startdate~=. & h_stopdate~=. & w_startdate~=. & w_stopdate~=. & ((h_startdate>=w_startdate & h_startdate<=w_stopdate) | (h_stopdate>=w_startdate & h_stopdate<=w_stopdate) | (w_startdate>=h_startdate & w_startdate<=h_stopdate) | (w_stopdate>=h_startdate & w_stopdate<=h_stopdate)) egen resstartdt=rowmax(w_startdate h_startdate) egen resstopdt=rowmin(w_stopdate h_stopdate) format %td resstartdt resstopdt la def whost 1 "wife" 2 "husband" 3 "both" foreach st in start stop { gen who`st'=1 if res`st'dt==w_`st'date replace who`st'=2 if res`st'dt==h_`st'date replace who`st'=3 if res`st'dt==w_`st'date & res`st'dt==h_`st'date la val who`st' whost replace h_`st'rsn=. if who`st'==1 replace w_`st'rsn=. if who`st'==2 }]]> Type of residency data (D) 38309 158094 Type of residency data 1 ep end 16753 2 ep start 21556 Sysmiss 158094 Date known to be married with residency data (D) 33259 Date known to be married with residency data gen rmardate=rdate if type==2 | (type==1 & w_rsn~=2 & w_rsn~=4 & h_rsn~=2 & h_rsn~=4)]]> Date known to be separated with residency data (D) 5050 Date known to be separated with residency data gen rsepdate=rdate if type==1 & (w_rsn==2 | w_rsn==4 | h_rsn==2 | h_rsn==4)]]> Wife's reason for res ep start/stop (D) 36166 160237 Wife's reason for res ep start/stop 1 Baseline/present 11079 2 Birth/Death 343 3 Migr - marriage 9618 4 Migr - Div/Sep 3888 5 Migr - educ 97 6 Migr - work 6091 7 Migr - other 5050 Sysmiss 160237 la def strsn 1 "Baseline/present" 2 "Birth/Death" 3 "Migr - marriage" 4 "Migr - Div/Sep" 5 "Migr - educ" 6 "Migr - work" 7 "Migr - other" foreach s in w h { foreach st in start stop { gen `s'_`st'rsn=1 if `s'_`st'type==1 replace `s'_`st'rsn=2 if `s'_`st'type==2 replace `s'_`st'rsn=3 if (`s'_`st'type==3 | `s'_`st'type==4) & `s'_rsn`st'==1 replace `s'_`st'rsn=4 if (`s'_`st'type==3 | `s'_`st'type==4) & `s'_rsn`st'==2 replace `s'_`st'rsn=5 if (`s'_`st'type==3 | `s'_`st'type==4) & `s'_rsn`st'==3 replace `s'_`st'rsn=6 if (`s'_`st'type==3 | `s'_`st'type==4) & `s'_rsn`st'==4 replace `s'_`st'rsn=7 if (`s'_`st'type==3 | `s'_`st'type==4) & (`s'_rsn`st'==5 | `s'_rsn`st'==.) la val `s'_`st'rsn strsn } }]]> Husband's reason for res ep start/stop (D) 31663 164740 1 Baseline/present 10446 2 Birth/Death 803 3 Migr - marriage 6209 4 Migr - Div/Sep 1172 5 Migr - educ 135 6 Migr - work 6995 7 Migr - other 5903 Sysmiss 164740 la def strsn 1 "Baseline/present" 2 "Birth/Death" 3 "Migr - marriage" 4 "Migr - Div/Sep" 5 "Migr - educ" 6 "Migr - work" 7 "Migr - other" foreach s in w h { foreach st in start stop { gen `s'_`st'rsn=1 if `s'_`st'type==1 replace `s'_`st'rsn=2 if `s'_`st'type==2 replace `s'_`st'rsn=3 if (`s'_`st'type==3 | `s'_`st'type==4) & `s'_rsn`st'==1 replace `s'_`st'rsn=4 if (`s'_`st'type==3 | `s'_`st'type==4) & `s'_rsn`st'==2 replace `s'_`st'rsn=5 if (`s'_`st'type==3 | `s'_`st'type==4) & `s'_rsn`st'==3 replace `s'_`st'rsn=6 if (`s'_`st'type==3 | `s'_`st'type==4) & `s'_rsn`st'==4 replace `s'_`st'rsn=7 if (`s'_`st'type==3 | `s'_`st'type==4) & (`s'_rsn`st'==5 | `s'_rsn`st'==.) la val `s'_`st'rsn strsn } }]]> Last known date wife alive (D) 196345 Last known date wife alive use ${gendata}\crs_residency_episodes_clean_nopoly, clear bys ident: egen lastincrs=max(stopdate) bys ident (stopdate): gen laststop=stoptype[_N] format %td lastincrs keep ident lastincrs laststop duplicates drop gen crs=1 save ${tempfiles}\allcrsmembers, replace gen adl=1 if laststop==1 | laststop==4 replace adl=2 if laststop==2 rename lastincrs intdate save ${tempfiles}\adlcrs, replace *get listing of last alive and death dates from parents use idmoth idfath m_lastAC m_firstDC f_lastAC f_firstDC using ${gendata}\parents_lafd, clear expand 2, gen(exp) drop if idmoth=="" & idfath=="" gen ident=idmoth if exp==0 replace ident=idfath if exp==1 gen lastA=m_lastAC if exp==0 replace lastA=f_lastAC if exp==1 gen firstD=m_firstDC if exp==0 replace firstD=f_firstDC if exp==1 keep ident lastA firstD drop if ident=="" duplicates drop save ${tempfiles}\parslafd, replace *add in data from indices use ${newstata}\indices, clear replace intdate=event_date if event_date~=. append using ${tempfiles}\adlcrs expand 2 if adl==2, gen(exp) replace adl=1 if exp==1 keep ident adl intdate drop if adl>=3 bys ident adl: egen lastA=max(intdate) if adl==1 bys ident adl: egen firstD=min(intdate) if adl==2 append using ${tempfiles}\parslafd bys ident: egen lastalive=max(lastA) bys ident: egen firstdead=min(firstD) keep ident lastalive firstdead format %td lastalive firstdead replace firstdead=. if lastalive>firstdead & lastalive~=. duplicates drop save ${tempfiles}\indices_lafd, replace]]> First known date wife dead (D) 8105 use ${gendata}\crs_residency_episodes_clean_nopoly, clear bys ident: egen lastincrs=max(stopdate) bys ident (stopdate): gen laststop=stoptype[_N] format %td lastincrs keep ident lastincrs laststop duplicates drop gen crs=1 save ${tempfiles}\allcrsmembers, replace gen adl=1 if laststop==1 | laststop==4 replace adl=2 if laststop==2 rename lastincrs intdate save ${tempfiles}\adlcrs, replace *get listing of last alive and death dates from parents use idmoth idfath m_lastAC m_firstDC f_lastAC f_firstDC using ${gendata}\parents_lafd, clear expand 2, gen(exp) drop if idmoth=="" & idfath=="" gen ident=idmoth if exp==0 replace ident=idfath if exp==1 gen lastA=m_lastAC if exp==0 replace lastA=f_lastAC if exp==1 gen firstD=m_firstDC if exp==0 replace firstD=f_firstDC if exp==1 keep ident lastA firstD drop if ident=="" duplicates drop save ${tempfiles}\parslafd, replace *add in data from indices use ${newstata}\indices, clear replace intdate=event_date if event_date~=. append using ${tempfiles}\adlcrs expand 2 if adl==2, gen(exp) replace adl=1 if exp==1 keep ident adl intdate drop if adl>=3 bys ident adl: egen lastA=max(intdate) if adl==1 bys ident adl: egen firstD=min(intdate) if adl==2 append using ${tempfiles}\parslafd bys ident: egen lastalive=max(lastA) bys ident: egen firstdead=min(firstD) keep ident lastalive firstdead format %td lastalive firstdead replace firstdead=. if lastalive>firstdead & lastalive~=. duplicates drop save ${tempfiles}\indices_lafd, replace]]> Last known date husband alive (D) 195687 use ${gendata}\crs_residency_episodes_clean_nopoly, clear bys ident: egen lastincrs=max(stopdate) bys ident (stopdate): gen laststop=stoptype[_N] format %td lastincrs keep ident lastincrs laststop duplicates drop gen crs=1 save ${tempfiles}\allcrsmembers, replace gen adl=1 if laststop==1 | laststop==4 replace adl=2 if laststop==2 rename lastincrs intdate save ${tempfiles}\adlcrs, replace *get listing of last alive and death dates from parents use idmoth idfath m_lastAC m_firstDC f_lastAC f_firstDC using ${gendata}\parents_lafd, clear expand 2, gen(exp) drop if idmoth=="" & idfath=="" gen ident=idmoth if exp==0 replace ident=idfath if exp==1 gen lastA=m_lastAC if exp==0 replace lastA=f_lastAC if exp==1 gen firstD=m_firstDC if exp==0 replace firstD=f_firstDC if exp==1 keep ident lastA firstD drop if ident=="" duplicates drop save ${tempfiles}\parslafd, replace *add in data from indices use ${newstata}\indices, clear replace intdate=event_date if event_date~=. append using ${tempfiles}\adlcrs expand 2 if adl==2, gen(exp) replace adl=1 if exp==1 keep ident adl intdate drop if adl>=3 bys ident adl: egen lastA=max(intdate) if adl==1 bys ident adl: egen firstD=min(intdate) if adl==2 append using ${tempfiles}\parslafd bys ident: egen lastalive=max(lastA) bys ident: egen firstdead=min(firstD) keep ident lastalive firstdead format %td lastalive firstdead replace firstdead=. if lastalive>firstdead & lastalive~=. duplicates drop save ${tempfiles}\indices_lafd, replace]]> First known date husband dead (D) 21121 use ${gendata}\crs_residency_episodes_clean_nopoly, clear bys ident: egen lastincrs=max(stopdate) bys ident (stopdate): gen laststop=stoptype[_N] format %td lastincrs keep ident lastincrs laststop duplicates drop gen crs=1 save ${tempfiles}\allcrsmembers, replace gen adl=1 if laststop==1 | laststop==4 replace adl=2 if laststop==2 rename lastincrs intdate save ${tempfiles}\adlcrs, replace *get listing of last alive and death dates from parents use idmoth idfath m_lastAC m_firstDC f_lastAC f_firstDC using ${gendata}\parents_lafd, clear expand 2, gen(exp) drop if idmoth=="" & idfath=="" gen ident=idmoth if exp==0 replace ident=idfath if exp==1 gen lastA=m_lastAC if exp==0 replace lastA=f_lastAC if exp==1 gen firstD=m_firstDC if exp==0 replace firstD=f_firstDC if exp==1 keep ident lastA firstD drop if ident=="" duplicates drop save ${tempfiles}\parslafd, replace *add in data from indices use ${newstata}\indices, clear replace intdate=event_date if event_date~=. append using ${tempfiles}\adlcrs expand 2 if adl==2, gen(exp) replace adl=1 if exp==1 keep ident adl intdate drop if adl>=3 bys ident adl: egen lastA=max(intdate) if adl==1 bys ident adl: egen firstD=min(intdate) if adl==2 append using ${tempfiles}\parslafd bys ident: egen lastalive=max(lastA) bys ident: egen firstdead=min(firstD) keep ident lastalive firstdead format %td lastalive firstdead replace firstdead=. if lastalive>firstdead & lastalive~=. duplicates drop save ${tempfiles}\indices_lafd, replace]]> Unique identifier of wife (D) 22800 0 Unique identifier of wife variable: wife (table[s]: all_spouse_pairs_full [derived table]) Unique identifier of husband (D) 22800 0 variable: husband (table[s]: all_spouse_pairs_full [derived table]) Union ever reported by (D) 21253 1547 Union ever reported by 1 wife 3992 2 husband 1686 3 both 15575 4 Residency data 0 Sysmiss 1547 variable: repby (table[s]: all_spouse_pairs_full [derived table]) Age difference between spouses (D) 22800 0 variable: agediff (table[s]: all_spouse_pairs_full [derived table]) Partnership only from co-parent link (D) 22800 0 variable: newparlink (table[s]: all_spouse_pairs_full [derived table]) Max number of spouses husband reports while in this union (D) 13219 9581 variable: heverpolyn (table[s]: all_spouse_pairs_full [derived table]) Union was ever polygamous (D) 13219 9581 Union was ever polygamous (D) variable: everpoly (table[s]: all_spouse_pairs_full [derived table]) Union ever reported to be current (D) 21253 1547 variable: evercur (table[s]: all_spouse_pairs_full [derived table]) Marriage date (15-April of reported year) (D) 14362 mardate datatype (D) 14371 8429 1 Report 9118 2 Residency 5253 3 Both 0 4 Death 0 5 ep censor 0 6 ep split 0 Sysmiss 8429 The datatype variable is updated depending on which final mardate is used. if mardate is estimated (D) 14371 8429 0 No 5253 1 Day est 0 2 Day&month 8949 3 est due to overlap 169 4 ep censor 0 5 ep split 0 Sysmiss 8429 The dtest variable is updated depending on which final mardate is used. mardate informant (D) 14371 8429 mardate informant (D) 1 wife 2674 2 husband 480 3 both 5964 4 Residency data 5253 Sysmiss 8429 The informant variable is updated depending on which final mardate is used. First known married date (D) 8304 fstknwmardate datatype (D) 8304 14496 fstknwmardate datatype (D) 1 Report 5916 2 Residency 2311 3 Both 0 4 Death 77 5 ep censor 0 6 ep split 0 Sysmiss 14496 The datatype variable is updated depending on which final fstknwmardate is used. if fstknwmardate is estimated (D) 8268 14532 if fstknwmardate is estimated (D) 0 No 8041 1 Day est 0 2 Day&month 221 3 est due to overlap 4 4 ep censor 0 5 ep split 0 15776 1 17800 1 Sysmiss 14532 The dtest variable is updated depending on which final fstknwmardate is used. fstknwmardate informant (D) 8304 14496 fstknwmardate informant (D) 1 wife 1547 2 husband 1445 3 both 2924 4 Residency data 2388 Sysmiss 14496 The informant variable is updated depending on which final fstknwmardate is used. Last date still reported to be married (D) 15209 Last date still reported to be married stillmardate datatype (D) 15209 7591 stillmardate datatype (D) 1 Report 6146 2 Residency 9063 3 Both 0 4 Death 0 5 ep censor 0 6 ep split 0 Sysmiss 7591 The datatype variable is updated depending on which final stillmardate is used. if stillmardate is estimated (D) 15178 7622 0 No 15113 1 Day est 0 2 Day&month 40 3 est due to overlap 25 4 ep censor 0 5 ep split 0 Sysmiss 7622 The dtest variable is updated depending on which final stillmardate is used. stillmardate informant (D) 15209 7591 stillmardate informant (D) 1 wife 1970 2 husband 1869 3 both 2307 4 Residency data 9063 Sysmiss 7591 The informant variable is updated depending on which final stillmardate is used. Separation date (15-Aug of reported year) (D) 7457 sepdate datatype (D) 7457 15343 1 Report 2446 2 Residency 3486 3 Both 0 4 Death 1525 5 ep censor 0 6 ep split 0 Sysmiss 15343 The datatype variable is updated depending on which final sepdate is used. if sepdate is estimated (D) 7330 15470 0 No 4509 1 Day est 0 2 Day&month 2731 3 est due to overlap 90 4 ep censor 0 5 ep split 0 Sysmiss 15470 The dtest variable is updated depending on which final sepdate is used. sepdate informant (D) 7457 15343 1 wife 2171 2 husband 256 3 both 19 4 Residency data 5011 Sysmiss 15343 The informant variable is updated depending on which final sepdate is used. Which partner died (D) 1525 21275 1 wife 348 2 husband 1177 3 both 0 Sysmiss 21275 Updated to wife or husband if their death date is taken as sepdate First date of any report (D) 21253 The first date either partner report this union (regardless of whether they reported still being married) Last date of any report (D) 21253 The last date either partner report this union (regardless of whether they reported still being married) First date of any report while in the CRS (D) 16581 The first date either partner report this union while they were a CRS member (regardless of whether they reported still being married) Last date of any report while in the CRS (D) 16581 Last date of any report (D) The last date either partner report this union while they were a CRS member (regardless of whether they reported still being married) Either partner ever a CRS member (D) 16581 6219 gen evercrs=1 if firstrepdatecrs~=. First date reported married (D) 18870 egen start=rowmin(mardate fstknwmardate) bys wife husband: egen temp1=min(stillmardateO) if stillmardateO~=. & stillmardateO>=start bys wife husband: egen fstmarrepdate=max(temp1)]]> Last date reported married (D) 18673 Either partner ever a CRS member (D) egen end=rowmax(stillmardate sepdate) bys wife husband: egen temp2=max(stillmardateO) if stillmardateO~=. & stillmardateO<=end bys wife husband: egen lstmarrepdate=max(temp2)]]> Unique identifier 134177 0 expand 2, gen(exp) gen ident=wife if exp1==0 replace ident=husband if exp1==1 drop if ident==""]]> Sex 134175 2 expand 2, gen(exp1) gen sex=0 if exp1==1 replace sex=1 if exp1==0 merge m:1 ident using ${newstata}\gen_identity_clean, keep(master match) keepusing(sex) nogen]]> Start date of episode (D) 134177 if date1 is estimated (D) 134177 0 0 No 109115 1 Day est 0 2 Day&month 20509 3 est due to overlap 198 4 ep censor 0 5 ep split 4355 data type of date1 (D) 134177 0 1 Report 87850 2 Residency 19294 3 Both 0 4 Death 1451 5 ep censor 21388 6 ep split 4194 source if marital status report1 (D) 58561 0 informant of date1 (D) 134177 0 0 proxy 41270 1 self 23340 2 spouse 7215 3 self&spouse 15163 4 res data 20745 5 ep censor 21388 6 ep split 4646 9 nk if self or proxy 410 more detailed description of date1 (D) 134177 0 1 StatusRep 59022 2 Marriage 25373 3 1stRepOfMar 6571 4 LastRepOfMar 7140 5 Divorce 9122 6 Death (sp) 1367 7 Death (own) 0 8 ep censor 21388 9 ep split 4194 marital status for episode (D) 134167 10 0 Never married 35166 1 Married 53656 2 Divorced/separated 17841 3 Widowed 5040 4 N/A (dead) 0 8 Unknown 0 9 Missing 22464 Sysmiss 10 number of spouses for episode (D) 55950 78227 97 Not applicable 98 Unknown 99 Missing End date of episode (D) 134177 if date2 is estimated (D) 134177 0 0 No 123505 1 Day est 0 2 Day&month 6176 3 est due to overlap 164 4 ep censor 0 5 ep split 4331 17800 1 data type of date2 (D) 134177 0 1 Report 25812 2 Residency 18685 3 Both 0 4 Death 1909 5 ep censor 83577 6 ep split 4194 source if marital status report2 (D) 18727 0 informant of date2 (D) 134177 0 0 proxy 12596 1 self 7638 2 spouse 2399 3 self&spouse 1204 4 res data 20594 5 ep censor 83577 6 ep split 6094 9 nk if self or proxy 75 more detailed description of date2 (D) 134177 0 1 StatusRep 19429 2 Marriage 8434 3 1stRepOfMar 2058 4 LastRepOfMar 5811 5 Divorce 9986 6 Death (sp) 688 7 Death (own) 0 8 ep censor 83577 9 ep split 4194 spouses's id [1] (D) 48270 0 age difference between individual and their spouse [1] (D) 48270 85907 who reported the union [1] (D) 45241 88936 1 wife 8156 2 husband 3380 3 both 33705 4 Residency data 0 Sysmiss 88936 whether union only known about through co-parent link and co-residency [1] (D) 48270 85907 spouses's id [2] (D) 2444 0 age difference between individual and their spouse [2] (D) 2444 131733 who reported the union [2] (D) 2372 131805 1 wife 249 2 husband 211 3 both 1912 4 Residency data 0 Sysmiss 131805 whether union only known about through co-parent link and co-residency [2] (D) 2444 131733 spouses's id [3] (D) 98 0 age difference between individual and their spouse [3] (D) 98 134079 who reported the union [3] (D) 96 134081 1 wife 10 2 husband 13 3 both 73 4 Residency data 0 Sysmiss 134081 whether union only known about through co-parent link and co-residency [3] (D) 98 134079 spouses's id [4] (D) 12 0 age difference between individual and their spouse [4] (D) 12 134165 who reported the union [4] (D) 12 134165 1 wife 0 2 husband 0 3 both 12 4 Residency data 0 Sysmiss 134165 whether union only known about through co-parent link and co-residency [4] (D) 12 134165