I’m currently attempting to match the family status estimates in Table H-01 of the Census’ tables on health insurance coverage and would love some insight into what I am potentially getting wrong!
Specifically, I’m interested in the values in column B of the Excel workbook (the “Total” column). The specific categories I’m attempting to match under the “Family Status” bolded header are “In families”, “Householder”, “In unrelated subfamilies”, and “Unrelated individuals”.
I was able to get a spot-on match for the “Householder” and “In unrelated subfamilies” group using IPUMS microdata, so those groups are not an issue. However, I’m having difficulties matching the “In families” and “Unrelated individuals” groups.
For “In families”, I’m filtering my extract using FAMREL (specifically FAMREL != 0) and then summing the ASECWT. For “Unrelated individuals”, I’m filtering my extract using FAMREL (specifically FAMREL == 0) and then summing the ASECWT.
While the estimates I obtain are close to the Census estimates, they are still off by a large enough amount that I’m not 100% comfortable proceeding with my additional analyses. Any insight into how I could better filter the data to try to match the Census estimates would be greatly appreciated!