The DHS Program User Forum: Merging data files » MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI.

Home » Data » Merging data files » MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. (DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI.)

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

MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22075]

Thu, 28 January 2021 12:38

YVES
Messages: 6
Registered: January 2021

Member

Hi! My name is Yves Sanley.
I am working on a study about the factors associated to HIV prevalence in Haitian women from 15 to 49 years old between 2016-2017. I would like to merge the HIV test results and the sociodemographic and cultural variables of these women to assess possible associations. I am confused with the recoding document.
Can someone help me with the command I should use, using the software R to have these data available?

Report message to a moderator

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22076 is a reply to message #22075]

Thu, 28 January 2021 14:30

Bridgette-DHS
Messages: 3203
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The Stata code to do this is given below. It shows the logic; you will have to convert to R. "_merge==3" identifies the cases that are in both files. Remember that when you use data in the AR file, you should apply the HIV weight, hiv05.

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\HTAR71FL.DTA", clear
rename hivclust v001
rename hivnumb v002
rename hivline v003
sort v001 v002 v003
save e:\DHS\DHS_data\scratch\HTARtemp.dta, replace

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\HTIR71FL.DTA", clear
sort v001 v002 v003
merge v001 v002 v003 using e:\DHS\DHS_data\scratch\HTARtemp.dta
tab _merge
keep if _merge==3

Report message to a moderator

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22086 is a reply to message #22076]

Fri, 29 January 2021 08:45

YVES
Messages: 6
Registered: January 2021

Member

Thanks a lot to the team of DHS program for the quick answer to my question.

Report message to a moderator

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22148 is a reply to message #22076]

Mon, 08 February 2021 08:06

YVES
Messages: 6
Registered: January 2021

Member

Good morning Team of DHS Program,

How are you doing? I have a very important question.
I am working with the data of the DHS Haiti, 2016-2017. I have merged the files, but my main problem now is to know which of the CODED VARIABLES of the database represents the results of the HIV tests of the Haitian women from this survey.

I have read the RECODE MANUAL (more than once) but I still can't see which one is the HIV results variable. I have seen the variable "HA63" in the manual but nowhere in the database.

Thanks a lot by advance for your help!

Report message to a moderator

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22151 is a reply to message #22148]

Mon, 08 February 2021 08:35

Bridgette-DHS
Messages: 3203
Registered: February 2013

Senior Member

The variable you are looking for is found in HTAR71*.ZIP:
HIV03 Blood Test Result

Report message to a moderator

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22152 is a reply to message #22151]

Mon, 08 February 2021 09:31

YVES
Messages: 6
Registered: January 2021

Member

Thanks a lot for your help DHS Program Team!

Report message to a moderator

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22186 is a reply to message #22075]

Tue, 09 February 2021 15:14

YVES
Messages: 6
Registered: January 2021

Member

Good afternoon DHS Program Team!

I have been looking in DHS Record Manual and the EMMUS-VI, Haiti 2016-2017 and the question "Have you worked in the last 12 months" has 2 categorical responses: YES and NO. Notwithstanding, in the woman database, it is categorized in 0, 1, and 2, so three responses possible.
Can the DHS Team help me understand this better please?

Report message to a moderator

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22187 is a reply to message #22186]

Tue, 09 February 2021 15:26

YVES
Messages: 6
Registered: January 2021

Member

Good afternoon!

I would really like to have also some explanations about how the DHS classified the region of residence during the last survey in Haiti.

Report message to a moderator

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22240 is a reply to message #22187]

Wed, 17 February 2021 08:56

Bridgette-DHS
Messages: 3203
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

Sorry for the delay with this reply. I am looking at HTIR71FL.dta. You are probably referring to v731. Here is the category label for that variable:

label list V731
V731:
0 no
1 in the past year
2 currently working
3 have a job, but on leave last 7 days

There are 4 categories, and they are clearly defined. I don't know why category 3 has such a short interval of potential leave (just 7 days), but these are the categories. There are also some Not Applicable cases, indicated by a dot in Stata. To identify the population of persons eligible for V731, you have to look at the skips and filters in the questionnaire.

Report message to a moderator

Previous Topic:	Merging household and women's individual data Myanmar 2015-2016
Next Topic:	coverage of variables v717 and mv717 in Mali V and VI waves

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Dec 4 10:53:02 Coordinated Universal Time 2024