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 #11339 is a reply to message #11337]

Tue, 06 December 2016 09:21

lillo?S
Messages: 26
Registered: December 2015

Member

Sure and thanks. This is the code:

df <- df %>%
group_by(hhid) %>%
mutate(idmother = ifelse(hv112>0 & under17=="yes", hv112, NA))
df <- df %>%
group_by(hhid) %>%
mutate(agemother = ifelse(!is.na(idmother), hv105[idmother], NA))

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: Tue Dec 2 16:05:18 Coordinated Universal Time 2025