clear all
set mem 1000M
cd e:\chililabdata\data
use observation
sort observeid
save observation, replace
use individual
sort individid
save, replace
use tblDisability
sort individid
duplicates drop individid, force
merge individid using individual
keep if _merge ==3
drop  appround bornid individidGuid motheridGuid fatheridGuid _merge
sort observeid
save alldisability, replace
keep observeid
merge observeid using observation
keep if _merge ==3
gen quarterdate = qofd(obs_de_date) 
tostring quarterdate, generate(key)
replace key = socialgpid + key
drop  obs_entry_date obs_field_wrkr obs_data_clerk obs_de_date obs_status_dat obs_responsor observeidGuid socialgpidGuid _merge
sort observeid
merge observeid using alldisability
keep if _merge == 3
drop _merge obs_round
sort key
save alldisability, replace
keep key
merge key using householdinfortemp
keep if _merge ==3
drop _merge
sort key
duplicates drop key, force
merge  key using alldisability
save alldisability2008, replace
drop _merge
use death/alldeaths
sort individid
save, replace
use tbldisability
sort individid
duplicates drop individid, force
merge individid using death/alldeaths
keep if _merge ==3
drop _merge
save disability_deaths, replace
use tblDisability
sort individid
save,replace
keep individid
merge individid using e:\dataanalysis\crossdata31122011v3
sort individid
keep if _merge ==3
drop _merge
merge individid using tbldisability
keep if _merge ==3
drop  individidGuid motheridGuid fatheridGuid p maxhhd_sdate _merge
save alldisability2011, replace