The DHS Program User Forum: Dataset use in SPSS » Differences in counts of women in two files

Home » Data » Dataset use in SPSS » Differences in counts of women in two files

Show: Today's Messages :: Show Polls :: Message Navigator

Differences in counts of women in two files [message #12845]

Sun, 23 July 2017 15:07

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

Bridgette-DHS
Messages: 3214
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.

Report message to a moderator

Re: Differences in counts of women in two files [message #12854 is a reply to message #12850]

Mon, 24 July 2017 10:00

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

Report message to a moderator

Re: Differences in counts of women in two files [message #12860 is a reply to message #12854]

Tue, 25 July 2017 06:24

Bridgette-DHS
Messages: 3214
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