The DHS Program User Forum: India » urban-rural variable

Home » Countries » India » urban-rural variable

Show: Today's Messages :: Show Polls :: Message Navigator

Re: urban-rural variable [message #4243 is a reply to message #4226]

Fri, 24 April 2015 15:21

Trevor-DHS
Messages: 800
Registered: January 2013

Senior Member

It wasn't very clear from your explanation which survey and datasets you are using, but it appears that you are using the HIV tests results data, matched with other datasets. However it appears that there is a problem with the matching of your data. I would expect the number of women and men to be roughly equal, but you have twice as many men as women. Below is a short piece of code for matching with the persons recode file, and for checking the sex distribution:

cd "C:\Data\DHS_Stata"
use "IAPR52FL.dta"
clonevar hivclust = hv001
clonevar hivnumb = hv002
clonevar hivline = hvidx
merge 1:1 hivclust hivnumb hivline using "IAAR51FL.dta"
keep if _merge==3
tab hv104
tab hv025
tab sh025
tab sh025 hv025

From this, I received the following output:

. tab hv104

     sex of |
  household |
     member |      Freq.     Percent        Cum.
------------+-----------------------------------
       male |     51,641       48.88       48.88
     female |     54,016       51.12      100.00
------------+-----------------------------------
      Total |    105,657      100.00

. tab hv025

    type of |
   place of |
  residence |      Freq.     Percent        Cum.
------------+-----------------------------------
      urban |     52,697       49.88       49.88
      rural |     52,960       50.12      100.00
------------+-----------------------------------
      Total |    105,657      100.00

. tab sh025

city\town\c |
 ountryside |      Freq.     Percent        Cum.
------------+-----------------------------------
  mega city |      8,696        8.23        8.23
 large city |     21,989       20.81       29.04
 small city |      6,352        6.01       35.05
 large town |      1,671        1.58       36.64
 small town |     13,989       13.24       49.88
      rural |     52,960       50.12      100.00
------------+-----------------------------------
      Total |    105,657      100.00

. tab sh025 hv025

city\town\ |   type of place of
countrysid |       residence
         e |     urban      rural |     Total
-----------+----------------------+----------
 mega city |     8,696          0 |     8,696 
large city |    21,989          0 |    21,989 
small city |     6,352          0 |     6,352 
large town |     1,671          0 |     1,671 
small town |    13,989          0 |    13,989 
     rural |         0     52,960 |    52,960 
-----------+----------------------+----------
     Total |    52,697     52,960 |   105,657

As you can see in my tables (unweighted) there are about 49% men and 51% women, which is roughly what I would expect.
Also, as you can see the recoding of urban and rural makes sense in the last table.

Report message to a moderator

[Message index]

		urban-rural variable By: menonidhi on Tue, 21 April 2015 10:14
		Re: urban-rural variable By: Trevor-DHS on Fri, 24 April 2015 15:21

Previous Topic:	Dowry in NFHS
Next Topic:	Village identifiers in NFHS3

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jul 14 00:40:17 Coordinated Universal Time 2024