clear

set mem 500m



/* Figure 1-2 */


use CPS6203.dta

keep if emp_sample==1

keep if emp_stat==1 | emp_stat==2

keep if year>=1964


gen byte hsd=(educ==1)

gen byte hsg=(educ==2)

gen byte sc=(educ==3)

gen byte cg=(educ==4)

gen byte pc=(educ==5)


sort sex year 

collapse (mean) hsd hsg sc cg pc [fw=wgt] if wgt>=0, by (sex year)

outsheet using "Results/comp1-2.out", replace




/* Figure 3-4 */


use CPS6203.dta, clear

keep if emp_sample==1
keep if emp_stat==1 | emp_stat==2 | emp_stat==3

keep if year>=1964


gen byte hsd=(educ==1)

gen byte hsg=(educ==2)

gen byte sc=(educ==3)

gen byte cg=(educ==4)

gen byte pc=(educ==5)


sort sex year 
collapse (mean) hsd hsg sc cg pc [fw=wgt] if wgt>=0, by (sex year)

outsheet using "Results/comp3-4.out", replace




/* Figure 5-6 */


use CPS6203.dta, clear

keep if emp_sample==1

keep if year>=1964


gen byte hsd=(educ==1)

gen byte hsg=(educ==2)

gen byte sc=(educ==3)

gen byte cg=(educ==4)

gen byte pc=(educ==5)


sort sex year 

collapse (mean) hsd hsg sc cg pc [fw=wgt] if wgt>=0, by (sex year)

outsheet using "Results/comp5-6.out", replace




/* Figure 7 */


use CPS6203.dta, clear

keep if emp_sample==1

keep if emp_stat==1 | emp_stat==2 | emp_stat==3

keep if year>=1964


gen byte hsdm=(educ==1 & sex==1)

gen byte hsgm=(educ==2 & sex==1)

gen byte scm=(educ==3 & sex==1)

gen byte cgm=(educ==4 & sex==1)

gen byte pcm=(educ==5 & sex==1)


gen byte hsdf=(educ==1 & sex==2)

gen byte hsgf=(educ==2 & sex==2)

gen byte scf=(educ==3 & sex==2)

gen byte cgf=(educ==4 & sex==2)

gen byte pcf=(educ==5 & sex==2)
sort year 

collapse (mean) hsdm hsgm scm cgm pcm hsdf hsgf scf cgf pcf [fw=wgt] if wgt>=0, by (year)

outsheet using "Results/comp7.out", replace