cd e:\chililabdata
clear all
do pdo1
global refdate = $endTime 
do ..\GenCrossEducation 
do ..\GenCrossOccupation 
use individual, clear
sort individid
save, replace
use observation
sort observeid
save observation, replace
use birth
drop if bth_date < $startTime 
drop if bth_date > $endTime 
sort individid
merge individid using individual, nokeep keep (motherid gender)
rename gender cgender
keep if _merge==3
save $savefolder\allbirths$suffix, replace
drop _merge
rename individid childid
rename motherid individid
sort individid
drop if individid ==""
merge individid using individual, nokeep keep(birthdate )
drop if _merge == 2
gen age = (bth_date - birthdate)/365.25
replace age = floor(age)
drop _merge
sort observeid
merge observeid using observation
drop if _merge!=3
drop _merge
gen communeid = substr(locationid, 1,2)
sort individid
gen refquarter = qofd(bth_date)
tostring refquarter, generate (key)
replace key = individid + key
sort key
merge key using crosseducationtemp, nokeep keep (eduid)
drop _merge
sort key
merge key using crossoccupationtemp, nokeep keep (occupationid)
drop if _merge==2
gen area=1
replace area=2 if (communeid=="02")
replace area=2 if (communeid=="04")
replace area=2 if (communeid=="05")
replace area=2 if (communeid=="07")
drop key
recode age (min/0=1 "<1") (1/4=2 "1-4") (5/9=3 "5-9")(10/14=4 "10-14") (15/19=5 "15-19") (20/24=6 "20-24") (25/29=7 "25-29") (30/34=8 "30-34") (35/39=9 "35-39") (40/44=10 "40-44") (45/49=11 "45-49")(50/54=12 "50-54") (55/59=13 "55-59") (60/64=14 "60-64") (65/69=15 "65-69") (70/74=16 "70-74") (75/79=17 "75-79") (80/max=18 ">=80") , gen (agegrp)
save $savefolder\birthsFullwithmother$suffix, replace
gen Births =1
collapse (sum) Births, by(communeid agegrp age )
save $savefolder\Birthsby_commune_age$suffix, replace
collapse (sum) Births, by(communeid agegrp )
save $savefolder\birthsby_commune_agegrp$suffix, replace
collapse (sum) Births, by(agegrp )
save $savefolder\birthsby_agegrp$suffix, replace
use $savefolder\birthsFullwithmother$suffix
gen Births =1
collapse (sum) Births, by(area agegrp age )
save $savefolder\Birthsby_area_age$suffix, replace
collapse (sum) Births, by(area agegrp )
save $savefolder\birthsby_area_agegrp$suffix, replace
use $savefolder\birthsFullwithmother$suffix
gen Births =1
collapse (sum) Births, by(area communeid eduid )
save $savefolder\Birthsby_commune_edu$suffix, replace
collapse (sum) Births, by(area eduid )
save $savefolder\birthsby_area_edu$suffix, replace

use $savefolder\birthsFullwithmother$suffix
gen Births =1
collapse (sum) Births, by(area communeid occupationid )
save $savefolder\Birthsby_commune_occupation$suffix, replace
collapse (sum) Births, by(area occupationid )
save $savefolder\birthsby_area_occupation$suffix, replace

cd e:\chililabdata