clear

set mem 500m




/** Figures 1-3 **/


use CPS6203.dta, clear

keep if wage_sample==1


sort sex year

collapse (mean) mean_wage=real_wage (median) med_wage=real_wage [fw=wgt] if wgt>=0, by(sex year)

outsheet using "Results/macro1-3.out", replace





/** Figures 4-7 **/


use CPS6203.dta, clear

keep if wage_sample==1

keep if year>=1964


sort sex educ year

collapse (mean) mean_wage=real_wage [fw=wgt] if wgt>=0, by(sex educ year)

outsheet using "Results/macro4-7.out", replace





/** Figures 8-11 **/


use CPS6203.dta, clear

keep if wage_sample==1


gen wage_w = real_wage if race==1  &  hispanic ==0 

gen wage_b = real_wage if race==2  &  hispanic ==0 

gen wage_o = real_wage if race==3  &  hispanic ==0 

gen wage_h = real_wage if hispanic==1 


sort sex year 

collapse (mean) wage_w wage_b wage_o wage_h [fw=wgt] if wgt>=0, by(sex year) 

outsheet using "Results/macro8-11.out", replace





/** Figures 12-14 **/


use CPS6203.dta, clear

keep if wage_sample==1

keep if year>=1964


gen byte educ4cat=educ

replace educ4cat=4 if educ==5


sort sex educ4cat year 

collapse  (mean) real_wage  [fw=wgt]  if wgt>=0, by(sex educ4cat year)

outsheet using "Results/macro12-14.out", replace