*************************************** ** Migration History Paper ************ ** Last Update: December 22, 08 6 pm * *************************************** * We use 1984-2000 data, do separate analysis * for 18-25 year olds and all age groups. clear set mem 1000m cd "N:\Temp Data\Migration History Dec 08" use "comb_lh_hh_vill.dta", clear * Compute FOLLOW-UP RATES by village ************************************ bys vill84: egen follow94 = total(mig==1&rmg~=.&year==1994) bys vill84: egen total94 = total(mig==1&year==1994) replace follow94 = follow94/total94 lab var follow94 "94: migrant follow-up rates in vill" bys vill84: egen follow00 = total(mig==1&rmg~=.&year==2000) bys vill84: egen total00 = total(mig==1&year==2000) replace follow00 = follow00/total00 lab var follow00 "00: migrant follow-up rates in vill" * We do not have the hh and village level variables prior to 1984. keep if year>=1984 drop if land==. | educ==. | married==. | age==. | sex==. | outnr==. | itrip==. drop vsize *drop non-unique obs bys nrpid year: drop if _n>1 ************** ** TABLE 2 *** ************** ** Village size ** bys vill84 year: gen vsize = _N bys vill84 year: egen vsizef = total(sex==0) bys vill84 year: egen vsizem = total(sex==1) ** Number of migrants ** bys vill84 year: egen nomig = total(outnr==1 & sex~=.) bys vill84 year: egen nomigf = total(outnr==1 & sex==0) bys vill84 year: egen nomigm = total(outnr==1 & sex==1) ** Number of ever migrants ** gen emig = 0 replace emig = 1 if itrip>=1 bys vill84 year: egen evermig = total(emig==1) bys vill84 year: egen evermigf = total(emig==1 & sex==0) bys vill84 year: egen evermigm = total(emig==1 & sex==1) ** Number of trips ** drop ctript bys vill84 year: egen ctript = total(itrip==1) bys vill84 year: egen ctriptf = total(itrip==1 & sex==0) bys vill84 year: egen ctriptm = total(itrip==1 & sex==1) ** Inequality in trips ** bys vill84 year: egen sdtrip = sd(itrip) bys vill84 year: egen sdtripf = sd(itrip) if sex==0 bys vill84 year: egen sdtripm = sd(itrip) if sex==1 bys vill84 year: egen mntrip = mean(itrip) bys vill84 year: egen mntripf = mean(itrip) if sex==0 bys vill84 year: egen mntripm = mean(itrip) if sex==1 sort vill84 year sdtripf by vill84 year: replace sdtripf = sdtripf[_n-1] if _n>1 sort vill84 year sdtripm by vill84 year: replace sdtripm = sdtripm[_n-1] if _n>1 sort vill84 year mntripf by vill84 year: replace mntripf = mntripf[_n-1] if _n>1 sort vill84 year mntripm by vill84 year: replace mntripm = mntripm[_n-1] if _n>1 gen cvtrip = 0 gen cvtripf = 0 gen cvtripm = 0 replace cvtrip = sdtrip/mntrip if mntrip>0 replace cvtripf = sdtripf/mntripf if mntripf>0 replace cvtripm = sdtripm/mntripm if mntripm>0 * Normalize ctrip and cvtrip for regression egen mn_std = std(mntrip) egen cv_std = std(cvtrip) * Re-scale to 0-10 egen maxcv = max(cvtrip) egen mincv = min(cvtrip) replace cvtrip = (cvtrip-mincv)*10/(maxcv-mincv) replace cvtripf = (cvtripf-mincv)*10/(maxcv-mincv) replace cvtripm = (cvtripm-mincv)*10/(maxcv-mincv) gen mighist = mntrip*(10-cvtrip) label var mighist "Cumulative migration trips adjusted by variance save "mig_hist.dta", replace ** Destinations ** bys vill84 year: egen nobkk = total(place1==7 & outnr==1) bys vill84 year: egen nobkkf = total(place1==7 & outnr==1 & sex==0) bys vill84 year: egen nobkkm = total(place1==7 & outnr==1 & sex==1) bys vill84 year: egen nobma = total(place1==8 & outnr==1) bys vill84 year: egen nobmaf = total(place1==8 & outnr==1 & sex==0) bys vill84 year: egen nobmam = total(place1==8 & outnr==1 & sex==1) bys vill84 year: egen noesb = total(place1>=4 & place1<=6 & outnr==1) bys vill84 year: egen noesbf = total(place1>=4 & place1<=6 & outnr==1 & sex==0) bys vill84 year: egen noesbm = total(place1>=4 & place1<=6 & outnr==1 & sex==1) bys vill84 year: egen none = total(place1<=3 & outnr==1) bys vill84 year: egen nonef = total(place1<=3 & outnr==1 & sex==0) bys vill84 year: egen nonem = total(place1<=3 & outnr==1 & sex==1) bys vill84 year: egen nooth = total(place1>=9 & place1<=10 & outnr==1) bys vill84 year: egen noothf = total(place1>=9 & place1<=10 & outnr==1 & sex==0) bys vill84 year: egen noothm = total(place1>=9 & place1<=10 & outnr==1 & sex==1) ************** ** TABLE 3 *** ************** ** Age groups - overall ** bys vill84 year: egen a1318 = total(age>=13 & age<=18) bys vill84 year: egen a1318f = total(age>=13 & age<=18 & sex==0) bys vill84 year: egen a1318m = total(age>=13 & age<=18 & sex==1) bys vill84 year: egen a1924 = total(age>=19 & age<=24) bys vill84 year: egen a1924f = total(age>=19 & age<=24 & sex==0) bys vill84 year: egen a1924m = total(age>=19 & age<=24 & sex==1) bys vill84 year: egen a2530 = total(age>=25 & age<=30) bys vill84 year: egen a2530f = total(age>=25 & age<=30 & sex==0) bys vill84 year: egen a2530m = total(age>=25 & age<=30 & sex==1) bys vill84 year: egen a3135 = total(age>=31 & age<=35) bys vill84 year: egen a3135f = total(age>=31 & age<=35 & sex==0) bys vill84 year: egen a3135m = total(age>=31 & age<=35 & sex==1) bys vill84 year: egen a3641 = total(age>=36 & age<=41) bys vill84 year: egen a3641f = total(age>=36 & age<=41 & sex==0) bys vill84 year: egen a3641m = total(age>=36 & age<=41 & sex==1) ** Age groups - migrants ** bys vill84 year: egen ma1318 = total(age>=13 & age<=18 & outnr==1) bys vill84 year: egen ma1318f = total(age>=13 & age<=18 & sex==0 & outnr==1) bys vill84 year: egen ma1318m = total(age>=13 & age<=18 & sex==1 & outnr==1) bys vill84 year: egen ma1924 = total(age>=19 & age<=24 & outnr==1) bys vill84 year: egen ma1924f = total(age>=19 & age<=24 & sex==0 & outnr==1) bys vill84 year: egen ma1924m = total(age>=19 & age<=24 & sex==1 & outnr==1) bys vill84 year: egen ma2530 = total(age>=25 & age<=30 & outnr==1) bys vill84 year: egen ma2530f = total(age>=25 & age<=30 & sex==0 & outnr==1) bys vill84 year: egen ma2530m = total(age>=25 & age<=30 & sex==1 & outnr==1) bys vill84 year: egen ma3135 = total(age>=31 & age<=35 & outnr==1) bys vill84 year: egen ma3135f = total(age>=31 & age<=35 & sex==0 & outnr==1) bys vill84 year: egen ma3135m = total(age>=31 & age<=35 & sex==1 & outnr==1) bys vill84 year: egen ma3641 = total(age>=36 & age<=41 & outnr==1) bys vill84 year: egen ma3641f = total(age>=36 & age<=41 & sex==0 & outnr==1) bys vill84 year: egen ma3641m = total(age>=36 & age<=41 & sex==1 & outnr==1) ** Marital Status - overall ** bys vill84 year: egen nomarried = total(married==1) bys vill84 year: egen nomarriedf = total(married==1 & sex==0) bys vill84 year: egen nomarriedm = total(married==1 & sex==1) ** Marital Status - migrants ** bys vill84 year: egen mnomarried = total(married==1 & outnr==1) bys vill84 year: egen mnomarriedf = total(married==1 & sex==0 & outnr==1) bys vill84 year: egen mnomarriedm = total(married==1 & sex==1 & outnr==1) ** Education - overall ** * Primary education or less category should include those with no education. replace pri = 1 if noeduc==1 bys vill84 year: egen nopri = total(pri==1) bys vill84 year: egen noprif = total(pri==1 & sex==0) bys vill84 year: egen noprim = total(pri==1 & sex==1) bys vill84 year: egen nosec = total(sec==1) bys vill84 year: egen nosecf = total(sec==1 & sex==0) bys vill84 year: egen nosecm = total(sec==1 & sex==1) bys vill84 year: egen nosec2 = total(sec2==1) bys vill84 year: egen nosec2f = total(sec2==1 & sex==0) bys vill84 year: egen nosec2m = total(sec2==1 & sex==1) ** Education - migrants ** bys vill84 year: egen mnopri = total(pri==1 & outnr==1) bys vill84 year: egen mnoprif = total(pri==1 & sex==0 & outnr==1) bys vill84 year: egen mnoprim = total(pri==1 & sex==1 & outnr==1) bys vill84 year: egen mnosec = total(sec==1 & outnr==1) bys vill84 year: egen mnosecf = total(sec==1 & sex==0 & outnr==1) bys vill84 year: egen mnosecm = total(sec==1 & sex==1 & outnr==1) bys vill84 year: egen mnosec2 = total(sec2==1 & outnr==1) bys vill84 year: egen mnosec2f = total(sec2==1 & sex==0 & outnr==1) bys vill84 year: egen mnosec2m = total(sec2==1 & sex==1 & outnr==1) ** Land - overall ** bys vill84 year: egen noland0 = total(land==0) bys vill84 year: egen noland0f = total(land==0 & sex==0) bys vill84 year: egen noland0m = total(land==0 & sex==1) bys vill84 year: egen noland10 = total(land>0 & land<10) bys vill84 year: egen noland10f = total(land>0 & land<10 & sex==0) bys vill84 year: egen noland10m = total(land>0 & land<10 & sex==1) bys vill84 year: egen noland20 = total(land>=10 & land<20) bys vill84 year: egen noland20f = total(land>=10 & land<20 & sex==0) bys vill84 year: egen noland20m = total(land>=10 & land<20 & sex==1) bys vill84 year: egen noland40 = total(land>=20 & land<40) bys vill84 year: egen noland40f = total(land>=20 & land<40 & sex==0) bys vill84 year: egen noland40m = total(land>=20 & land<40 & sex==1) bys vill84 year: egen noland41 = total(land>=40) bys vill84 year: egen noland41f = total(land>=40 & sex==0) bys vill84 year: egen noland41m = total(land>=40 & sex==1) ** Land - migrants ** bys vill84 year: egen mnoland0 = total(land==0 & outnr==1) bys vill84 year: egen mnoland0f = total(land==0 & sex==0 & outnr==1) bys vill84 year: egen mnoland0m = total(land==0 & sex==1 & outnr==1) bys vill84 year: egen mnoland10 = total(land>0 & land<10 & outnr==1) bys vill84 year: egen mnoland10f = total(land>0 & land<10 & sex==0 & outnr==1) bys vill84 year: egen mnoland10m = total(land>0 & land<10 & sex==1 & outnr==1) bys vill84 year: egen mnoland20 = total(land>=10 & land<20 & outnr==1) bys vill84 year: egen mnoland20f = total(land>=10 & land<20 & sex==0 & outnr==1) bys vill84 year: egen mnoland20m = total(land>=10 & land<20 & sex==1 & outnr==1) bys vill84 year: egen mnoland40 = total(land>=20 & land<40 & outnr==1) bys vill84 year: egen mnoland40f = total(land>=20 & land<40 & sex==0 & outnr==1) bys vill84 year: egen mnoland40m = total(land>=20 & land<40 & sex==1 & outnr==1) bys vill84 year: egen mnoland41 = total(land>=40 & outnr==1) bys vill84 year: egen mnoland41f = total(land>=40 & sex==0 & outnr==1) bys vill84 year: egen mnoland41m = total(land>=40 & sex==1 & outnr==1) ***************** ** TABLE STATS ** ***************** bys vill84 year: keep if _n==1 keep vsize* nomig* evermig* ctript* sdtrip* mntrip* cvtrip* mighist nobkk* nobma* noesb* none* nooth* /// a1* a2* a3* ma1* ma2* ma3* nomarried* mnomarried* *nopri* *nosec* *nosec2* /// *noland0* *noland10* *noland20* *noland4* vill84 year prev xtile mh = mighist, nq(5) save "mh_cat", replace bys mh: egen tvsize = total(vsize) bys mh: egen tvsizef = total(vsizef) bys mh: egen tvsizem = total(vsizem) bys mh: egen tnomig = total(nomig) bys mh: egen tnomigf = total(nomigf) bys mh: egen tnomigm = total(nomigm) bys mh: egen tevermig = total(evermig) bys mh: egen tevermigf = total(evermigf) bys mh: egen tevermigm = total(evermigm) bys mh: egen tctript = total(ctript) bys mh: egen tctriptf = total(ctriptf) bys mh: egen tctriptm = total(ctriptm) bys mh: egen mcvtrip = mean(cvtrip) bys mh: egen mcvtripf = mean(cvtripf) bys mh: egen mcvtripm = mean(cvtripm) bys mh: egen tnobkk = total(nobkk) bys mh: egen tnobkkf = total(nobkkf) bys mh: egen tnobkkm = total(nobkkm) bys mh: egen tnobma = total(nobma) bys mh: egen tnobmaf = total(nobmaf) bys mh: egen tnobmam = total(nobmam) bys mh: egen tnoesb = total(noesb) bys mh: egen tnoesbf = total(noesbf) bys mh: egen tnoesbm = total(noesbm) bys mh: egen tnone = total(none) bys mh: egen tnonef = total(nonef) bys mh: egen tnonem = total(nonem) bys mh: egen tnooth = total(nooth) bys mh: egen tnoothf = total(noothf) bys mh: egen tnoothm = total(noothm) gen pevermig = tevermig/tvsize gen pevermigf = tevermigf/tvsizef gen pevermigm = tevermigm/tvsizem gen pnobkk = tnobkk/tnomig gen pnobkkf = tnobkkf/tnomigf gen pnobkkm = tnobkkm/tnomigm gen pnobma = tnobma/tnomig gen pnobmaf = tnobmaf/tnomigf gen pnobmam = tnobmam/tnomigm gen pnoesb = tnoesb/tnomig gen pnoesbf = tnoesbf/tnomigf gen pnoesbm = tnoesbm/tnomigm gen pnone = tnone/tnomig gen pnonef = tnonef/tnomigf gen pnonem = tnonem/tnomigm gen pnooth = tnooth/tnomig gen pnoothf = tnoothf/tnomigf gen pnoothm = tnoothm/tnomigm * AGE bys mh: egen ta1318 = total(a1318) bys mh: egen ta1318f = total(a1318f) bys mh: egen ta1318m = total(a1318m) bys mh: egen ta1924 = total(a1924) bys mh: egen ta1924f = total(a1924f) bys mh: egen ta1924m = total(a1924m) bys mh: egen ta2530 = total(a2530) bys mh: egen ta2530f = total(a2530f) bys mh: egen ta2530m = total(a2530m) bys mh: egen ta3135 = total(a3135) bys mh: egen ta3135f = total(a3135f) bys mh: egen ta3135m = total(a3135m) bys mh: egen ta3641 = total(a3641) bys mh: egen ta3641f = total(a3641f) bys mh: egen ta3641m = total(a3641m) * Among migrants only bys mh: egen tma1318 = total(ma1318) bys mh: egen tma1318f = total(ma1318f) bys mh: egen tma1318m = total(ma1318m) bys mh: egen tma1924 = total(ma1924) bys mh: egen tma1924f = total(ma1924f) bys mh: egen tma1924m = total(ma1924m) bys mh: egen tma2530 = total(ma2530) bys mh: egen tma2530f = total(ma2530f) bys mh: egen tma2530m = total(ma2530m) bys mh: egen tma3135 = total(ma3135) bys mh: egen tma3135f = total(ma3135f) bys mh: egen tma3135m = total(ma3135m) bys mh: egen tma3641 = total(ma3641) bys mh: egen tma3641f = total(ma3641f) bys mh: egen tma3641m = total(ma3641m) * MARITAL STATUS bys mh: egen tnomarried = total(nomarried) bys mh: egen tnomarriedf = total(nomarriedf) bys mh: egen tnomarriedm = total(nomarriedm) * Among migrants only bys mh: egen tmnomarried = total(mnomarried) bys mh: egen tmnomarriedf = total(mnomarriedf) bys mh: egen tmnomarriedm = total(mnomarriedm) * EDUC bys mh: egen tnopri = total(nopri) bys mh: egen tnoprif = total(noprif) bys mh: egen tnoprim = total(noprim) bys mh: egen tnosec = total(nosec) bys mh: egen tnosecf = total(nosecf) bys mh: egen tnosecm = total(nosecm) bys mh: egen tnosec2 = total(nosec2) bys mh: egen tnosec2f = total(nosec2f) bys mh: egen tnosec2m = total(nosec2m) * Among migrants only bys mh: egen tmnopri = total(mnopri) bys mh: egen tmnoprif = total(mnoprif) bys mh: egen tmnoprim = total(mnoprim) bys mh: egen tmnosec = total(mnosec) bys mh: egen tmnosecf = total(mnosecf) bys mh: egen tmnosecm = total(mnosecm) bys mh: egen tmnosec2 = total(mnosec2) bys mh: egen tmnosec2f = total(mnosec2f) bys mh: egen tmnosec2m = total(mnosec2m) * LAND bys mh: egen tnoland0 = total(noland0) bys mh: egen tnoland0f = total(noland0f) bys mh: egen tnoland0m = total(noland0m) bys mh: egen tnoland10 = total(noland10) bys mh: egen tnoland10f = total(noland10f) bys mh: egen tnoland10m = total(noland10m) bys mh: egen tnoland20 = total(noland20) bys mh: egen tnoland20f = total(noland20f) bys mh: egen tnoland20m = total(noland20m) bys mh: egen tnoland40 = total(noland40) bys mh: egen tnoland40f = total(noland40f) bys mh: egen tnoland40m = total(noland40m) bys mh: egen tnoland41 = total(noland41) bys mh: egen tnoland41f = total(noland41f) bys mh: egen tnoland41m = total(noland41m) * Among migrants only bys mh: egen tmnoland0 = total(mnoland0) bys mh: egen tmnoland0f = total(mnoland0f) bys mh: egen tmnoland0m = total(mnoland0m) bys mh: egen tmnoland10 = total(mnoland10) bys mh: egen tmnoland10f = total(mnoland10f) bys mh: egen tmnoland10m = total(mnoland10m) bys mh: egen tmnoland20 = total(mnoland20) bys mh: egen tmnoland20f = total(mnoland20f) bys mh: egen tmnoland20m = total(mnoland20m) bys mh: egen tmnoland40 = total(mnoland40) bys mh: egen tmnoland40f = total(mnoland40f) bys mh: egen tmnoland40m = total(mnoland40m) bys mh: egen tmnoland41 = total(mnoland41) bys mh: egen tmnoland41f = total(mnoland41f) bys mh: egen tmnoland41m = total(mnoland41m) gen pf = tvsizef/tvsize*100 gen pa1318m = ta1318m/tvsizem gen pa1318f = ta1318f/tvsizef gen pa1924m = ta1924m/tvsizem gen pa1924f = ta1924f/tvsizef gen pa2530m = ta2530m/tvsizem gen pa2530f = ta2530f/tvsizef gen pa3135m = ta3135m/tvsizem gen pa3135f = ta3135f/tvsizef gen pa3641m = ta3641m/tvsizem gen pa3641f = ta3641f/tvsizem gen pmarriedm = tnomarriedm/tvsizem gen pmarriedf = tnomarriedf/tvsizef gen pprim = tnoprim/tvsizem gen pprif = tnoprif/tvsizef gen psecm = tnosecm/tvsizem gen psecf = tnosecf/tvsizef gen psec2m = tnosec2m/tvsizem gen psec2f = tnosec2f/tvsizef gen pland0m = tnoland0m/tvsizem gen pland0f = tnoland0f/tvsizef gen pland10m = tnoland10m/tvsizem gen pland10f = tnoland10f/tvsizef gen pland20m = tnoland20m/tvsizem gen pland20f = tnoland20f/tvsizef gen pland40m = tnoland40m/tvsizem gen pland40f = tnoland40f/tvsizef gen pland41m = tnoland41m/tvsizem gen pland41f = tnoland41f/tvsizef * Among migrants only gen pmf = tnomigf/tnomig*100 gen pma1318m = tma1318m/tnomigm gen pma1318f = tma1318f/tnomigf gen pma1924m = tma1924m/tnomigm gen pma1924f = tma1924f/tnomigf gen pma2530m = tma2530m/tnomigm gen pma2530f = tma2530f/tnomigf gen pma3135m = tma3135m/tnomigm gen pma3135f = tma3135f/tnomigf gen pma3641m = tma3641m/tnomigm gen pma3641f = tma3641f/tnomigm gen pmmarriedm = tmnomarriedm/tnomigm gen pmmarriedf = tmnomarriedf/tnomigf gen pmprim = tmnoprim/tnomigm gen pmprif = tmnoprif/tnomigf gen pmsecm = tmnosecm/tnomigm gen pmsecf = tmnosecf/tnomigf gen pmsec2m = tmnosec2m/tnomigm gen pmsec2f = tmnosec2f/tnomigf gen pmland0m = tmnoland0m/tnomigm gen pmland0f = tmnoland0f/tnomigf gen pmland10m = tmnoland10m/tnomigm gen pmland10f = tmnoland10f/tnomigf gen pmland20m = tmnoland20m/tnomigm gen pmland20f = tmnoland20f/tnomigf gen pmland40m = tmnoland40m/tnomigm gen pmland40f = tmnoland40f/tnomigf gen pmland41m = tmnoland41m/tnomigm gen pmland41f = tmnoland41f/tnomigf egen mx = max(mighist) egen mn = min(mighist) gen mighist100 = (mighist-mn)/(mx-mn)*100 set more off set logtype text ************* ** Table 1 ** ************* log using "M:\Documents\C Manuscripts\Migration History Paper Oct 04\Revisions Dec 08 - PRPR R&R\Analysis Dec 08\Table1.txt", replace tabstat vsize ctript mntrip cvtrip mighist100 prev if year==1994, by(vill84) tabstat vsize ctript mntrip cvtrip mighist100 prev if year==2000, by(vill84) tab mh tab mh year log cl set more off set logtype text log using "M:\Documents\C Manuscripts\Migration History Paper Oct 04\Revisions Dec 08 - PRPR R&R\Analysis Dec 08\Table2_3.txt", replace ************* ** Table 2 ** ************* tabstat pevermigm pevermigf pevermig ctriptm ctriptf ctript, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat mcvtripm mcvtripf mcvtrip, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pnobkkm pnobmam pnoesbm pnonem pnoothm pnobkkf pnobmaf pnoesbf pnonef pnoothf, by(mh) stat(mean) nosep format(%6.0g) nototal *tab mh *********************** ** Table 3 - overall ** *********************** tabstat pf pa1318m pa1924m pa2530m pa3135m pa3641m, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pa1318f pa1924f pa2530f pa3135f pa3641f, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pmarriedm pmarriedf pprim psecm psec2m pprif psecf psec2f, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pland0m pland10m pland20m pland40m pland41m, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pland0f pland10f pland20f pland40f pland41f tvsize, by(mh) stat(mean) nosep format(%6.0g) nototal ************************ ** Table 3 - migrants ** ************************ tabstat pmf pma1318m pma1924m pma2530m pma3135m pma3641m, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pma1318f pma1924f pma2530f pma3135f pma3641f, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pmmarriedm pmmarriedf pmprim pmsecm pmsec2m pmprif pmsecf pmsec2f, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pmland0m pmland10m pmland20m pmland40m pmland41m, by(mh) stat(mean) nosep format(%6.0g) nototal tabstat pmland0f pmland10f pmland20f pmland40f pmland41f tnomig, by(mh) stat(mean) nosep format(%6.0g) nototal log cl *********************** * Alternative TABLE 3 * *********************** * Compare the means of characteristics in the overall and migrant population clear all use "mh_cat" sort vill84 year save "mh_cat", replace use "mig_hist", clear sort vill84 year merge vill84 year using "mh_cat", keep(mh) set more off set logtype text log using "M:\Documents\C Manuscripts\Migration History Paper Oct 04\Revisions Dec 08 - PRPR R&R\Analysis Dec 08\Table3_alt.txt", replace ******************* ** Table 3 - Alt ** ******************* * Overall * tabstat sex age married educ land, by(mh) tabstat age married educ land if sex==0, by(mh) tabstat age married educ land if sex==1, by(mh) * Migrants * tabstat sex age married educ land if outnr==1, by(mh) tabstat age married educ land if outnr==1 & sex==0, by(mh) tabstat age married educ land if outnr==1 & sex==1, by(mh) tab mh tab mh if outnr==1 log cl