log using "rndfix_g1.log", replace set memory 300m set maxvar 10000 global varlist h3child r3livsis r3livsib s3livbro s3livsib /* */ h4child r4livbro r4livsis r4livsib s4livbro s4livsis s4livsib r4risk6 s4risk6 /* */ h5child r5livbro r5livsis r5livsib s5livbro s5livsis s5livsib r5risk6 s5risk6 /* */ h6child r6livbro r6livsis r6livsib s6livsis s6livbro s6livsib r6risk6 s6risk6 /* */ h7child r7risk6 s7risk6 use "C:\RANDHRS\STATA\rndhrs_g" sum $varlist save "C:\RANDHRS\STATA\rndhrs_g1" merge hhidpn using "C:\RANDHRS\STATA\rndfix_g1", keep($varlist) update replace sort tab _merge save "C:\RANDHRS\STATA\rndhrs_g", replace sum $varlist log close