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


Reason for missing MIGSTA1 values in ASEC files for 1985 (and 1995)
India Area-level data (geo2) inconsistent for total population, urban share, ...
Does anyone have a method for handling missing data in CPS "EDUC" variable? 2...
How do I find the data file:Ipumsi_00001.dat for the 1974
Variables from Full Year Consolidated Files currently not included in IPUMS-M...
Wrong HH weight Tanzania 2012 census?
Login   |   Register

Recently Active Members

View More »

Share |