Hi, I'm still new at using SAS and I wanted to merge two large datasets, using two common variables (MRN and UEN). I'm using SAS studio. First dataset (on a much smaller scale): MRN UEN Drug 1234 1 x 1234 2 x 4567 1 x 7891 1 x Second dataset (on a much smaller scale): MRN UEN Doctor 1234 1 y 1234 2 y 4567 1 y 7891 1 y I need the final table to look like this MRN UEN Drug Doctor 1234 1 x y 1234 2 x y 4567 1 x y 7891 1 x y Not sure how to go about it. Any help would be appreciated! Thanks!
... View more