| Re: Daughter age at circumcision Mali 2006 [message #3630 is a reply to message #3624] |
Mon, 19 January 2015 22:42   |
aligazan
Messages: 24
Registered: June 2014
Location: UK
|
Member |
|
|
Hello Trevor
I have been looking at variable G109 within this dataset with an interest in whether the last daughter who was circumcised was alive or dead at the time of the survey.
Using the logic: "Look up the BORD$column indicated by G109 to get the column number of the last daughter (=CLLD)" and then look up the B5$column indicated by CLLD - I get 100% of the last daughters to be circumcised as alive. I also get 100% as female (which makes sense and suggests the column logic is working).
This is unexpected as about 10-15% of children are reported as dead in columns B5.
Is there something within the data collection that means all "last daughters circumcised" are by definition alive at the time of the survey? I can't see anything in the wording of the questionnaire which suggests this (Q911).
Excerpts from the SPSS syntax I've used is below (it's very clunky - I'm sure there are more efficient ways of writing this but I haven't figured it out yet!):
DO IF (G109=1).
RECODE BORD$01 (ELSE=Copy) INTO GavCOLNOLAST.
END IF.
VARIABLE LABELS GavCOLNOLAST 'Column no of last circumcised'.
EXECUTE.
DO IF (G109=2).
RECODE BORD$02 (ELSE=Copy) INTO GavCOLNOLAST.
END IF.
VARIABLE LABELS GavCOLNOLAST 'Column no of last circumcised'.
EXECUTE.
etc to 15
DO IF (GAVCOLNOLAST=1).
RECODE B5$01 (ELSE=Copy) INTO Mortalitylast.
END IF.
VARIABLE LABELS Mortalitylast 'Mortality of last circumcised'.
EXECUTE.
DO IF (GAVCOLNOLAST=2).
RECODE B5$02 (ELSE=Copy) INTO Mortalitylast.
END IF.
VARIABLE LABELS Mortalitylast 'Mortality of last circumcised'.
EXECUTE.
etc. to 15
The result is that all Mortalitylast cells are either blank (where G109 is 99 or blank) or 1 (indicating daughter is alive).
Your help would be very much appreciated.
Best wishes,
Janet
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
