Merging data files [message #30058] |
Tue, 17 September 2024 17:56 |
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
|
|
|