Support #1469

Matching data

Added by Laura Bryce almost 3 years ago. Updated about 2 years 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 almost 3 years ago

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

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 almost 3 years ago

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

Updated by Alita Nandi almost 3 years 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 almost 3 years ago

  • % Done changed from 50 to 80

Updated by Understanding Society User Support Team about 2 years ago

  • Status changed from Feedback to Resolved
  • Assignee deleted (Laura Bryce)
  • % Done changed from 80 to 100

Also available in: Atom PDF