gen lnw=ln(incwage)

* Educational variables
gen prim=educrec==1|educrec==2|educrec==3
gen highschdropout=educrec==4|educrec==5|educrec==6
gen highsch=educrec==7
gen somecol=educrec==8
gen colmore=educrec==9
gen educ=0
replace educ=2.5 if educrec==2
replace educ=6.5 if educrec==3
replace educ=9 if educrec==4
replace educ=10 if educrec==5
replace educ=11 if educrec==6
replace educ=12 if educrec==7
replace educ=14 if educrec==8
replace educ=16 if educrec==9
drop educrec
gen age2=age^2


gen race=racblk-1
gen hispanic=0
replace hispanic=1 if hispan>0

bys pwmetro: egen ctycom=mean(trantime)
bys pwmetro: egen emp=sum(perwt)
gen lemp=ln(emp)
bys pwmetro occ: egen empocc=sum(perwt)
gen lempocc=ln(empocc)