Newbie here. I have 2 datasets I'm trying to combine, keeping only those observations from the 2nd dataset: Dataset1 - a person month file, this dataset holds all my variables and each observation for ID/PERSON is repeated for the MONTH=1 to 12 ID PERSON MONTH VAR1 1 1 1 2 1 1 2 3 1 1 3 7 2 1 1 2 Dataset2 - a person file ID PERSON VAR3 I want to merge the 2 datasets, so the final dataset will only keep those observations from Dataset2, but pull in all variables from Dataset1, as well as those observations repeated in the MONTH varaible. Is there an easy way to do this? I've tried the following, but it's not working as expected: proc sort data=Dataset1; by ID PERSON; run; proc sort data=Dataset2; by ID PERSON; run; data final; merge Dataset1 (in=a) Dataset2; by ID PERSON; if a; run; Any help would be appreciated!
... View more