Difference between data and report [message #25317] |
Sat, 01 October 2022 21:39 |
Aamna
Messages: 11 Registered: May 2019
|
Member |
|
|
Hello,
I am doing an analysis by using Pakistan's children data set for 2017-2018 (PKKR71FL). I conducted crosstabs to ensure some numbers. I compared my raw data set's low birth weight numbers with the country's survey report. I have not made any changes in the dataset. I conducted crosstabs on weighted and unweighted data, but the results were the same.
I found discrepancies between the two. In total, I have 11 observations less than the survey report's total. I also saw that there was a discrepancy at the category levels. I do not understand why there is a difference between the two. Am I using the wrong dataset, or is there any other issue?
Here is an example of one cross tab. (tab m19 v101, mi). I did it without missing too.
Raw Dataset Survey Report (table 10.1 last column)
Punjab 468 961
Sindh 495 514
Baluchistan 177 117
KPK 136 59
ICT 385 40
FATA 20 1
Total 1681 1692
I am so confused and stressed concerning this difference. My work has reached a standstill due to this issue. I really appreciate your help regarding this issue.
Aamna
|
|
|
|
|
Re: Difference between data and report [message #25329 is a reply to message #25326] |
Wed, 05 October 2022 09:32 |
Janet-DHS
Messages: 878 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member Tom Pullum:
The Stata code I gave yesterday has three parts. The third part produces the percentages and the n's for the last two columns of table 10.1. If you look at the Stata results, you will see weighted n's that round to 961 for Punjab, 514 for Sindh, etc. I gave the steps for region (v024=v101) but the modifications for wealth quintile, etc., should also match the table.
|
|
|