Status:Closed    Asked:Oct 24, 2014 - 09:28 AM

Calculating Median Earnings with March CPS: comparing to Census Tables

I am trying to reproduce the median earnings by sex tables published by the Census (Table P-20 ( 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?


Do you have the same question? Follow this Question

Staff Answer




I replicated the small differences that you are seeing between the microdata and published tables. We do not have an explanation for this difference, but this is very common when comparing microdata estimates and published statistics using CPS data. You could consider contacting the Census Bureau directly with your question.

I am sorry that I could not be of more direct assistance.


Oct 28, 2014 - 01:31 PM

Report it


zero wages
Sample weights
tehre is information about the size of the firm in the Census/ASEC datasets?
Sample selection for a study of a subgroup over time?
Is it possible to get information on municipality or district of respondent i...
Weekly earnings and usual hours
Login   |   Register

Recently Active Members

View More »

Share |