How to simplify the PROC SQL inner join?

[ybz12003]

Hi all:

I have the following codes list below.  I am wondering if there is a way to simply them.  Thanks.

proc sql;

create table test2Match_class as

select a.*

from test2 as a inner join

test1 as b on a.Analysis=b.Analysis and a.class=b.product;

quit;

proc sql;

create table test2Match_component as

select a.*

from test2 as a inner join

test1 as b on a.Analysis=b.Analysis and a.component=b.product;

quit;

proc sql;

create table test2Match_product as

select a.*

from test2 as a inner join

test1 as b on a.Analysis=b.Analysis and a.Product=b.Product;

quit;

data matchtotal;

set test2Match_class test2Match_component test2Match_product;

run;

[Reeza]

Try combining your conditions with an OR statement.

proc sql;
create table test2Match_class as
select a.*
from test2 as a inner join
test1 as b on a.Analysis=b.Analysis and a.class=b.product or a.component=b.product or a.product=b.product;



;
quit;
 

[Kurt_Bremser · Accepted solution]

I think you need brackets:

proc sql;
create table test2Match_class as
select a.*
from test2 as a inner join
test1 as b on a.Analysis=b.Analysis and (a.class=b.product or a.component=b.product or a.product=b.product);
quit;