Home » Data » Dataset use in SPSS » Antenatal care vs infant mortality -Kenya
| Antenatal care vs infant mortality -Kenya [message #1572] |
Fri, 14 March 2014 07:08  |
Malachi Arunda
Messages: 30
Registered: February 2014
|
Member |
|
|
Dear Expert
1. How do I select only LAST BORN infants data from the CHILDREN recode data (born 12-59 months before the survey-spss)?
2. The AGE AT DEATH data is missing and I'm looking at death from (0-11months)or live beyond 1 year, how do I deal with this.I need to select ONLY those infants who die before their 1st birthda?
3. If I select Last born infants and do cross tabs for Tetanus toxoid and Iron Folic, will it match with ONLY those Last born infants selected?
Thank you
|
|
|
|
|
|
| Re: Antenatal care vs infant mortality -Kenya [message #1578 is a reply to message #1575] |
Fri, 14 March 2014 13:08  |
 |
user-rhs
Messages: 132
Registered: December 2013
|
Senior Member |
|
|
Malachi,
For Question 1:
Restrict to BIDX == 1. You can confirm that BIDX == 1 is the most recent birth by tabulating the birth order and birth index variables.
. tab bord bidx if v201==5
.....birth.|
.....order.|.............birth.column.number
....number.|.........1..........2..........3..........4.|... ..Total
-----------+--------------------------------------------+--- -------
.........2.|.........0..........0..........0..........3.|... ......3.
.........3.|.........0..........0.........45..........0.|... .....45.
.........4.|.........0........184..........0..........0.|... ....184.
.........5.|.......358..........0..........0..........0.|... ....358.
-----------+--------------------------------------------+--- -------
.....Total.|.......358........184.........45..........3.|... ....590
Here you see that among women with 5 kids, the kids that are birth order=5 (youngest kid) has birth column number (bidx) equal to 1 (the Recode Manual also states that BIDX is reversely coded from BORD).
For Question 2:
From the DHS5 Recode Manual:
Quote:
Age at death of the child as reported in the questionnaire. The first digit of the age at death
gives the units in which it was reported: 1 - Days, 2 - Months, 3 - Years, 9 - Special
responses. The last two digits give the age at death in those units. Age at death is usually
reported in days if it was less than one month, in months if it was less than two years and
otherwise in years. If the last two digits contain a value greater than 90 then this is a special
response. For example, 298 means the age at death was a number of months, and the exact
number was unknown, but lies between 1 and 23 months.
BASE: Dead children (B5 = 0).
Link here: http://www.dhsprogram.com/pubs/pdf/DHSG4/Recode5DHS_23August 2012.pdf
Based on this, for children who died before their first birthday, you will most likely want to restrict to those with b6<300. Note, in the 08/09 child recode dataset, it looks like 167 children with bidx==1 are dead.
For Question 3:
I think these questions are only asked of the most recent birth, so if you restrict to bidx==1, you should be all set. You can confirm with by checking the birth column number of those for whom m1 (tetanus injection before birth). Note, the ANC vbls are typically only asked of the most recent birth, so for older children, you can expect them to be missing. For example:
. tab bidx if m1==.
......birth.|
.....column.|
.....number.|......Freq......Percent........Cum.
------------+-----------------------------------
..........2.|......1,673.......83.78.......83.78
..........3.|........302.......15.12.......98.90
..........4.|.........18........0.90.......99.80
..........5.|..........3........0.15.......99.95
..........6.|..........1........0.05......100.00
------------+-----------------------------------
......Total.|......1,997......100.00
As you can see, the missing values are all birth index >1.
hth,
RHS
[Updated on: Fri, 14 March 2014 13:09] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Antenatal care vs infant mortality -Kenya [message #1590 is a reply to message #1589] |
Fri, 14 March 2014 19:46 |
|
user-rhs
Messages: 132
Registered: December 2013
|
Senior Member |
|
|
If you restrict to BIDX==1 (i.e., delete observation if BIDX>1), then your dataset includes only the most recent born children. From then on, any of your tabulations re: mother's antenatal care, for example, the number of ANC visits, whether she received injections, iron, etc., will be tabulated only on those children.
Using 2008-9 child recode data, I see that 1,997 children in that dataset were NOT the most recent, so when I drop those observations, I am down to 4,082 most recent births. Again, you can confirm that the ANC variables are collected only for the most recent birth, by asking the software to tabulate BIDX where ANC variable (ex: m13) is missing.
Note that the age range for BIDX==1 is 0-59 months, not 12-59 months. You will need to do some data management to create categories of child's age if you are interested only in the 12-59 subset.
Similarly, you will need to create a variable on whether the mother attended ANC or not in order to get the cross-tabulation between ANCxdeath. Note, because the number of children who died are quite small (165), you may have difficulties finding statistical significance.
My examples are in Stata but they are directly translatable to SPSS.
hth,
RHS
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Dec 18 08:56:51 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
