cd "G:\Price\data"

use acs, clear

keep if age>=18 & age<67

drop if inctot<0

rename inctot income

*collapse (mean)income, by (age)

drop if educ==0
drop if educ==.
gen less_hs=0
replace less_hs=1 if educ<=5
gen hs=0
replace hs=1 if educ==6
gen some_coll=0
replace some_coll=1 if educ==7 | educ==8
gen coll=0
replace coll=1 if educ>=10

gen female=0
replace female=1 if sex==2

gen married=0
replace married=1 if marst==1 | marst==2

order income age female marriage less_hs hs some_coll coll occ

save "E:\My Drive\Heal STATA Trainings\Training 3\data\training_3_data", replace