Merging multiple datasets, but only matching information

[sassy_seb]

Hello everyone, I had a question. How can I go about merging multiple datasets, but only IDs that are found in each dataset? Like if ID #1 is found in A, B, and C, and ID #2 is only found in A, the merged dataset should only return ID#1. 

[PaigeMiller · Accepted solution]

data want;

     merge a(in=in1) b(in=in2) c(in=in3);

     by id;

     if in1 and in2 and in3;

run;