Help using Base SAS procedures

joins

Reply
Contributor
Posts: 70

joins

Hi all,

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

Thanks&Regards

rawindarreddy

Super User
Posts: 9,676

Re: joins

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

Trusted Advisor
Posts: 1,128

Re: joins

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;

Thanks,
Jag
Super Contributor
Posts: 349

Re: joins

Hi Ravi,

Check this...

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

Thanks,

Shiva

Ask a Question
Discussion stats
  • 3 replies
  • 194 views
  • 0 likes
  • 4 in conversation