topic Re: joins in SAS Procedures

joins

rawindar — Fri, 04 May 2012 06:55:20 GMT

Hi all,

I just want to know can we get non matching observations using joins.

Thanks&Regards

rawindarreddy

Re: joins

Ksharp — Fri, 04 May 2012 08:23:57 GMT

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

Re: joins

Jagadishkatam — Fri, 04 May 2012 08:28:07 GMT

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;

Re: joins

shivas — Fri, 04 May 2012 08:59:51 GMT

Hi Ravi,

Check this...

https://communities.sas.com/message/122974#122974

Thanks,

Shiva