NDHS 2022 analysed data matching with the country report [message #30238] |
Mon, 21 October 2024 10:40 |
Suna
Messages: 5 Registered: October 2024
|
Member |
|
|
I hope someone can find this post.
I am analysing the Nepal DHS 2022 data.
I thought I had finished cleaning the data, but the numbers in the cleaned data differ from those in the NDHS2022 report.
So, I have two questions.
1. In general, when researchers analyse DHS data, do they adjust it to match the numbers in the country reports?
2. If I limit the women to those aged 15-49, I think the numbers in the data analysed by STATA will match those in Tables 9.1 and 9.2 in the country reports (2022 NDHS). However, both numbers did not match. I would appreciate it if you could tell me the correct STATA code.
I apologise for the difficult work.
|
|
|
Re: NDHS 2022 analysed data matching with the country report [message #30277 is a reply to message #30238] |
Fri, 25 October 2024 14:39 |
Janet-DHS
Messages: 899 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
I think you are trying to get the total numbers of births and stillbirths for tables 9.1 and 9.2. In Stata you can do the following:
use "...NPNR82FL.DTA", clear
sort v001 v002 v003 pidx
egen sequence=seq() if p32<=2 & p19<24, by(v001 v002 v003)
tab sequence
* Totals for table 9.1 and 9.2
tab p32 if sequence==1 [iweight=v005/1000000]
Note that you would use the new NR file, and select on p32 and p19. The "sequence" line selects the most recent birth or stillbirth in the past two years. You need to weight by v005.
The subtotals I get are 1932 and 17, which add to 1949. The final report gives 1933 and 18, which are different from 1932 and 17. It gives a total of 1949, which is the sum of 1932 and 17 but is not the sum of 1933 and 18. A puzzling discrepancy but negligible.
Let us know if you have trouble matching the rest of the table.
You ask "In general, when researchers analyse DHS data, do they adjust it to match the numbers in the country reports?" The answer is no. You want to match the report, if possible, but if you can't get a match, we would not recommend that you make adjustments.
|
|
|
|
|
|