The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Differences in counts of women in two files
Differences in counts of women in two files [message #12845] Sun, 23 July 2017 15:07 Go to next message
rppeyton is currently offline  rppeyton
Messages: 6
Registered: July 2017
Location: Chicago
Member
Can anyone comment on why I get different counts for women in the Birth File, than in the Individual File?

I am assuming this is because the Birth file has women listed multiple times because of multiple births? Can anyone confirm?

I am using the files for Afghanistan 2015, and I am talking about the differences in afir70sv and afbr70sv.

Thank you,
RPP


-RPP

[Updated on: Sun, 23 July 2017 19:41]

Report message to a moderator

Re: Differences in counts of women in two files [message #12850 is a reply to message #12845] Mon, 24 July 2017 07:26 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1167
Registered: February 2013
Senior Member
Yes, that's correct.

The Births' dataset has one record for every child ever born of eligible women. Essentially, it is the full birth history of all women interviewed including its information on pregnancy and postnatal care as well as immunization and health for children born in the last 5 years. Data for the mother of each of these children is also included. This file can be used to calculate health indicators as well as fertility and mortality rates. The unit of analysis (case) in this file is the children ever born of eligible women.

The woman's dataset has one record for every eligible woman as defined by the household schedule. It contains all the data collected in the woman's questionnaire plus some variables from the household. Up to 20 births in the birth history, and up to 6 children under age 5, for whom pregnancy and postnatal care as well as immunization and health data were collected, can be found in the file. The fertility and mortality programs distributed by DHS use this file for data input. The unit of analysis (case) in this file is the woman.
Re: Differences in counts of women in two files [message #12854 is a reply to message #12850] Mon, 24 July 2017 10:00 Go to previous messageGo to next message
rppeyton is currently offline  rppeyton
Messages: 6
Registered: July 2017
Location: Chicago
Member
Thank you very much for your Detailed response!

If I may inquire, to more questions.

In the same survey AFIR, the recode manual does not mention the S414 vairables. I believe these are being asked as to whether the woman had any knowledge of the said condition, based on an antenatal/prenatal visit (such as knowledge of symptoms of vaginal bleeding means she should seek medical attention), is that an accurate assumption?

Secondly, there is no issue with me combining the antenatal visits by provider, into one vartiable, such as "any antenatal visit," to show that the respondent had an antenatal visit.

Thank you
RPP


-RPP
Re: Differences in counts of women in two files [message #12860 is a reply to message #12854] Tue, 25 July 2017 06:24 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1167
Registered: February 2013
Senior Member
The recode manual only contains information for standard variables, which explains why you didn't find S414, which is a country specific variable. For country specific questions, the variables are generally named and coded in the same way as they were on the questionnaire. The variable will have a leading "SH" if the question was asked at the household level, a leading "S" if asked at the women's level, and a leading "SM" if asked at the men's level.

If you reference the questionnaire in the appendix of the final report, you will see that S414 is question no. 414 in the Woman Questionnaire (see below).

index.php?t=getfile&id=766&private=0

  • Attachment: Q414.jpg
    (Size: 51.39KB, Downloaded 69 times)
Re: Differences in counts of women in two files [message #12868 is a reply to message #12860] Tue, 25 July 2017 12:46 Go to previous message
rppeyton is currently offline  rppeyton
Messages: 6
Registered: July 2017
Location: Chicago
Member
That is great! Thank you very much.

RPP


-RPP
Previous Topic: What does it means M2A$1 - DHS Women's dataset
Next Topic: Calculating cases for IYCF
Goto Forum:
  


Current Time: Wed Dec 13 02:28:27 Eastern Standard Time 2017