The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Neonatal Mortality
Neonatal Mortality [message #9942] Tue, 07 June 2016 05:44 Go to next message
Chota is currently offline  Chota
Messages: 1
Registered: June 2016
Location: Lusaka Zambia
I need help with creating a variable that shows all the information on the Death by age in months. I am working with the women and Child file in the 2013-14 Zambia Demographic Survey dataset, I noticed there is more that one Variable showing this information. For example age at death is found in the following b7_01, b7_02 all the way through to b7_20. What I need is a Variable that combines all this information into one variable B7(age at Death, months)


Re: Neonatal Mortality [message #9943 is a reply to message #9942] Tue, 07 June 2016 07:03 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2314
Registered: February 2013
Senior Member
Multiple or repeating records are placed one after the other on the record, with the maximum number of occurrences of each section being represented in every case. Each variable in a repeating section is placed immediately after the preceding variable of the same occurrence, such that all variables for occurrence 1 precede all variables for occurrence 2 of a section.

Multiple occurring variables and sections of data represent the main disadvantage to flat files. Each occurrence of every such variable must have its own name because statistical packages do not generally support the use of arrays or subscripts. For example, the third occurrence of the variable named MM11 would be named MM11$03 in SPSS, or MM11_03 in SAS and STATA.

For children's level analysis, use the Children's Recode (KR). This dataset has one record for every child of eligible women, born in the last five years. It contains the information related to the child's pregnancy and postnatal care and immunization and health. The data for the mother of each of these children is included. This file is used to look at child health indicators such as immunization coverage, vitamin A supplementation, and recent occurrences of diarrhea, fever, and cough for young children and treatment of childhood diseases. The unit of analysis (case) in this file is the children of women born in the last 5 years (0-59 months).

For births' level analysis, use the All Children's Recode (BR). This 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.
Previous Topic: Cambodia mortality/morbidity rates due to accidents: calculation issues
Next Topic: Missing female genital cutting variable in Liberia 2007 individuals' survey
Goto Forum:

Current Time: Wed Jun 23 15:10:57 Coordinated Universal Time 2021