I am trying to reproduce the median earnings by sex tables published by the Census (Table P-20 (http://www.census.gov/hhes/www/income…). I am using stata and I am using the March CPS files appended over several years. My commands are:
collapse (p50) incwage [pw=wtsupp] if sex==1 & age>=25, by(year)
collapse (p50) incwage [pw=wtsupp] if sex==2 & age>=25, by(year)
The medians I get are close (for most years) to the Census figures but not exact. Can this difference be explained?
Thanks.