I'm a SAS beginner facing what seems to be an advanced question not addressed in the Enterprise Guide. Two datasets A and B both contain the same ID field. Dataset B has a Region field. Each ID in dataset B has a unique Region. I want to extract all the records in dataset A which have Region = 1 in dataset B. (Or Region = whatever value I choose.) Is there something obvious I am overlooking?
Or equally useful, I suppose, would be an approach to add the Region field to dataset A based on its values in Dataset B.