Okay - here is a sample of my data:
Observation......Variable:marital status.....Var:health.........Var:mother........
Person 1.................................1...........................3.............."mother code 1"
Person 2.................................1...........................3.............."mother code 1"
Person 3.................................2...........................1.............."mother code 1"
Person 4.................................1...........................2.............."mother code 2"
Person 5.................................1...........................3.............."mother code 2"
Person 6.................................1...........................3.............."mother code 3"
Person 7.................................2...........................4.............."mother code 3"
I am going to find out, if two siblings, who are discordant on e.g. marital status at age 30, experience the same kind health outcomes later in life. In order to find out which of the persons in my dataset are related, I am going to use the "mother code". If two (or more) persons have the same mother code, they are related. So in other words, I am going to perform a fixed effect analysis of each of the sibling pairs in my dataset. If a person has more than one sibling, the pairwise comparison will be made between all of them (as long as they are discordant on marital status).
I would like to start finding out the number of siblings who are discordant on marital status (and later on perform survival analysis). But I dont know how to arrange my data in order to do this pairwise comparison.
Please let me know if you need more information
Thank you