clear clear matrix clear mata global datadir "c:\work\share\data" *------------------------------------------------------------------------------ clear version 12.0 set mem 1000m set maxvar 30000 pause off set more off *------------------------------------------------------------------------------ /* Define waves to merge to wave 1*/ global waves "2 3 4 5 6 7" /* Keep data only for CZ, otherwise all data a too big file*/ use using $datadir\w1_data.dta, clear keep if w1_country==28 sort mergeid foreach x in $waves { merge mergeid using $datadir\w`x'_data.dta keep if w`x'_country==28 sort mergeid drop _merge* } sort mergeid save $datadir\w123456_data.dta, replace