The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Countries » Kenya » Proportions
Proportions [message #10603] Tue, 16 August 2016 06:22 Go to next message
Khanjila is currently offline  Khanjila
Messages: 7
Registered: July 2016
I would like to create the proportion of households in a cluster that have access to electricity.

This is what I have done:

bys hv001: gen proportion= sum(hv206)/_N
bys hv001: replace proportion= proportion[_N]

However, I realized that since there can be duplicate households in a cluster as shown below. (This is because my study is focusing on impact of electricity on school attendance and so there can multiple children in a household who attend school)
hv001	hv002
2	76
2	76
2	76
3	7
3	7
3	23
3	39
3	39
3	39
3	47
3	56
3	80
3	80

I tried using
duplicates drop household number

Before proceeding with the previous syntax. But my sample reduced drastically to around 147 from about 9000.

Is there something I am doing wrong?
Or is there a better method of getting the proportion of households in a cluster with access to electricity?
Re: Proportions [message #10608 is a reply to message #10603] Tue, 16 August 2016 10:40 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1197
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

I suggest that you construct the proportion of households in the cluster that have electricity with a collapse command. You could do this from the HR file or from the PR file, selecting one record per household. Then merge that back with the PR file or whatever other file you are using. The lines below show how to construct this proportion. You do not need to use the weights because the weights are constant within clusters. Let me know if this is not what you need.

use KEPR70FL.dta, clear
keep if hvidx==1
keep hv001 hv206
tab hv206
collapse (mean) hv206, by(hv001)
rename hv206 electricity
label variable electricity "Prop. of hh in cluster with elect."
sort hv001
* next merge this file with whatever other file you are using
Previous Topic: Aggregating household level data
Next Topic: House hold sample weight
Goto Forum:

Current Time: Tue Jan 23 00:54:09 Eastern Standard Time 2018