Hi everybody,
I have a dataset that includes the variables: "family id", "highest diploma", "gender", and "relationship in the family" (1=first in household [main provider -can be either male or female]. 2= the partner of 1. and 3 = the child of 1).

How can i generate a "Father's highest diploma" and "Mother's highest diploma" using this data?
Thank you,
Alon