Status:Closed    Asked:Dec 04, 2017 - 03:07 PM

Having Trouble Counting Total Households in Data Set

I am trying to count the total number of households in a my dataset that have a child age 5 - 17. After restricting the data to the desired geography and qualifying child present nchild>0 & eldch>4 and yngch<18. I am trying to get the total of households in the data. After applying the person weight I have 499,123 individuals in that population, which makes sense. But when I try to count the total households by taking pernum=1 and applying the household weight I get 264,186 households. This only averages to 1.89 persons per household. How can this be given that all observations are based on individuals with children in the household. Shouldn't I expect a number closer to 200,000?

Thank you for any help.

Do you have the same question? Follow this Question


Nevermind, I got it figured out. I was only counting adults. I apologize to anyone that has to read this idiocy.


Dec 04, 2017 - 04:17 PM

Report it


Replicate weights for use with CPS-TUS
Longitudinal cohort in TUS 2014/2015?
When can we expect NFHS 4 data to included in IPUMS-DHS database?
trying again need more characters
DOINGLW2 variable
SPSS Mac change directory issue
Login   |   Register

Recently Active Members

View More »

Share |