Status:Closed    Asked:Aug 10, 2014 - 02:26 AM

Generate family weights for summary statistics for families (not people or households)

I am trying to generate summary statistics for families in the US – e.g., the number of families that earn below a very specific value (e.g., $12,345).

I understand that family is uniquely identified by the combination of variables ‘serial’ and ‘famunit,’ however, I am unclear on how apply weights to generate estimates for the number of families

Using ACS 2012 1-year estimates, I know from published data that there should be 76,509,262 families in the US. Is there sample STATA code that generates family weights so that I can replicate this value?

I have gotten this far – I can generate incomes by family, but I don’t have a weight to apply: collapse (sum) incwage, by (serial famunit)

Do you have the same question? Follow this Question

Staff Answer




While there is no specific weight generated for families, The Census Bureau uses Housing Unit Weights to generate family-level estimates. A little bit more info on the matter can be found in this forum response. Using the household weight you should be able to get close to published estimates, however, the Public Use file is a subset of the full sample and is subject to additional sampling error and further processing before being released so it is not likely that you will get the exact same figure.

I hope this helps.


Aug 11, 2014 - 09:16 AM

Report it


How does MPC code its race values for the variable “Race”? Some totals do not...
MPC Note: Programming error applying inflation adjustment to multi-year ACS f...
Why are not all the "not in the labour force" categories filled for the EMPST...
Health Insurance Unit in ACS versus MEPS
Login   |   Register

Recently Active Members

View More »

Share |