Understanding Society User Support

Thanks Jakob, but I still can't find my way around this.
I've renamed the variables and tried to merge the datasets but still get 0 matches.

Imagine all you need is to know the ages of the parents of the children in c_child.dta. Can you provide me with a piece of code in STATA to do this, please?

Thanks,

José

Guess I've got it. The key is to keep _merge==2, not _merge==3. Am I right?
Thanks,
José

The following example combines mother's highest qualification (a_hiqual_dv) from the adult interview response file (A_INDRESP) with valid responses to a question about whether the responding parent would like the child to go on to university (a_kid2uni) from the child enumetation file (A_CHILD);

use pidp mpid a_kid2uni using a_child,clear
keep if a_kid2uni>0
ren pidp chpidp
ren mpid pidp
merge m:1 pidp using a_indresp,keep(3) nogen keepus(a_hiqual_dv)
ta a_hiqual_dv a_kid2uni,row

Jakob

Thanks Jacob. That's what I needed.
Kind regards,
José

Sorry Jakob.
In fact, it's not what I need.
To begin with I'm working with Wave 3 and there variable c_kid2uni is not included in the c_child.dta
But that's not too important.

Let's simply merge the child and indresp datasets following your code:

use "F:\Personal\Data\Undestanding Society\Waves 1 - 3\stata12_se\c_child.dta",clear
ren pidp chpidp
ren mpid pidp
merge m:1 pidp using "F:\Personal\Data\Undestanding Society\Waves 1 - 3\stata12_se\c_indresp.dta",keep(3)

I get 14,402 matched observations.

Now, if I want to see let's say the ages of these respondents, I get:

. ta c_dvage

age  |      Freq.     Percent        Cum.
-------------+-----------------------------------
     missing |          4        0.03        0.03
           0 |        851        5.91        5.94
           1 |        823        5.71       11.65
           2 |        940        6.53       18.18
           3 |        962        6.68       24.86
           4 |        952        6.61       31.47
           5 |        939        6.52       37.99
           6 |        911        6.33       44.31
           7 |        899        6.24       50.56
           8 |        885        6.14       56.70
           9 |        843        5.85       62.55
          10 |        951        6.60       69.16
          11 |        835        5.80       74.95
          12 |        928        6.44       81.40
          13 |        892        6.19       87.59
          14 |        909        6.31       93.90
          15 |        878        6.10      100.00
-------------+-----------------------------------
       Total |     14,402      100.00

All I get out of the merger is the ages of children -not of their parents. In other words, after merging both datasets I don't know the ages of the parents of the children in c_child.dta (or nothing else about these parents).

So, let me rephrase my previous query:

How can I obtain in STATA the ages of the parents of the children in c_child.dta?

Many thanks,

José

Perfect.
Many thanks,
José