I have two questions about using the CPS Outgoing Rotation Group data.
- I downloaded the Outgoing Rotation Group data by going to IPUMS-CPS and selected all of the person-level variables under “Outgoing Rotation Groups (Earner Study).” I dropped all observations whose month-in-sample value was not 4 or 8. However, when I try to replicate the union membership numbers on unionstat.com, which also uses the CPS-MORG data to run descriptive statistics by year, I find that the number of observations by year available through IPUMS is around 1/5 the number used to produce the numbers on unionstat.com. When I weight by earnwt/12, I also find the the number of union members in the U.S. by year is 20-50% lower than the estimates available through the BLS. Here is the Stata code I used:
gen annualwt = earnwt / 12
sum empl [iw=annualwt] if year== 1984
sum unmem [iw=annualwt] if year== 1984
Does anyone know why I can’t get accurate population estimates using the CPS-MORG data available through IPUMS-CPS with the above weighting?
- Which CPS weight should i use to find the % female workers by year in my CPS-MORG dataset?