The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. (DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI.)
MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22075] Thu, 28 January 2021 12:38 Go to next message
YVES is currently offline  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?
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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2537
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

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 Go to previous messageGo to next message
YVES is currently offline  YVES
Messages: 6
Registered: January 2021
Member
Thanks a lot to the team of DHS program for the quick answer to my question.
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 Go to previous messageGo to next message
YVES is currently offline  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!
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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2537
Registered: February 2013
Senior Member
The variable you are looking for is found in HTAR71*.ZIP:
HIV03 Blood Test Result
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 Go to previous messageGo to next message
YVES is currently offline  YVES
Messages: 6
Registered: January 2021
Member
Thanks a lot for your help DHS Program Team!
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 Go to previous messageGo to next message
YVES is currently offline  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?
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 Go to previous messageGo to next message
YVES is currently offline  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.
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 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2537
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.

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:
  


Current Time: Mon Jun 27 13:41:32 Coordinated Universal Time 2022