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


Hi is there a way to get the foreign born population for a city (Elizabeth, N...
Why is there no age variable prior to 2008 anymore in CPS?
Is there a way that I can convert a DAT file to a STATA file? If so, how is t...
Underlying files for CPS Education Supplements (October)?
Income varialbe values & US variable
Why there is no data for 'VLHALLORG"
Login   |   Register

Recently Active Members

View More »

Share |