Project

General

Profile

Support #692

merging _indresp and _child across all waves

Added by Nico Ochmann about 6 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Data analysis
Start date:
01/03/2017
% Done:

100%


Description

Dear Ladies and Gentlemen,

I hope this question is USoc-specific enough to post it here. With Stata, I would like to merge the files _indresp and _child across all six waves. In the end, I would like to have the age and sex of the children, the biological father, his wage etc. in one panel data set (long format). So far, I have created two separate panel data files, the master file with numerous selected variables from _indresp and the using file from _child with a number of selected variables. So I have these two panel sets and I want to merge them. I went ahead and ran
merge 1:1 pidp wave using ........, gen(....). In the master set, I have roughtly 290 000 observations and in the using set 9 000. The number of matches were zero, though. My guess is that I cannot use pidp as common variable for both sets, but I am not sure which one to use. If you could give me a hint as to how to set this merging procedure up, I would highly appreciate that.

Also available in: Atom PDF