topic SAS join based on latest records in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-join-based-on-latest-records/m-p/671363#M201593 <P>Hi Team,</P><P>&nbsp;</P><P>I have two data sets, when i tried to joining two tables all the records are getting copied from right table except few date columns missing. after certain records its pasting.</P><P>&nbsp;</P><P>Example below:-&nbsp;</P><P>&nbsp;</P><P>Table :-&nbsp;</P><TABLE><TBODY><TR><TD>Number</TD><TD>Closed</TD><TD>Sales rep</TD></TR><TR><TD>96771</TD><TD>7/22/2020 0:00</TD><TD>Madhu</TD></TR><TR><TD>96768</TD><TD>&nbsp;</TD><TD>Radha</TD></TR><TR><TD>96771</TD><TD>7/21/2020 17:59</TD><TD>Shankar</TD></TR><TR><TD>90962</TD><TD>7/20/2020 17:59</TD><TD>Madhu</TD></TR><TR><TD>95527</TD><TD>&nbsp;</TD><TD>Radha</TD></TR><TR><TD>93647</TD><TD>&nbsp;</TD><TD>Shankar</TD></TR><TR><TD>96362</TD><TD>7/22/2020 17:59</TD><TD>Madhu</TD></TR><TR><TD>96361</TD><TD>7/20/2020 17:59</TD><TD>Radha</TD></TR><TR><TD>96339</TD><TD>&nbsp;</TD><TD>Shankar</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><BR />Table B</P><TABLE><TBODY><TR><TD>Number</TD><TD>Closed</TD><TD>Supplies</TD><TD>Vendor</TD></TR><TR><TD>96771</TD><TD>7/22/2020 17:59</TD><TD>Ink</TD><TD>Abc</TD></TR><TR><TD>96768</TD><TD>7/22/2020 17:59</TD><TD>Pen</TD><TD>BCD</TD></TR><TR><TD>96765</TD><TD>7/22/2020 17:59</TD><TD>Printer</TD><TD>Abc</TD></TR><TR><TD>96762</TD><TD>7/22/2020 17:59</TD><TD>Ink</TD><TD>BCD</TD></TR><TR><TD>96759</TD><TD>7/22/2020 17:59</TD><TD>Pen</TD><TD>BD</TD></TR><TR><TD>96756</TD><TD>7/22/2020 17:59</TD><TD>Printer</TD><TD>CD</TD></TR><TR><TD>96753</TD><TD>7/22/2020 17:59</TD><TD>Ink</TD><TD>Abc</TD></TR><TR><TD>96750</TD><TD>7/22/2020 17:59</TD><TD>Pen</TD><TD>Abc</TD></TR><TR><TD>96747</TD><TD>7/22/2020 17:59</TD><TD>Printer</TD><TD>Bcd</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need output like latest record based on closed column from table b as join to table A.&nbsp;</P> Wed, 22 Jul 2020 12:42:23 GMT anare 2020-07-22T12:42:23Z SAS join based on latest records https://communities.sas.com/t5/SAS-Programming/SAS-join-based-on-latest-records/m-p/671363#M201593 <P>Hi Team,</P><P>&nbsp;</P><P>I have two data sets, when i tried to joining two tables all the records are getting copied from right table except few date columns missing. after certain records its pasting.</P><P>&nbsp;</P><P>Example below:-&nbsp;</P><P>&nbsp;</P><P>Table :-&nbsp;</P><TABLE><TBODY><TR><TD>Number</TD><TD>Closed</TD><TD>Sales rep</TD></TR><TR><TD>96771</TD><TD>7/22/2020 0:00</TD><TD>Madhu</TD></TR><TR><TD>96768</TD><TD>&nbsp;</TD><TD>Radha</TD></TR><TR><TD>96771</TD><TD>7/21/2020 17:59</TD><TD>Shankar</TD></TR><TR><TD>90962</TD><TD>7/20/2020 17:59</TD><TD>Madhu</TD></TR><TR><TD>95527</TD><TD>&nbsp;</TD><TD>Radha</TD></TR><TR><TD>93647</TD><TD>&nbsp;</TD><TD>Shankar</TD></TR><TR><TD>96362</TD><TD>7/22/2020 17:59</TD><TD>Madhu</TD></TR><TR><TD>96361</TD><TD>7/20/2020 17:59</TD><TD>Radha</TD></TR><TR><TD>96339</TD><TD>&nbsp;</TD><TD>Shankar</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><BR />Table B</P><TABLE><TBODY><TR><TD>Number</TD><TD>Closed</TD><TD>Supplies</TD><TD>Vendor</TD></TR><TR><TD>96771</TD><TD>7/22/2020 17:59</TD><TD>Ink</TD><TD>Abc</TD></TR><TR><TD>96768</TD><TD>7/22/2020 17:59</TD><TD>Pen</TD><TD>BCD</TD></TR><TR><TD>96765</TD><TD>7/22/2020 17:59</TD><TD>Printer</TD><TD>Abc</TD></TR><TR><TD>96762</TD><TD>7/22/2020 17:59</TD><TD>Ink</TD><TD>BCD</TD></TR><TR><TD>96759</TD><TD>7/22/2020 17:59</TD><TD>Pen</TD><TD>BD</TD></TR><TR><TD>96756</TD><TD>7/22/2020 17:59</TD><TD>Printer</TD><TD>CD</TD></TR><TR><TD>96753</TD><TD>7/22/2020 17:59</TD><TD>Ink</TD><TD>Abc</TD></TR><TR><TD>96750</TD><TD>7/22/2020 17:59</TD><TD>Pen</TD><TD>Abc</TD></TR><TR><TD>96747</TD><TD>7/22/2020 17:59</TD><TD>Printer</TD><TD>Bcd</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need output like latest record based on closed column from table b as join to table A.&nbsp;</P> Wed, 22 Jul 2020 12:42:23 GMT https://communities.sas.com/t5/SAS-Programming/SAS-join-based-on-latest-records/m-p/671363#M201593 anare 2020-07-22T12:42:23Z Re: SAS join based on latest records https://communities.sas.com/t5/SAS-Programming/SAS-join-based-on-latest-records/m-p/671365#M201595 <P>Show us the output you want.</P> Wed, 22 Jul 2020 12:47:29 GMT https://communities.sas.com/t5/SAS-Programming/SAS-join-based-on-latest-records/m-p/671365#M201595 PaigeMiller 2020-07-22T12:47:29Z Re: SAS join based on latest records https://communities.sas.com/t5/SAS-Programming/SAS-join-based-on-latest-records/m-p/671407#M201618 <PRE><CODE class=" language-sas">proc sql; create table want as select b.*,a.Sales_rep from b b left join a a on a.id= b.id; quit; </CODE></PRE> Wed, 22 Jul 2020 14:37:49 GMT https://communities.sas.com/t5/SAS-Programming/SAS-join-based-on-latest-records/m-p/671407#M201618 smantha 2020-07-22T14:37:49Z