Hi All,

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

display r(sum)

sum unmem [iw=annualwt] if year== 1984

display r(sum)

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?

Many thanks!