Dear forum users,

I would like to create a variable containing the employment status of the partner of a person.
Each individual in my paneldataset has a unique personal identifier 'pid'. Furthermore, if an individual has a partner in the dataset, their partner can be identified by variable 'partnerid', which takes the pid value that corresponds to the individual's partner. A individual can have more than 1 partner and some do not have any partners. I can't find a way to generate a variable for the employment status of the partner, which should be a missing value if the person does not have a partner.
I already looked at: https://www.stata-journal.com/sjpdf....iclenum=dm0043 but do not understand how I can apply their tips to solve my problem.


Best,

Jakob