use cross\crossdata, clear
sort individid
merge individid using cross\crossoccupation
drop if _merge ==2
drop _merge
save cross\crossdata, replace
use cross\crossdata, clear
sort motherid
merge motherid using cross\crossmoccupation
drop if _merge ==2
sort individid
drop _merge
save cross\crossdata, replace
use cross\crossdata, clear
sort fatherid
merge fatherid using cross\crossfoccupation
drop if _merge ==2
drop _merge
save cross\crossdata, replace