I have two datasets: Set A: Michael, Rahul, Dalton, Barb....................1020 observations Set B: Disouza, Michael, Glory, Victoria, Daniel, Chip...............200 observations Desired: Set A: Michael, rahul, dalton, barb....................1020 observations Set B: Disouza, Glory, Victoria, Daniel, Chip,...........200 or less observa I would like to have unique names in set B. i.e., If names from set A are repeated in set B, I have to remove them. At the end, I need unique observations in Set B (200 or less but not more). What I did: I sorted the two files by name and then merged them by first name. Then I used the nodupkey and dupout to separate the repeated observations. But I couldn't create the same set B. My new set B has values from set A too. Any kind of help would be greatly appreciated.
... View more
