Your help would be extremely help when it comes to the FAMINC variable. I am having issues finding an accurate number of households when using the FAMINC variable.
As an example, the only sample I am pulling is 2018 (for simplicity sake right now), and the only variables are STATEFIP & FAMINC.
When creating the data extract this gives me 10 variables (YEAR, SERIAL, MONTH, HWTFINL, CPSID, ASECFLAG, ASECWTH, PERNUM, WTFINL, CPSIDP, STATEFIP and FAMINC)
Using R, I am removing any duplicates of serial numbers for each household, by grouping by SERIAL then slice. When adding the weights, I get a total of 8.8 million households. According to census data for 2018 though, there were roughly 7.6 million households (MOE +/- 23,468)
I have tried to multiple times to get the number of households even remotely close to the 7.6 million number and cannot.
Once I feel comfortable getting the correct number of households, I can expand the research as I am trying to gauge the fluctuation of household income over the past 36 months.
Is there an additional variable I need to add to the original data pull?
Any assistance would be greatly appreciated. Thank you.