The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Côte d'Ivoire 1998 DHS
Côte d'Ivoire 1998 DHS [message #10701] Thu, 01 September 2016 06:55 Go to next message
baremma2002 is currently offline  baremma2002
Messages: 20
Registered: April 2013
Member
Dear DHS users,

I still have one question. I think this one has not been asked anywhere:

In average, how many households were there in each urban enumeration area (EA) and in each rural EA in 1998 Côte d'Ivoire DHS?

Thank you.
Re: Côte d'Ivoire 1998 DHS [message #10707 is a reply to message #10701] Fri, 02 September 2016 06:30 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2307
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Here's how to do this in Stata:
* open the PR file
use ...CIPR3AFL.dta, clear

set more off

* reduce to one record per household
keep if hvidx==1

gen n=1

* add up the number of households in each cluster
collapse (sum) n, by(hv001)

summarize 
tab n

Here's the result. There were 140 clusters. The number of households per cluster ranged from 7 to 41, was 9 or 10 in a third of the clusters, and the mean was 15.2 households per cluster.


. summarize 

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
       hv001 |        140      103.85    73.81436          1        248
           n |        140    15.15714    7.107875          7         41
.

. tab n

    (sum) n |      Freq.     Percent        Cum.
------------+-----------------------------------
          7 |          2        1.43        1.43
          8 |          4        2.86        4.29
          9 |         22       15.71       20.00
         10 |         25       17.86       37.86
         11 |          9        6.43       44.29
         12 |          5        3.57       47.86
         13 |          8        5.71       53.57
         14 |          6        4.29       57.86
         15 |          9        6.43       64.29
         16 |          8        5.71       70.00
         17 |          3        2.14       72.14
         18 |          4        2.86       75.00
         19 |          3        2.14       77.14
         20 |          3        2.14       79.29
         21 |          3        2.14       81.43
         22 |          5        3.57       85.00
         23 |          4        2.86       87.86
         25 |          4        2.86       90.71
         26 |          1        0.71       91.43
         27 |          1        0.71       92.14
         28 |          2        1.43       93.57
         30 |          2        1.43       95.00
         31 |          1        0.71       95.71
         33 |          1        0.71       96.43
         34 |          1        0.71       97.14
         35 |          3        2.14       99.29
         41 |          1        0.71      100.00
------------+-----------------------------------
      Total |        140      100.00

If you replace the last two Stata lines with

collapse (sum) n, by(hv001 hv025)
tab hv025, summarize(n)

Then you get the following results separately by urban and rural areas.
    type of |
   place of |         Summary of (sum) n
  residence |        Mean   Std. Dev.       Freq.
------------+------------------------------------
      urban |       14.21   6.0607947         100
      rural |      17.525    8.875167          40
------------+------------------------------------
      Total |   15.157143   7.1078753         140
Previous Topic: Côte d'Ivoire 1994 DHS
Next Topic: Guatemala 2014-2015 data
Goto Forum:
  


Current Time: Sat Jun 19 06:05:33 Coordinated Universal Time 2021