topic How to simplify the PROC SQL inner join? in SAS Procedures

How to simplify the PROC SQL inner join?

ybz12003 — Thu, 01 Feb 2018 16:01:48 GMT

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;

Re: How to simplify the PROC SQL inner join?

Reeza — Thu, 01 Feb 2018 16:17:28 GMT

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;

Re: How to simplify the PROC SQL inner join?

Kurt_Bremser — Thu, 01 Feb 2018 17:13:51 GMT

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;