Hello, I have a problem with identifying the observations I need in my data (an also a hard time giving this post a proper subject/title). My data is at household level and I would like to identify the parents to some of the children (in my control group) within a household. My dataset looks like: data have; Household_ID Person_ID Person_no_household Mom_no_houshold Dad_no_houshold Control Parent 100 201 1 . . 0 . 100 202 3 1 2 1 . 101 203 4 1 2 0 . 102 204 3 1 . 0 . And this is what I would like to have: data want; Household_ID Person_ID Person_no_household Mom_no_houshold Dad_no_houshold Control Parent 100 201 1 . . 0 1 100 202 3 1 2 1 0 101 203 4 1 2 0 0 102 204 3 1 . 0 0 Basically I have the parents number within the given household, but I need to have the parent's Unique id number (Person_ID). I do not know with which procedure to start with or search for, so you have any ideas to what I should look at, it would be highly appreciated! Thank you! (If it is relevant - I am using SAS Enterprise Guide 7.1 (64-bit))
... View more
