The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Combining mother's info on child row in PR file
Re: Combining mother's info on child row in PR file [message #11355 is a reply to message #11349] Thu, 08 December 2016 09:27 Go to previous messageGo to previous message
lillo?S is currently offline  lillo?S
Messages: 26
Registered: December 2015
Member
I have checked using the age difference between the mother and the child. There are 82 cases in which this difference is 12 years and less and there are 5 cases in which this difference is 60 years and more (please see attached file). So, the 419 children that I mentioned in my first post are instead 87 -- my bad.

In the file you attached, the 37 cases include observations in which the age difference is 57 and 58 and 59, meaning that in the end the 'strange' cases are even less, i.e. 33. Moreover, in your file, it is specified that the Input Data used is: C:\Projects\Analysis\UserForum\Mothers age mismatch\temp\mlir41.dat, while I am using the mlpr41.dat. Why are you using that one?

Can I ask you which R code you used to copy/paste the mother's information? I struggle at understanding why I find more cases than you do.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: combinning three files into one file
Next Topic: Child's weight in Kg (1 decimal) variable in SAS
Goto Forum:
  


Current Time: Fri Jan 3 02:24:28 Coordinated Universal Time 2025