This question is a bit vague but I need to know how I can go about doing something like this in SAS and even if it is possible. Here is the scenario: I am trying to connect mothers to there children. I will have families identified. Therefore, I will have family A, with family members 1, 2, 3, 4, 5. For each member, I will know which members are mothers, and which are kids. I have to connect mothers to their children. Children have a variable equal to the ID number of their mother. How can I connect them? It would require SAS to look at a child's connection number, within a family, and link it to his/her mom based on her ID number. This would require me to "jump" accross the members of a family looking to match these two variables. I do not know where to look regarding SAS to learn how to do this. Thank you for your time.
... View more