Joining 3 tables in SAS SQL

Agent1592 — Mon, 02 Apr 2018 00:46:34 GMT

Dear SAS community, I am trying to create a more elegant code. I want to joint 3 tables have1, have2 and have3. The problem is that have1 table does not have id2 as a variable and first I have to link table have1 and have2. The code below is working but I would like to have a more elegant code because I may want to link more than 3 tables.

proc sql;
create table want1
        as select *,b.id2
        from have1 as a 
       left join have2  as b on a.id1=b.id1;
create table want2
   as select a.*, b.*
   from want1 as a left join have3 as c
   on a.id2=c.id2;

I tried something like this but it is not working because I do not have id2 in table have1. Could you please let me know what is the most concise code for this.

proc sql;
create table want
        as select *,b.id2
        from have1 as a 
       left join have2  as b on a.id1=b.id1
       left join have3 as c on a.id2=c.id2; quit;

Re: Joining 3 tables in SAS SQL

SASKiwi — Mon, 02 Apr 2018 01:59:18 GMT

proc sql;
  create table want
  as select *
  from have1 as a 
  left join have2  as b on a.id1=b.id1
  left join have3 as c on b.id2=c.id2
  ; 
quit;

topic Joining 3 tables in SAS SQL in SAS Programming

Joining 3 tables in SAS SQL

Re: Joining 3 tables in SAS SQL