Support #1469

Matching data

Added by Laura Bryce 2 months ago. Updated about 2 months ago.

Start date:
% Done:



I am attempting to use wave 1 data to match data on individuals and their friends. I have used the 'egoalt' file to create a variable for the pidp of friends and have created a dataset of friends data. I am trying now to merge this with my original dataset of individuals but am unsure how to merge them.


Updated by Alita Nandi 2 months ago

  • % Done changed from 0 to 50
  • Status changed from New to Feedback

Hello Laura,

We have a worked out example on how to do this in our training material (available as Moodle course). Depending on the software you use (Stata, R, SPSS, SAS), you can sign up for the specific Moodle course. Here are the instructions on how to sign up:

But if you just want to take a look at the syntax file then you can find it here: But there is a glitch on the website and these are currently unavailable. This should be resolved soon.

Best wishes,
Understanding Support User Support Team


Updated by Alita Nandi 2 months ago

  • Private changed from Yes to No
  • Assignee set to Laura Bryce

Updated by Alita Nandi 2 months ago

The website problem is fixed, so you will be able to access the syntax page now. Please see if the following syntax files are helpful
"Matching individuals within a household" & "Using the egoalt file to create household composition variables"

If these are not helpful, let us know and we can set up a one-on-one meeting on Zoom. If you want to have this meeting then email us at


Updated by Alita Nandi about 2 months ago

  • % Done changed from 50 to 80

Also available in: Atom PDF