log using "rndfix_j1.log", replace set memory 300m set maxvar 10000 global varlist rassrecv rassagem rassageb sassrecv sassagem sassageb use "C:\RANDHRS\STATA\rndhrs_j" sum $varlist save "C:\RANDHRS\STATA\rndhrs_j1" merge hhidpn using "C:\RANDHRS\STATA\rndfix_j1", keep($varlist) update replace sort tab _merge save "C:\RANDHRS\STATA\rndhrs_j", replace sum $varlist log close