83 lines
2.2 KiB
Plaintext
83 lines
2.2 KiB
Plaintext
cd e:\chililabdata\data
|
|
clear
|
|
set mem 500M
|
|
use individual, clear
|
|
sort individid
|
|
save individual, replace
|
|
use inmigration
|
|
sort individid
|
|
merge individid using individual
|
|
drop if _merge !=3
|
|
drop _merge
|
|
gen communeid= substr(locationid, 1,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")
|
|
gen age = floor((img_date-birthdate)/365.5)
|
|
sort individid
|
|
gen quarterdate = qofd(img_date)
|
|
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)
|
|
tostring quarterdate, generate (key)
|
|
replace key = individid + key
|
|
drop eventid observeid appround bornid quarterdate individidGuid motheridGuid fatheridGuid
|
|
sort key
|
|
save inout\allinmigration, replace
|
|
|
|
keep key
|
|
sort key
|
|
|
|
merge key using crosseducationtemp
|
|
keep if _merge !=2
|
|
drop observeid obs_de_date refdate period p quarterdate refquarter maxobs_de_date _merge individid fatherid motherid
|
|
sort key
|
|
merge key using inout/allinmigration
|
|
|
|
drop _merge
|
|
sort key
|
|
save inout/allinmigration , replace
|
|
|
|
keep key
|
|
sort key
|
|
merge key using crossoccupationtemp
|
|
keep if _merge !=2
|
|
drop individid observeid obs_de_date refdate period p quarterdate refquarter maxobs_de_date fatherid motherid partnerid _merge
|
|
sort key
|
|
merge key using inout/allinmigration
|
|
drop _merge
|
|
sort key
|
|
save inout/allinmigration , replace
|
|
|
|
keep key
|
|
sort key
|
|
merge key using crossmarstatustemp
|
|
keep if _merge !=2
|
|
drop individid observeid obs_de_date period p quarterdate maxobs_de_date _merge
|
|
sort key
|
|
merge key using inout/allinmigration
|
|
drop _merge
|
|
drop key
|
|
|
|
gen quarterdate = qofd(img_date)
|
|
tostring quarterdate, gen(key)
|
|
replace key = socialgpid + key
|
|
sort key
|
|
save inout/allinmigration , replace
|
|
keep key
|
|
sort key
|
|
brow
|
|
merge key using householdinfortemp
|
|
keep if _merge !=2
|
|
drop _merge
|
|
sort key
|
|
merge key using inout/allinmigration
|
|
drop _merge
|
|
sort key
|
|
drop quarterdate refquarter
|
|
save inout/allinmigration, replace
|
|
|
|
cd e:\chililabdata
|
|
|
|
|