clear
set more off
set mem 5000m

/*
use ~/research/outsourcing/datafiles/cew_data
table year sic, c(mean emp) f(%9.0fc)

use ~/morg/datafiles/morg_pool, clear
collapse (sum) earnwt,by(man7090 year) fast
replace earnwt=earnwt/1000
table year man7090, c(mean earnwt) f(%9.0fc)
save /Sastemp/check1, replace

use ~/morg/datafiles/morg_pool, clear
collapse (sum) earnwt,by(occ8090 year) fast
table year occ8090, c(mean earnwt) f(%9.0fc)
save /Sastemp/check2, replace
*/
use ~/morg/datafiles/morg_pool, clear
collapse ehf finger dcp sts math [w=earnwt],by(man7090 year) fast