The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Reproductive Health » Pregnancy outcomes in migrants in Pakistan DHS 2017-18
Pregnancy outcomes in migrants in Pakistan DHS 2017-18 [message #23247] Fri, 06 August 2021 06:45 Go to next message
EvaJulia is currently offline  EvaJulia
Messages: 1
Registered: August 2021
Good afternoon,

Currently I am conducting a study on the pregnancy outcomes among migrant women in Pakistan, using the PDHS 2017-18.
In this dataset I will be using 'SH21' (born in this village/city) and 'SH22' (Place from where move to this village/city/country: Unit) in the HH dataset to identify the migrant individuals.
However, these variables are reported in a wide format, meaning the SH21$1 responds to respondent's line number 1, SH21$2 responds to respondent's line number 2.
Therefore, it is not possible to identify which individuals are migrants, based on the chosen variables.
Is is possible to transform the wide data to long data and match the respondent's line number in the migrant variable (SH21 or SH22) to the individuals in the long data?
Hopefully you will be able to help.

Kind regards,
Eva Julia
Re: Pregnancy outcomes in migrants in Pakistan DHS 2017-18 [message #23279 is a reply to message #23247] Mon, 16 August 2021 09:26 Go to previous message
Shireen-DHS is currently offline  Shireen-DHS
Messages: 112
Registered: August 2020
Location: USA
Senior Member

The information you need for the migrant variables are in the PR file (individual level file) and the pregnancy outcome variables are in the IR file (also an individual level variable). Therefore you do not need to change wide to long data but what you need to do is a 1:1 merge of the PR and IR file. I believe you are using SPSS. You can see an example of the type of merge you need to do in the Guide to DHS Statistics. See Example two under the merging explanation: x.htm#t=Analyzing_DHS_Data.htm&rhsearch=merge&rhhlte rm=merge&rhsyns=%20

Thank you.
Shireen Assaf
The DHS Program
Previous Topic: Missing data for Nigeria s434b wiped dry in a few minutes after birth
Next Topic: Health Service provision for females living with FGM/C
Goto Forum:

Current Time: Thu May 26 07:58:04 Coordinated Universal Time 2022