The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Kenya » How to merge just a few variables from Household to Child Recode dataset
How to merge just a few variables from Household to Child Recode dataset [message #4232] Wed, 22 April 2015 18:47 Go to next message
nstroupe is currently offline  nstroupe
Messages: 1
Registered: April 2015
Member
I would like data from only a few variables in the Household dataset to be included in the Child Recode dataset I've been working in. For example, I would like HV237 and HV239, which are not included in the Child Recode. I've read several posts in the Merge discussion forum and in STATA help, but it is unclear if you can simply select certain variables to be merged without merging the whole set. Any advice would be much appreciated.
Nancy
Re: How to merge just a few variables from Household to Child Recode dataset [message #4233 is a reply to message #4232] Wed, 22 April 2015 20:18 Go to previous message
Reduced-For(u)m
Messages: 292
Registered: March 2013
Senior Member

Yes - you can merge whatever variables you do/don't want. Just open the household recode, "keep" the variables you want there (and the variables for merging), and then merge that into the child recode (1:m since there can be multiple children in a single household). You could save the trimmed household file as an intermediate step if you want, but you don't have to, you can just directly merge it after dropping the unneeded variables.

Previous Topic: DHS 08/09 - HIV prevention variables in dataset vs. DHS report
Next Topic: Domestic Violence
Goto Forum:
  


Current Time: Mon Nov 18 07:27:17 Coordinated Universal Time 2024