Project

General

Profile

Actions

Support #426

closed

Merging youth to family information

Added by K.Samantha Russell Jonsson about 9 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
-
Category:
Data analysis
Start date:
10/02/2015
% Done:

100%


Description

Dear All, could someone please assist me. I have created a file with responses from the youth questionnaire.
I have been trying without success to merge this information to some family characteristics(i.e. information on the parents education, income, maternal age at first birth etc). I could for example merge the youth questionnaire to egoalt but not to indresp files. I am using stata.
Thank you for your time beforehand.

Actions #1

Updated by Alita Nandi about 9 years ago

Follow these steps:

1. Merge youth questionnaire file, w_youth, to w_indall using pidp. The variables that you need from w_indall are the mother and father PIDPs: w_mnspid and w_fnspid
2. Drop observations in w_indall but not in w_youth and save it, say as temp_youth

3. Open temp_youth, rename pidp to something else say, youth_pidp
4. Rename mother pidp, w_mnspid, to pidp
5. Merge that file with w_indresp using pidp and keep whatever mother variables you need (note this will be a many to one merge for households with youth siblings)
6. Rename pidp back to w_mnspid
7. Save it as mother file, w_mother
8. Repeat steps 3-8 for father: w_father

9. Now merge these two files, w_mother and w_father, to temp_youth file using w_mnspid and w_fnspid

Please remember to check the output at each step.

On behalf of the team.

Actions #2

Updated by Redmine Admin about 9 years ago

  • % Done changed from 0 to 50
Actions #3

Updated by Redmine Admin almost 9 years ago

  • Status changed from New to Closed
  • Assignee deleted (K.Samantha Russell Jonsson)
  • Target version set to X M
  • % Done changed from 50 to 100
Actions

Also available in: Atom PDF