https://communities.sas.com/t5/SAS-Programming/Need-help-comparing-two-datasets-to-identify-new-clients/m-p/748178#M234946 <P>I have two sales data one from April the other one from May. The data sets are on transaction level.</P><P>&nbsp;</P><P>The April sales data looks like following</P><P>Transaction_Date Location_Number Client_Name</P><P>March 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P><P>March 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P><P>March 02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P><P>March 09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P><P>March 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>March 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>march 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>&nbsp;</P><P>The May data set looks like the following</P><P>Transaction_Date Location_Number Client_Name</P><P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P><P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P><P>May 02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P><P>May 09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P><P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P><P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P><P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P><P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P><P>&nbsp;</P><P>Client_Name now has ddd and eee as new clients which weren't there before. So I want to create a table which will have information for these new clients which I have added, so that the table looks like following</P><P>&nbsp;</P><P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P><P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P><P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P><P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P><P>&nbsp;</P><P>Any advice on how I would go about this? Thanks in advance!</P> Tue, 15 Jun 2021 17:10:55 GMT themanwith2thum 2021-06-15T17:10:55Z https://communities.sas.com/t5/SAS-Programming/Need-help-comparing-two-datasets-to-identify-new-clients/m-p/748178#M234946 <P>I have two sales data one from April the other one from May. The data sets are on transaction level.</P><P>&nbsp;</P><P>The April sales data looks like following</P><P>Transaction_Date Location_Number Client_Name</P><P>March 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P><P>March 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P><P>March 02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P><P>March 09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P><P>March 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>March 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>march 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>&nbsp;</P><P>The May data set looks like the following</P><P>Transaction_Date Location_Number Client_Name</P><P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P><P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P><P>May 02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P><P>May 09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P><P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P><P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P><P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P><P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P><P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P><P>&nbsp;</P><P>Client_Name now has ddd and eee as new clients which weren't there before. So I want to create a table which will have information for these new clients which I have added, so that the table looks like following</P><P>&nbsp;</P><P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P><P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P><P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P><P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P><P>&nbsp;</P><P>Any advice on how I would go about this? Thanks in advance!</P> Tue, 15 Jun 2021 17:10:55 GMT https://communities.sas.com/t5/SAS-Programming/Need-help-comparing-two-datasets-to-identify-new-clients/m-p/748178#M234946 themanwith2thum 2021-06-15T17:10:55Z https://communities.sas.com/t5/SAS-Programming/Need-help-comparing-two-datasets-to-identify-new-clients/m-p/748180#M234948 <PRE><CODE class=" language-sas">proc sql; create table want as select * from table1 where client_name not in (select distinct client_name from table2); quit;</CODE></PRE> <P>SQL is usually the easiest method.</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/378300">@themanwith2thum</a>&nbsp;wrote:<BR /> <P>I have two sales data one from April the other one from May. The data sets are on transaction level.</P> <P>&nbsp;</P> <P>The April sales data looks like following</P> <P>Transaction_Date Location_Number Client_Name</P> <P>March 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P> <P>March 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P> <P>March 02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P> <P>March 09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P> <P>March 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P> <P>March 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P> <P>march 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P> <P>&nbsp;</P> <P>The May data set looks like the following</P> <P>Transaction_Date Location_Number Client_Name</P> <P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P> <P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aaa</P> <P>May 02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P> <P>May 09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bbb</P> <P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P> <P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P> <P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ccc</P> <P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P> <P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P> <P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P> <P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P> <P>&nbsp;</P> <P>Client_Name now has ddd and eee as new clients which weren't there before. So I want to create a table which will have information for these new clients which I have added, so that the table looks like following</P> <P>&nbsp;</P> <P>May 06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P> <P>May 07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 055&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ddd</P> <P>May 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P> <P>May 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 087&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eee</P> <P>&nbsp;</P> <P>Any advice on how I would go about this? Thanks in advance!</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Tue, 15 Jun 2021 17:12:58 GMT https://communities.sas.com/t5/SAS-Programming/Need-help-comparing-two-datasets-to-identify-new-clients/m-p/748180#M234948 Reeza 2021-06-15T17:12:58Z