The DHS Program User Forum: Merging data files » Combining mother's info on child row in PR file

Home » Data » Merging data files » Combining mother's info on child row in PR file

Show: Today's Messages :: Show Polls :: Message Navigator

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

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.

Report message to a moderator

[Message index]

		Combining mother's info on child row in PR file By: lillo?S on Mon, 05 December 2016 14:20
		Re: Combining mother's info on child row in PR file By: Trevor-DHS on Tue, 06 December 2016 08:38
		Re: Combining mother's info on child row in PR file By: lillo?S on Tue, 06 December 2016 09:21
		Re: Combining mother's info on child row in PR file By: Trevor-DHS on Wed, 07 December 2016 18:56
		Re: Combining mother's info on child row in PR file By: lillo?S on Thu, 08 December 2016 09:27
		Re: Combining mother's info on child row in PR file By: lillo?S on Thu, 08 December 2016 10:54
		Re: Combining mother's info on child row in PR file By: Trevor-DHS on Tue, 03 January 2017 16:28

Previous Topic:	combinning three files into one file
Next Topic:	Child's weight in Kg (1 decimal) variable in SAS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 4 02:17:15 Coordinated Universal Time 2025