| Different findings from the 3 files [message #10295] |
Wed, 20 July 2016 12:38  |
lka035
Messages: 9
Registered: July 2016
|
Member |
|
|
The Individual recode (IR) contains the child history of all the births born by the women that participated in the survey. I find varying rates for births in the last five years from the different files in the Zambia 2013 DHS data.
The individual recode shows 16,411
FREQUENCIES VARIABLES=V208
/ORDER=ANALYSIS.
Births in last five years
Frequency Percent Valid Percent Cumulative Percent
Valid No births 7058 43.0 43.0 43.0
1 5692 34.7 34.7 77.7
2 3237 19.7 19.7 97.4
3 405 2.5 2.5 99.9
4 19 .1 .1 100.0
Total 16411 100.0 100.0
After restructuring selected variables into cases using the IR file, births in the last 5 years totals to 35,827 (49207-13380)
Births in last five years
Frequency Percent Valid Percent Cumulative Percent
Valid No births 13380 27.2 27.2 27.2
1 19241 39.1 39.1 66.3
2 14245 28.9 28.9 95.2
3 2205 4.5 4.5 99.7
4 136 .3 .3 100.0
Total 49207 100.0 100.0
Household recode file shows 14,043
FREQUENCIES VARIABLES=HC31$1 HC31$2 HC31$3 HC31$4 HC31$5 HC31$6 HC31$7 HC31$8
/ORDER=ANALYSIS.
Statistics
Year of birth Year of birth Year of birth Year of birth Year of birth Year of birth Year of birth Year of birth
N Valid 9401 3863 645 110 17 5 1 1
Missing 6519 12057 15275 15810 15903 15915 15919 15919
When I looked at the children recode, births in the last 5 years is 13457
Births in last five years
Frequency Percent Valid Percent Cumulative Percent
Valid 1 5692 42.3 42.3 42.3
2 6474 48.1 48.1 90.4
3 1215 9.0 9.0 99.4
4 76 .6 .6 100.0
Total 13457 100.0 100.0
To my understanding the children recode is a subset of the individual recode. Births in the last 5 years should be the same figure in all files.
Kindly requesting if you can shade more light by explaining why the discrepancy in the figures generated from the three different files.
How can I reproduce the children recodes figures from the individual recode file?
[Updated on: Thu, 21 July 2016 05:57] Report message to a moderator |
|
|
|
Members
Search
Help
Register
Login
Home
