Hi all,
I just want to know can we get non matching observations using joins.
Thanks&Regards
rawindarreddy
Do your mean SQL's join ?
Yes. you can do it .But I would like to use IN operator to get it.
The following pick up the records which is in b, not in a .
data a; set sashelp.class(keep=name obs=10); retain _dummy 10; run; data b; set sashelp.class; run; proc sql; create table not_matched as select b.* from b left join a on b.name eq a.name where a.name is missing ;quit;
Ksharp
Yes Rawinder, We can sure get non matching onservation from joins.
Please check the example.
data one;
input id suspect;
cards;
2 3
6 3
2 4
5 4
9 8
;
run;
data two;
input id suspect;
cards;
5 1
3 1
2 4
5 4
9 8
;
run;
proc sql;
select * from one full join two on one.id=two.id where one.id ne two.id;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.