18 lines
480 B
Plaintext
18 lines
480 B
Plaintext
clear
|
|
cd e:\chililabdata\data
|
|
use outmigration
|
|
replace out_date=out_date/86400000
|
|
format out_date %td
|
|
gen year = year( out_date)
|
|
drop if year < 2004
|
|
gen round = year-2004
|
|
drop if round > 10
|
|
tostring round, generate(rounds)
|
|
replace rounds = "0" + rounds if strlen(rounds) ==1
|
|
gen socialkey = socialgpid+ rounds
|
|
gen individkey = individid+ rounds
|
|
drop EID socialgpidGuid eventid observeid year
|
|
duplicates drop individkey, force
|
|
drop if round < 0
|
|
save rYOutmigration, replace
|