topic Merging multiple datasets, but only matching information in New SAS User

Merging multiple datasets, but only matching information

sassy_seb — Mon, 08 Jul 2024 15:26:35 GMT

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.

Re: Merging multiple datasets, but only matching information

PaigeMiller — Mon, 08 Jul 2024 15:46:37 GMT

data want;

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

by id;

if in1 and in2 and in3;

run;