The DHS Program User Forum
Discussions regarding The DHS Program data and results
Today's Messages (off)  | Unanswered Messages (on)

Forum: HIV
Topic: Household weights after merging AR (HIV) and HR (household) files
Household weights after merging AR (HIV) and HR (household) files Mon, 17 June 2019 11:36
 ruland Messages: 1Registered: June 2019 Member
Hi all,

I'm planning to compute the proportion of households with at least one member tested positive for HIV (for India 2015-16 DHS, for example). I'm not sure how to get the weight for this.

I would want:

Population base: households, at least one person was tested for HIV (HR file, AR file).
Numerator: Number of households where at least one person was tested positive for HIV (for each HIVNUMB in AR, calculate whether at least one person tested positive for HIV using hiv03 in 1:3. Then merge to HR)
Denominator: Number of households where at least one person was tested for HIV (for each HIVNUMB in AR that contains hiv03 in 0:7, 9, merge to HR)

My question is how should I get the weight?

My attempt: maybe I should not use the HIV weight at all (HIV05), but rather multiply the household weight (HV005) by a factor that's inversely proportional to the probability of being in the population base (as defined above). This factor is thus calculated for each DHS cluster as: 1 / (the number of households with at least one person tested for HIV / total number of households in the DHS cluster).

So my final weight would be: HV005 / (the number of households with at least one person tested for HIV / total number of households in the DHS cluster).

Does any of this make sense? Is this weight calculation correct? Any idea appreciated, thank you!!

As a reference: I found this link, which describes how to compute the HIV prevalence among couples:
https://dhsprogram.com/Data/Guide-to-DHS-Statistics/index.ht m#t=HIV_Prevalence_among_Couples.htm
I don't understand why the HIV weight for the men is used as the weight for couples here...

[Updated on: Mon, 17 June 2019 11:38]

Report message to a moderator

Forum: Reproductive Health
Topic: Surveys with menopause
Surveys with menopause Mon, 17 June 2019 09:22
 L.Brown11@lse.ac.uk Messages: 9Registered: August 2018 Location: London Member
Dear DHS Forum,

I just wanted to check whether there a list of DHS surveys that include menopause questions (i.e. v215 and/or v226) akin to the list provided for menarche in this thread:

https:// userforum.dhsprogram.com/index.php?t=msg&goto=16341& &srch=menarche#msg_16341?

Many thanks,

Laura
Forum: General
Topic: Month of birth recording in IR
Month of birth recording in IR Wed, 12 June 2019 07:38
 Alexis Messages: 1Registered: June 2019 Location: United Kingdom Member
Hello,

I'm working on multiple DHS datasets and I wanted to use the information on the month of birth of women in IR datasets. However, it is common that the distribution of months of birth is not evenly distributed and that more women are born at the beginning of the year than at the end of the year. This is still the case when I use the v014 variable to only keep observations with complete age information.

As an example please see below some surveys with a large bias but there are many more surveys that seems to show this pattern. This is using the month of birth of women; months of birth of children seem to be more evenly distributed. I understand that there might be no birth certificate but I'm surprised that it is always biased towards the beginning of the year. Do interviewers record January if they are not sure of the month of birth?

Burkina Faso 2014 (BFIR70FL):
. tab v009 if v014==1 [aw=v005]

respondent'
s month of
birth Freq. Percent Cum.

1 3,052.2068 47.88 47.88
2 327.201778 5.13 53.01
3 309.809501 4.86 57.87
4 314.853944 4.94 62.81
5 262.622618 4.12 66.93
6 267.081004 4.19 71.12
7 271.175631 4.25 75.37
8 256.894687 4.03 79.40
9 227.786846 3.57 82.97
10 318.383412 4.99 87.97
11 212.438137 3.33 91.30
12 554.545677 8.70 100.00

Total 6,375 100.00

Afghanistan 2015 (AFIR70FL)
. tab v009 if v014==1 [aw=v005]

respondent' |
s month of |
birth | Freq. Percent Cum.
------------+-----------------------------------
1 | 1,614.1386 9.09 9.09
2 | 2,544.3889 14.33 23.42
3 | 2,428.1078 13.67 37.09
4 | 1,774.7469 9.99 47.08
5 | 1,863.0132 10.49 57.57
6 |1,601.14519 9.02 66.59
7 | 1,208.168 6.80 73.39
8 | 1,007.6137 5.67 79.07
9 | 1,256.037 7.07 86.14
10 | 1,034.7895 5.83 91.97
11 | 808.320749 4.55 96.52
12 |618.5304505 3.48 100.00
------------+-----------------------------------
Total | 17,759 100.00

Cote d'Ivoire 2011-12 (CIIR62FL)
. tab v009 if v014==1 [aw=v005]

respondent' |
s month of |
birth | Freq. Percent Cum.
------------+-----------------------------------
1 | 2,546.0023 29.45 29.45
2 | 715.87848 8.28 37.74
3 | 656.813988 7.60 45.33
4 | 542.819071 6.28 51.61
5 | 572.299899 6.62 58.23
6 | 532.295654 6.16 64.39
7 | 509.972343 5.90 70.29
8 | 508.296997 5.88 76.17
9 | 411.078436 4.76 80.93
10 | 400.15638 4.63 85.56
11 | 398.032321 4.60 90.16
12 | 850.354166 9.84 100.00
------------+-----------------------------------
Total | 8,644 100.00

Forum: Merging data files
Topic: How to combine male and women data for 3 rounds of DHS Pakistan?
How to combine male and women data for 3 rounds of DHS Pakistan? Wed, 12 June 2019 04:37
 NN Messages: 3Registered: April 2019 Member
Hi,

I'm new to DHS and I'm not quite sure how to combine information of male and female data in DHS. I want to generate estimates using 3 rounds of DHS Pakistan and my analysis includes comparison between the two genders. Could someone please help?
Forum: Mortality
Topic: How to calculate and generate a Variable IMR in stata
How to calculate and generate a Variable IMR in stata Tue, 11 June 2019 07:35
 mweetwabob@gmail.com Messages: 1Registered: June 2019 Member
I need to know how to compute the infant mortality rate, without dropping other variables such as education of the mother using either the BR OR KR files in Stata using 2013 ZDHS.

[Updated on: Tue, 11 June 2019 07:36]

Report message to a moderator

Forum: Domestic Violence
Topic: D005
D005 Tue, 11 June 2019 06:00
 MAli Messages: 1Registered: June 2019 Member