Improper Universe
Posted: April 17th, 2015, 9:58 am
Hello,
I am very new to CSPro. I am tabulating data from the 2010 Census. I am gathering a variety of information on households. One of the things I need to gather are the number of households with "housing problems" such as those that lack kitchen facilities, plumbing facilities, with more than 1 person per room, and with a cost burden greater than 30% of their income.
I have tallied the total number of households within a certain income group. However, for some reason when I breakdown that total to identify households who at least meet ONE of those "housing problems", I am getting a total that exceeds the income group. I believe my universe to be the problem. Here's an example: unittype = 0 and pnum = 1 and hinc <> 0 and (kitchen = 2 or plumbing = 2 or opr in 3:5 or grapi in 31:50)
Unittype = 0 - housing units only
Pnum= 1 - will only pull out the householder (or head of household's) ethnic background
Hinc <> 0 - do not count households with zero/negative income
Kitchen = 2 - lacks kitchen facilities
Plumbing = 2 - lacks plumbing facilities
Opr in 3:5 - More than 1 person per room
Grapi in 31:50 - households who spend more than 30% but less than 50% of their income on rent
Any thoughts on how I can fix this? Or what I am doing wrong.
I am very new to CSPro. I am tabulating data from the 2010 Census. I am gathering a variety of information on households. One of the things I need to gather are the number of households with "housing problems" such as those that lack kitchen facilities, plumbing facilities, with more than 1 person per room, and with a cost burden greater than 30% of their income.
I have tallied the total number of households within a certain income group. However, for some reason when I breakdown that total to identify households who at least meet ONE of those "housing problems", I am getting a total that exceeds the income group. I believe my universe to be the problem. Here's an example: unittype = 0 and pnum = 1 and hinc <> 0 and (kitchen = 2 or plumbing = 2 or opr in 3:5 or grapi in 31:50)
Unittype = 0 - housing units only
Pnum= 1 - will only pull out the householder (or head of household's) ethnic background
Hinc <> 0 - do not count households with zero/negative income
Kitchen = 2 - lacks kitchen facilities
Plumbing = 2 - lacks plumbing facilities
Opr in 3:5 - More than 1 person per room
Grapi in 31:50 - households who spend more than 30% but less than 50% of their income on rent
Any thoughts on how I can fix this? Or what I am doing wrong.