use individres
drop if (res_edate != . & res_edate < $refdate)
drop if (res_sdate != . & res_sdate > $refdate)
gen refdate = $refdate
keep individid locationid
sort individid

duplicates drop individid, force
sort individid
save cross\crossresidency, replace