I am working in a dataset that has both household and individual level variables. We have a total of 1,217 households in the sample. I'm trying to figure out how many households in the sample have had at least 1 individual diagnosed with malaria in the last twelve months. Each household survey asks questions about individuals in the household. So, the variable inm1_malaria is an individual level variable and represents the question "Has NAME been diagnosed with malaria in the last 12 months?
When I tab inm1_malaria (the individual level variable), I of course get more observations than total number of households in the sample because there are more than 1 individuals per household. When I say: tab hh_no if inm1_malaria==1, I still get more observations than we have households. It's counting each hh_no each time that hh_no is assigned to an individual in the dataset. So if there are 4 individuals with hh_no CHP/02/0004, it is counting that as 4 separate households.
Any advice on how to get household level data from the individual observations nested within the household would be much appreciated.
Best,
Nancy
Related Posts with Multiple individuals per household id number: how to get household information from individual observations
Egen with weights?Hello, I am new to Stata and I am trying to calculate the proportion of women in different regions …
Using loop to create state-codes for statesHi, I have the following states. I want to assign a 2-digit code to each state. The dataex is given…
How to plot these graphs?Dear all, I want to plot two graphs shown pictures below. I would appreciate if anyone can help me …
Can I take fixed effects( such as country id) as a continues covariate to controlHi guys, I am using a cross-section data to run 2sls regression. And there is a bunch of dummies com…
Stochastic Search and Optimization in StataDear all, I am having a panel data of some quality indicators say ind1 ind2 it's up to ind8 and som…
Subscribe to:
Post Comments (Atom)
0 Response to Multiple individuals per household id number: how to get household information from individual observations
Post a Comment