I have 2 tables I need to create a new table where the key doesn't match here is example TABLE 1 ID. date. key A. 06/01/15. 1 A. 06/02/16. 23 here is example TABLE 2 ID. date. key A. 06/01/15. 3 A. 06/02/16. 23
here what I want to see
TABLE 3 ID. date. key A. 06/02/16. 3 The key 1 is not needed ... I'm kicking around merge I just need the key where there is no match thanks
If there are many duplicates of ID*date combinations may not work.
create table want
as select b.*
from table1 as a left join table2 as b
on a.id=b.id and a.date=b.date
where a.key ne b.key;
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.