Home » Topics » General » Unable to reproduce results of age at first marriage table
| Unable to reproduce results of age at first marriage table [message #9391] |
Wed, 23 March 2016 15:03  |
LaissezPasser
Messages: 1
Registered: March 2016
Location: Maldives
|
Member |
|
|
I'm unable to replicate the results of the 2009 Maldives DHS for age at first marriage (as appear in Table 6.2 (pg.67), below), and I can't figure out why. Specifically, I'm concerned with the cohort of 20-24 year-old women, and the proportion married before the age of 15 and before 18 -- one of the new, finally adopted SDG indicators (5.3.1). Here's the table as it appears in the final report:
According to Table 6.2, the proportion of women 20-24 years old who married before 18yo is 3.9 percent, based on a sample of 2,161. However, the figures I'm getting are significantly higher when I run my own crosstabs (using MVIR51FL.sav): 6.7 percent, with a SE of 0.8 percent. (And when I run the same crosstab separately on the BR, KR, and CR recode files, the results are even higher.)
I have already made sure to account for the two-stage cluster design by carefully applying the complex stratified weighting procedure outlined in this video. Here's the output (also attached):
Note that the n size of the 20-24 cohort is 1,267; this isn't too far from the unadjusted figure (1,381), but it's a long way to the 2,161 women listed in Table 6.2 as comprising the 20-24 cohort. (NOTE: If I were to combine the IR, BR, KR, and CR files, I'd get 2,555 women (unadjusted) in the 20-24 year old cohort. Is this what I should be doing in order to reproduce the published results?)
Here's the SPSS syntax I used to generate this output (also attached):
DATASET ACTIVATE MVIR51FL.
*compute weight variable*.
compute WGT = (V005/1000000).
EXECUTE.
*create binary categorical for age at first marriage <18yo*.
RECODE v511 (0 thru 17=1) (ELSE=0) INTO childbride.
EXECUTE.
* Analysis Preparation Wizard.
CSPLAN ANALYSIS
/PLAN FILE='/Users/UNFPA/r/09MDHS.csaplan'
/PLANVARS ANALYSISWEIGHT=WGT
/SRSESTIMATOR TYPE=WR
/PRINT PLAN
/DESIGN STRATA=V023 CLUSTER=V021
/ESTIMATOR TYPE=WR.
*Crosstab 5-year age cohorts with variable for <18yo first marriage*.
* Complex Samples Crosstabs.
CSTABULATE
/PLAN FILE='/Users/UNFPA/r/09MDHS.csaplan'
/TABLES VARIABLES=V013 BY childbride
/CELLS POPSIZE ROWPCT
/STATISTICS SE CIN(95)
/MISSING SCOPE=TABLE CLASSMISSING=EXCLUDE.
*and just for kicks, let's run it unweighted".
DATASET ACTIVATE MVIR51FL.
CROSSTABS
/TABLES=v013 BY childbride
/FORMAT=AVALUE TABLES
/CELLS=COUNT row
/COUNT ROUND CELL.
Thanks in advance for your help.
Delivering a world where every pregnancy is wanted, every childbirth is safe and every young person's potential is fulfilled
[Updated on: Wed, 23 March 2016 15:24] Report message to a moderator |
|
|
|
Current Time: Sat Jan 11 01:11:48 Coordinated Universal Time 2025
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
