https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694673#M25134 <P>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?</P> Tue, 27 Oct 2020 20:20:23 GMT hjjijkkl 2020-10-27T20:20:23Z https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694673#M25134 <P>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?</P> Tue, 27 Oct 2020 20:20:23 GMT https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694673#M25134 hjjijkkl 2020-10-27T20:20:23Z https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694674#M25135 <P>So you want to find ID's that are present in all three datasets?</P> Tue, 27 Oct 2020 20:26:33 GMT https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694674#M25135 Kurt_Bremser 2020-10-27T20:26:33Z https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694685#M25136 Yes. Tue, 27 Oct 2020 20:49:28 GMT https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694685#M25136 hjjijkkl 2020-10-27T20:49:28Z https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694690#M25137 <PRE><CODE class=" language-sas">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;</CODE></PRE> Tue, 27 Oct 2020 21:06:47 GMT https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694690#M25137 Kurt_Bremser 2020-10-27T21:06:47Z https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694705#M25139 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 ? Tue, 27 Oct 2020 21:44:33 GMT https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694705#M25139 hjjijkkl 2020-10-27T21:44:33Z https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694925#M25151 What if we want to compare more than one variable? For example, ID and start date? How would you modify the above code ? Wed, 28 Oct 2020 15:59:11 GMT https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694925#M25151 hjjijkkl 2020-10-28T15:59:11Z https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694960#M25155 <P>Expand the where condition, if you need to check for combinations of id and date.</P> <P>If you only need to check the date itself, run a separate select similar to the one for id.</P> Wed, 28 Oct 2020 17:37:50 GMT https://communities.sas.com/t5/New-SAS-User/How-to-compare-different-dataset/m-p/694960#M25155 Kurt_Bremser 2020-10-28T17:37:50Z