clear


set mem 500m



/** Figure 1-3 **/


use CPS6203.dta

keep if emp_sample==1


gen byte emp=(emp_stat==1 | emp_stat==2) 

gen byte unemp=(emp_stat==3)

gen byte lfp=(emp_stat==1 | emp_stat==2 | emp_stat==3)

gen byte olf=(emp_stat==7)


sort sex year 

collapse (mean) emp lfp unemp olf [fw=wgt] if wgt>=0, by (sex year)

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




/** Figure 4-9 **/


use CPS6203.dta, clear

keep if emp_sample==1

keep if year>=1964


gen byte emp=(emp_stat==1 | emp_stat==2) 

gen byte unemp=(emp_stat==3)

gen byte lfp=(emp_stat==1 | emp_stat==2 | emp_stat==3)

gen byte olf=(emp_stat==7)


sort sex educ year 

collapse (mean) emp lfp unemp olf [fw=wgt] if wgt>=0, by (sex educ year)

outsheet using "Results/emp4-9.out", replace




/** Figure 10-15 **/


use CPS6203.dta, clear

keep if emp_sample==1


gen byte emp=(emp_stat==1 | emp_stat==2) 

gen byte unemp=(emp_stat==3)

gen byte lfp=(emp_stat==1 | emp_stat==2 | emp_stat==3)

gen byte olf=(emp_stat==7)


gen byte white=(race==1)


sort sex white year 

collapse (mean) emp lfp unemp olf [fw=wgt] if wgt>=0, by (sex white year)

outsheet using "Results/emp10-15.out", replace




/** Figure 16-17 **/


use CPS6203.dta, clear

keep if week_sample==1


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

outsheet using "Results/emp16-17.out", replace




/** Figure 18-19 **/


use CPS6203.dta, clear

keep if week_sample==1

keep if year>=1964


sort sex educ year 

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

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




/** Figure 20-21 **/


use CPS6203.dta, clear

keep if week_sample==1


gen byte white=(race==1)


sort sex white year 

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

outsheet using "Results/emp20-21.out", replace




/* Figures 22-23 **/


use CPS6203.dta, clear

keep if emp_sample==1

keep if year>=1971 & year<=2002



gen byte emp=(emp_stat==1 | emp_stat==2) 

gen byte unemp=(emp_stat==3)

gen byte lfp=(emp_stat==1 | emp_stat==2 | emp_stat==3)

gen byte olf=(emp_stat==7)



sort sex occat year 

collapse (mean) emp lfp unemp olf [fw=wgt] if wgt>=0, by (sex occat year)

outsheet using "Results/emp22-23.out", replace