clear


set memory 500m


/* Figure 1-3 */


use CPS6203.dta, clear

keep if occ_sample==1


generate byte occman=(occat==1)

generate byte occwhite=(occat==2)

generate byte occblue=(occat==3)


sort sex year

collapse (mean) occman occwhite occblue [fw=wgt] if wgt>=0 & occat~=. , by(sex year)
outsheet using "Results/occ1-3.out", replace




/* Figure 4-13 */


use CPS6203.dta, clear

keep if occ_sample==1
keep if year>=1964


generate byte occman=(occat==1)

generate byte occwhite=(occat==2)

generate byte occblue=(occat==3)


sort sex educ year

collapse (mean) occman occwhite occblue [fw=wgt] if wgt>=0 & occat~=., by(sex educ year)


outsheet using "Results/occ4-13.out", replace




/* Figure 14-19 */


use CPS6203.dta, clear

keep if occ_sample==1

keep if year>=1964


generate byte hsd=(educ==1)

generate byte hsg=(educ==2)

generate byte sc=(educ==3)

generate byte cg=(educ==4)

generate byte pc=(educ==5)


sort sex occat year

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


outsheet using "Results/occ14-19.out", replace




/* Figure 20-27 */


use CPS6203.dta, clear

keep if occ_sample==1

keep if wage_sample==1


sort sex occat year

collapse (mean) mean_wage=real_wage (median) median_wage=real_wage [fw=wgt] if wgt>=0 & occat~=., by(sex occat year)


outsheet using "Results/occ20-27.out", replace