How to compare different dataset

[hjjijkkl]

I have three different datasets and I am trying to find same ID from the three datasets. I have used proc compare but, when using proc compare, you can only compare two datasets at a time. I was wondering if there is another way to compare the three data at the same time?

[Kurt_Bremser]

So you want to find ID's that are present in all three datasets?

[hjjijkkl]

Yes.

[Kurt_Bremser · Accepted solution]

proc sql;
create table want as
  select t1.id
  from table1 t1, table2 t2, table3 t3
  where t1.id = t2.id and t2.id = t3.id
;
quit;

[hjjijkkl]

Thank you! it worked. What if we want to compare more than one variable? For example, ID and start date? How would you modify the above code ?

[Kurt_Bremser]

Expand the where condition, if you need to check for combinations of id and date.

If you only need to check the date itself, run a separate select similar to the one for id.

[hjjijkkl]

What if we want to compare more than one variable? For example, ID and start date? How would you modify the above code ?