log using "rndfix6g1.log", replace set memory 256m global varlist h6child r6livbro r6livsis r6livsib s6livsis s6livbro s6livsib r6risk6 s6risk6 use "C:\RANDHRS\STATA\rndhrs6g" sum $varlist save "C:\RANDHRS\STATA\rndhrs6g1" merge hhidpn using "C:\RANDHRS\STATA\rndfix_g1", keep($varlist) update replace sort tab _merge save "C:\RANDHRS\STATA\rndhrs6g", replace sum $varlist log close