Project

General

Profile

Support #792

Merging datasets

Added by Emily Lowthian over 5 years ago. Updated about 5 years ago.

Status:
Closed
Priority:
High
Category:
Data analysis
Start date:
06/07/2017
% Done:

100%


Description

Hi there,

My name is Emily - I am a MSc student, currently working on a dissertation looking at how socioeconomic status moderates the impacts of trauma on adolescent well-being.

I essentially need to merge 2 datasets in wave 4 - d_indsamp and d_indresp. I am using stata V14.2 for this.
However, despite trying to use the pidp and d_pno as the unique identifiers Stata keeps flagging up an error that the ID variables do not uniquely identify observations in the master dataset (indsamp).
I'm not entirely sure why this is happening - please could you help?

Additionally - I would like to merge on the wave 4 hhresp dataset on to this (I will just duplicate the hh responses on to each indivdiual). Then wave 6 youth dataset will be appended on based using hh ID so the children sit in the parental household and it can be submerged later on.

Any help will be greatly appreciated as I have hit a wall here!

Emily

Also available in: Atom PDF