| 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: 888
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.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
