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;
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.