Generating an age variable of the partner

[Joseph Montalbo]

Hello everybody,

this is the first time I have been doing data management on my own. I did not have any big problems until now. I am working with a panel data with about 900000 observations and need to generate a variable that contains information of the age of the respondent's partner. Here is one example:

persnr	year	age	partnr	age_partner
45501	2002	57	45502	.
45501	2003	58	45502	.
45502	2002	53	45501	.
45502	2003	54	45501	.

I have the respondent's identifier as well as the identifier of the partner.The presented individuals are a couple. I have information on age of both over two periods. However, I would like to generate a variable (age_partner) that states the age of each respondent's partner. I need to do this for every individual. I kindly appreciate any help.

Wishes,

Joseph

[William Lisowski]

Welcome to Statalist.

You have accidentally posted your question in the Mata Forum, which is focused on questions involving the use of Stata's Mata commands. You should repost your question in the General Forum in order to get the maximum visibility.

https://www.statalist.org/forums/for...ussion/general

[Joseph Montalbo]

Thank you very much for the reply. I will do that.