how to combine 2 inner joins to proc sql

tmm — Wed, 29 Jan 2014 19:04:25 GMT

I have the following 3 proc sqls and trying to figure out how to make them just 1. The reason for this is I have a total of proc1 through proc20. I need to compared proc1 in main table to proc1 in second table. then proc2 in main table to proc2 in second table. then proc1 in main table to proc1 in second table and proc3 in main table to proc2 in second table. And so on.

proc sql;

create table p1 as

(select a.*,

b.proc1 as tbl1_proc1,
b.proc2 as tbl1_proc2,
b.edit

from

phyclms a

inner join c0 b

on a.proc1=b.proc1 and a.proc2=b.proc2

group by a.clm_aud_nbr);

quit;

proc sql;

create table p2 as

(select a.*,

b.proc1 as tbl1_proc1,
b.proc2 as tbl1_proc2,
b.edit

from

phyclms a

inner join c0 b

on a.proc1=b.proc1 and a.proc3=b.proc2

group by a.clm_aud_nbr);

quit;

proc sql;

create table p3 as

(select a.*,

b.proc1 as tbl1_proc1,
b.proc2 as tbl1_proc2,
b.edit

from

phyclms a

inner join c0 b

on a.proc1=b.proc1 and a.proc3=b.proc2

group by a.clm_aud_nbr);

quit;

Re: how to combine 2 inner joins to proc sql

Fugue — Wed, 29 Jan 2014 19:38:36 GMT

I don't really understand what you are trying to accomplish. Your description of the problem is somewhat unclear. In addition, your 2nd and 3rd PROC SQL statements appear to be identical.

In any case, have you considered using a series of LEFT joins instead of INNER joins?

Re: how to combine 2 inner joins to proc sql

tmm — Wed, 29 Jan 2014 19:41:47 GMT

Let me put together a data have. Might make better sense.

topic Re: how to combine 2 inner joins to proc sql in SAS Procedures

how to combine 2 inner joins to proc sql

Re: how to combine 2 inner joins to proc sql

Re: how to combine 2 inner joins to proc sql