set more off use H:\StataMSC\ETPRTEMP.DTA, clear gen wgt= hv005/1000000 sort hhid gen NumHHMembers=. replace NumHHMembers=1 if hv012==1 replace NumHHMembers=2 if hv012==2 replace NumHHMembers=3 if hv012>=3 & hv012<=4 replace NumHHMembers=4 if hv012>=5 & hv012<=6 replace NumHHMembers=5 if hv012>=7 gen Residence=. replace Residence=1 if hv025==1 replace Residence=2 if hv025==2 gen HHeadSex=. replace HHeadSex=1 if hv219==1 replace HHeadSex=2 if hv219==2 gen Education=. replace Education=0 if hv106==0 replace Education=1 if hv106==1 replace Education=2 if hv106==2 replace Education=3 if hv106==3 gen age=. replace age=3 if hv105<98 replace age=2 if hv105<65 replace age=1 if hv105<15 gen age1=0 gen age2=0 gen age3=0 replace age1=1 if age==1 replace age2=1 if age==2 replace age3=1 if age==3 gen hhsize=1 replace hhsize=0 if hv105>=98 collapse (sum) hhsize age1 age2 age3, by(hhid) gen prop_age1=age1/hhsize gen prop_age2=age2/hhsize gen prop_age3=age3/hhsize gen youth_dep_ratio=age1/age2 gen oldage_dep_ratio=age3/age2 gen dep_ratio=(age1+age3)/age2 sort hhid merge hhid using H:\StataMSC\ETPRTEMP.DTA, drop _merge