*Adjustment for year 2016, drawn from sample month wave 7 (letter g) year 2 and wave 8 (letter h) year 1. use "\\....\g_indresp.dta", clear merge 1:1 pidp using "\\....\h_indresp.dta" ge weight2016=0 replace weight2016=g_indpxui_xw if g_month>=13 & g_month<=24 ge ind=1 sum ind [aw=g_indpxui_xw] if g_month>=1 & g_month<=12 gen gwtdtot=r(sum_w) sum ind [aw=h_indpxui_xw] if h_month>=1 & h_month<=12 gen hwtdtot=r(sum_w) replace weight2016=h_indpxui_xw*(gwtdtot/hwtdtot) if h_month>=1 & h_month<=12 ge psu2016=0 replace psu2016=g_psu if g_month>=13 & g_month<=24 replace psu2016=h_psu if h_month>=1 & h_month<=12 ge strata2016=0 replace strata2016=g_strata if g_month>=13 & g_month<=24 replace strata2016=h_strata if h_month>=1 & h_month<=12 svyset psu2016 [pw=weight2016], strata(strata2016) singleunit(centered) *Example using w_sex_dv ge sex2016=0 replace sex2016=g_sex_dv if g_month>=13 & g_month<=24 replace sex2016=h_sex_dv if h_month>=1 & h_month<=12 svy: proportion sex2016 if weight2016>0