clear set mem 500m /* Figure 1-2 */ use CPS6203.dta, clear keep if wage_sample==1 gen lnwage=log(real_wage) sort sex year collapse (sd) lnwage [fw=wgt] if wgt>=0, by(sex year) outsheet using "Results/stdev1-2.out", replace /* Figure 3-6 */ use CPS6203.dta, clear keep if wage_sample==1 keep if year>=1964 gen lnwage=log(real_wage) sort sex educ year collapse (sd) lnwage [fw=wgt] if wgt>=0, by(sex educ year) outsheet using "Results/stdev3-6.out", replace /* Figure 7-8 */ use CPS6203.dta, clear keep if wage_sample==1 keep if ph==0 & farmhand==0 & farmer==0 gen lnwage=log(real_wage) sort sex year collapse (sd) lnwage [fw=wgt] if wgt>=0, by(sex year) outsheet using "Results/stdev7-8.out", replace