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 #11356 is a reply to message #11355] Thu, 08 December 2016 10:54 Go to previous messageGo to previous message
lillo?S is currently offline  lillo?S
Messages: 26
Registered: December 2015
Member
I've just realised that I was not working on the full data because I had excluded observations for which the age was not available or missing before running the code to paste the mother's age.
I have re-run the code using the full data and I get 49 cases for which the age difference is <=12 and >=60 (and not 37) and I get 39 cases for which the age difference is <=11 and >=57 (which I guess were the lower and upper limit that you applied to verify the number of 'strange' cases, the two additional cases are hhid: 145 15 4 and 182 60 1). Can you confirm these numbers?

I have two further questions. I would consider as 'strange cases' those cases for which the age difference is <10 and >60 and remove them from the data. In other words, I would be using only observations for which the age difference between the mother and the child is between 10 and 60 (10 <= age difference <= 60). Does this make sense or should I consider a different lower or upper limit?
If I had to do the same for the father, which would the upper and lower limit for the age difference between the father and the child be?

Thanks a lot.
 
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:34:27 Coordinated Universal Time 2025