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

Forum: Merging data files
 Topic: Merging KR with PR for Ethiopia 2011
Re: Merging KR with PR for Malawi 2015-16 [message #17437 is a reply to message #14997] Mon, 18 March 2019 08:26
Felixo is currently offline  Felixo
Messages: 1
Registered: March 2019
Dear Expert,
I am working on children malnutrition using Mdhs dataset.
I have been able to merge KR with PR files using PR file as the base file.
This is achieved by
1. convert variables v001, v002 and B16 to HV001, HV002 and HVIDX respectively, in the KR file.
2. sort cases using the key identifier variables HV001, HV002 and HVIDX
3. open the PR file and sort by HV001, HV002 and HVIDX
4. select cases based on HVIDX>=2 & HVIDX<=17 & HV103=1 & 0<=HC1<=59
5. Compute weight variable using HV005/1000000; and weigh the reduced dataset PR

With the above, I could obtain the prevalence of the stunting (37.1%), wasting (2.7%) and underweight (11.5%) as it were in the Malawi DHS report.
However, the sample size increases by 20 (from 6,033 to 6,053). Please advise appropriately on what I could do next to avoid this increase.
Thank you for your prompt intervention.
 Topic: Merging Women-Men-HIV Data: Different Countries, Different Years
Re: Merging Women-Men-HIV Data: Different Countries, Different Years [message #17438 is a reply to message #17046] Mon, 18 March 2019 10:08
Yawo is currently offline  Yawo
Messages: 7
Registered: February 2019

I asked this/related questions a bit earlier but got no response - so I am raising it here in the proper context.

for my research, it is important for me to know whether those who are HIV+ are indeed aware of their status (know they are positive). I know the HIV-testing model was tactically confidential and therefore results were not released to participants.

But I am wondering if a combination of two variables - could allow us to make this sort of inference:

-- Variable V828 indicates that a sizable number of respondents have had HIV test in the past received the results (and by implication are aware of their status - positive or negative).
-- From the HIV biomarker dataset, I call pull out those who are HIV-positive from HIV03.

Will the combination of V828 (HIV status) + HIV03 (positive status) [those who are aware of their status and have tested positive] give me the number who are aware of their HIV+ status?
If not, is there any other of getting a sense of those who are HIV+ and know their status?

Thanks , Yawo

Current Time: Mon Mar 18 10:19:55 Eastern Daylight Time 2019