The DHS Program User Forum: Dataset use (other programs)

Home » Data » Dataset use (other programs) » SAS dataset Normalise

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

SAS dataset Normalise [message #2171]

Fri, 16 May 2014 04:37

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

Report message to a moderator

Re: SAS dataset Normalise [message #2172 is a reply to message #2171]

Fri, 16 May 2014 06:56

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

Report message to a moderator

Next Topic:

SAS: applying female weight

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 23:44:59 Coordinated Universal Time 2024