********************************************************* *IV variables, requested by Filiz GARIP on Sep 16th, 2011 ** **** **** **** *Created: 16 September 2011 11am by Burak Eskici *Updated: 21 September 2011 6pm by Burak Eskici ************************************************************************* * These data files should be copied to root directory * *********************************************************************** ***sibs94_ind.dta ~ 1994 Sibling Network individual level ~ from Temp Data/Burak/Data Files ***indiv84.dta ~ individual data 1984 ~ from ORIGINAL STATA FILES ***personid.dta ~ NRPID data ~ from ORIGINAL STATA FILES *************************************************************************** clear set mem 1000m cd "D:/ws" use "personid.dta", clear drop if missing(vill84) | missing(house84) | missing(cep84) keep nrpid vill84 house84 cep84 order nrpid vill84 house84 cep84 sort vill84 house84 cep84 save "personid_r.dta",replace use "indiv84.dta", clear keep vill84 house84 cep84 in84_06 in84_13 in84_16 cep94 hhid94 order vill84 house84 cep84 in84_06 in84_13 in84_16 cep94 hhid94 rename in84_06 age rename in84_13 reason rename in84_16 rem sort vill84 house84 cep84 merge 1:1 vill84 house84 cep84 using "personid_r.dta" drop _merge // AGE: discard those>80 – babies or missing data and those<15 drop if age>80 drop if missing(age) drop if age<15 //Whether or nor Migrant ~ //Assume the person with CEP84>200 is a migrant if IN84_13 equals 5 or 9 or 10 or 11 or 12 or 15 gen mig=0 label var mig "is a migrant?" destring cep84, gen(c84) replace mig=1 if (c84>200) & (reason==5 | reason==9 | reason==10 | reason==11 | reason==12 | reason==15) order nrpid vill84 house84 cep84 age reason rem mig cep94 hhid94 drop c84 //drop is remmittance info is missing drop if rem==9 | rem==3 replace rem=0 if rem==8 replace rem=0 if rem==2 sort nrpid save "migrem84.dta",replace use "sibs94_ind.dta", clear rename nrpid_s nrpid rename vill84 vill84_r sort nrpid merge m:1 nrpid using "migrem84.dta" keep if _merge==3 drop _merge rename nrpid nrpid_s rename age age_s rename rem rem_s rename mig mig_s keep nrpid_r nrpid_s hhid94_r hhid94_s cep94_r cep94_s age_s rem_s mig_s vill84_r sort nrpid_r nrpid_s by nrpid_r: gen sibno=_n by nrpid_r: egen sibno_r=max(sibno) reshape wide nrpid_s age_s rem_s mig_s hhid94_s cep94_s, i(nrpid_r) j(sibno) order vill84_r hhid94_r cep94_r sibno_r egen tmig=rowtotal(mig_s*) gen pmigsib84=tmig/sibno_r*100 egen trem=rowtotal(rem_s*) gen premsib84=trem/sibno_r*100 keep vill84_r hhid94_r nrpid_r pmigsib84 premsib84 //this part is redundant bys hhid94_r: egen pmigsib84_r=max(pmigsib84) by hhid94_r: egen premsib84_r=max(premsib84) by hhid94_r: drop if _n>1 keep hhid94_r vill84_r pmigsib84_r premsib84_r rename hhid94_r hhid94 rename vill84_r vill84 rename pmigsib84_r pmigsib84 rename premsib84_r premsib84 label var pmigsib84 "Percentage of first order ties who have migrated in 1984" label var premsib84 "Percentage of first order ties who have remitted in 1984" sort hhid94 save "IVvars1.dta", replace use "sibs94_ind.dta", clear rename nrpid_s nrpid rename vill84 vill84_r sort nrpid merge m:1 nrpid using "migrem84.dta" keep if _merge==3 drop _merge rename nrpid nrpid_s rename age age_s rename rem rem_s rename mig mig_s drop if age_s<35 keep nrpid_r nrpid_s hhid94_r hhid94_s cep94_r cep94_s age_s rem_s mig_s vill84_r sort nrpid_r nrpid_s by nrpid_r: gen sibno=_n by nrpid_r: egen sibno_r=max(sibno) reshape wide nrpid_s age_s rem_s mig_s hhid94_s cep94_s, i(nrpid_r) j(sibno) order vill84_r hhid94_r cep94_r sibno_r egen tmig=rowtotal(mig_s*) gen pmigsib84=tmig/sibno_r*100 egen trem=rowtotal(rem_s*) gen premsib84=trem/sibno_r*100 keep vill84_r hhid94_r nrpid_r pmigsib84 premsib84 //this part is redundant bys hhid94_r: egen pmigsib84_r=max(pmigsib84) by hhid94_r: egen premsib84_r=max(premsib84) by hhid94_r: drop if _n>1 keep hhid94_r vill84_r pmigsib84_r premsib84_r rename hhid94_r hhid94 rename vill84_r vill84 rename pmigsib84_r pmigsib84_45 rename premsib84_r premsib84_45 label var pmigsib84_45 "Percentage of first order ties(older than 35 in 1984) who have migrated in 1984" label var premsib84_45 "Percentage of first order ties(older than 35 in 1984) who have remitted in 1984" sort hhid94 merge 1:1 hhid94 using "IVvars1.dta" drop _merge save "pmigrem84.dta",replace