Here's a try for simple data such as you show.
If there are many duplicates of ID*date combinations may not work.
proc sql;
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;
quit;
Here's a try for simple data such as you show.
If there are many duplicates of ID*date combinations may not work.
proc sql;
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;
quit;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.