joins

[rawindar]

Hi all,

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

Thanks&Regards

rawindarreddy

[Ksharp]

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

[Jagadishkatam]

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;

[shivas]

Hi Ravi,

Check this...

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

Thanks,

Shiva