The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging data files (Injury data)
Merging data files [message #30058] Tue, 17 September 2024 17:56 Go to previous message
Elsha is currently offline  Elsha
Messages: 4
Registered: September 2024
Member
Hi,

I am working on merging injury data with IR, MR, and PR files. Can you help me please.
I had merged injury file with PR 1:1 in STATA by generating a new variable. for instance for injury data: gen ID_new = hhid + "_" + string(haiidx) + "_" + string(hv003)

I am using data for Nepal Demographic and Health Survey 2022. The DHS Program - Nepal: DHS, 2022 - Final Report (English)

The files I am using are NPPR82DT : shows 74 self-harm cases while NPAI82DT shows 86 self-harm cases. Is it because 8 suicidal deaths and 4 were not in household. Hence information regarding those were not collected in PR data files?

I want to merge NPPR82DT with NPIR82DT, NPMR82DT and NPHR82DT.

I want to link the socio-economic factors like religion, ethnicity, occupation with self-harm data. But are these variables only in IR data files?

However, on merging the dataset on self-harm shows 72 counts instead of 86 (originally in injury dataset). Why is that so?

Please help me!

[Updated on: Mon, 23 September 2024 07:45] by Moderator

Report message to a moderator

 
Read Message
Read Message
Previous Topic: Merging IR, KR and HR files
Next Topic: Appending Multi-phase Nigerian DHS Surveys
Goto Forum:
  


Current Time: Thu Nov 7 22:26:13 Coordinated Universal Time 2024