Status:Closed    Asked:Aug 17, 2017 - 03:25 PM

Pooling single years of CPS into multiyear

I am trying to see particular CPS-ASEC questions at the local level (county or city), which it is not designed to do. So I am combining single CPS years into a multiple-year sample, hoping to make it sufficiently large to use at local level. But how do I handle the weighting? Each year carries a distinctive weight that cannot be applied to other years. So do I simply run each year individually with those weights, then combine the resulting weighted figures together, then take an annual average? And other than weights, any other warnings or pointers about pooling CPS across time? Thanks.

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


There is really not one particular method for pooling and weighting CPS data across samples. The method you propose sounds reasonable. Another possibility is to divide your sample weight by the number of samples you are combining. So, for example, if you are pooling 10 samples together you'd divide the sample weight by 10 in your pooled sample. This is undoubtably imperfect, so you may want to try a couple different methods and see how the results compare.

I hope this is helpful.


Aug 18, 2017 - 09:32 AM

Report it




Aug 18, 2017 - 10:37 AM

Report it


Why is the income wage variable incwage-capped? and how is the cap determined...
USA IPUMS 1980 ancestry variable -- mapping to country names
Did the version of database change since 2011?
Are DATANUM, SERIAL, and PERNUM the same in single-year and 5-year ACS sample...
How can I accurately calculate the median family income by state for families...
Detailed Variables Dropping From Dataset
Login   |   Register

Share |