The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use (other programs) » SAS dataset Normalise
SAS dataset Normalise [message #2171] Fri, 16 May 2014 04:37 Go to next message
anilgvdbm is currently offline  anilgvdbm
Messages: 11
Registered: December 2013
Location: India
Member

Dear Sir,
I am trying to use SAS dataset in SAS 9.3 here my problem is in individual file birth history the same variable repeat 15 times because of 15 members in the household. but i need to arrange data like one by one household. please can you suggest me how to go about it?

data looks like
case_ID age1 birth_date1 sex1 twin_child1 age2 birth_date2 sex2 twin_child2

but i need to arrange data like this

case_ID age birth_date sex twin_child
1
2
3

please help me in this as per as possible. my email ID- anilgvdbm@gmail.com


Thanks in Advance...
Anil


Anil
Scientific officer
Re: SAS dataset Normalise [message #2172 is a reply to message #2171] Fri, 16 May 2014 06:56 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
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.
Next Topic: SAS: applying female weight
Goto Forum:
  


Current Time: Fri Mar 29 09:48:45 Coordinated Universal Time 2024