| Link Service availability data in 2011 to Individual/HH? [message #3264] |
Thu, 13 November 2014 14:59  |
vega25
Messages: 14
Registered: April 2014
Location: United States
|
Member |
|
|
Hello,
I see that the community questionnaire fielded in the Bangladesh DHS of 2011 is available in the "Service Availability" dataset. Is the way to link this file with the women's individual or household datasets simply to merge the two datasets on the "cluster" variable? Is there anything else I should be aware of while doing this?
Secondly, would anyone have a recommendation about whether cluster-level variables should be calculated (obviously?) from the Service Availability dataset where the relevant variables of interest are available in it, and/or calculated by aggregating all the individual responses within a cluster?
Thank you very much.
|
|
|
|
|
|
| Re: Link Service availability data in 2011 to Individual/HH? [message #3487 is a reply to message #3481] |
Tue, 16 December 2014 14:07  |
Trevor-DHS
Messages: 802
Registered: January 2013
|
Senior Member |
|
|
1) Yes, use the cluster number for matching.
2) Typically you would use the service availability data to add community attribute data to the individual data and then analyze the individuals. However you can use both calculate variables from the service availability data, or aggregate individual responses, but you have to be careful with what you are doing. If you are aggregating within cluster, realize that the aggregate you produce is based on very few cases and is unlikely to be very representative of that cluster. Also you will need to pay attention to weighting of data when aggregating individual data. Note that as the weights are calculated by cluster, you don't need to weight when calculating the cluster level aggregates, but you will need to weight when aggregating up further, and for that reason you may need to keep aggregates of the numerators and denominators at the cluster level too to facilitate that aggregation. Mostly, though, users use the service availability data as community attributes with the individual level data.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
