** identification - husband
rename mv000 v000
rename mv001 v001
rename mv002 v002
rename mv003 v034

** only keep partners who are currently married
keep if mv501 == 1

sort v001 v002 v034

** missing if wife is not in household (cannot match household code with individual file if wife is from a different household)
forvalues i = 1(1)8 {
	replace mv034_`i' = . if mv034_`i' == 0
}

** identification - wife

** drop if all wife line numbers are missing (cannot match with no line number)
drop if mv034_1 == . & mv034_2 == . & mv034_3 == . & mv034_4 == . & mv034_5 == . & mv034_6 == . & mv034_7 == . & mv034_8 == .

save temp.dta, replace

** append datasets based on line numbers to create woman-level dataset
forvalues i = 1(1)8 {
	use temp, clear
	rename mv034_`i' v003
	drop mv034_*
	order v003, after(v002)
	drop if v003 == .
	save temp`i'.dta, replace
}

** append datasets
use temp1, clear

append using temp2
append using temp3
append using temp4
append using temp5
append using temp6
append using temp7
append using temp8

sort v000 v001 v002 v003 v034

save hus_2020.dta, replace

use "2020/IAIR7EDT/IAIR7EFL.dta", clear

** merge with husband data
merge 1:1 v001 v002 v003 v034 using hus_2020 
drop if _merge == 2