topic JOIN TWO TABLE in New SAS User

JOIN TWO TABLE

AP718 — Fri, 08 Nov 2019 16:19:24 GMT

From the below example please show how can I take the columns from T1.A and T1.B and join the T2.B column?

T1.A	T1.B		T2.A	T2.B
BLK	234		BLK	768
WHITE	123		WHITE	8765
BLUE	456		BLUE	234

T1.A	T1.B	T2.B
BLK	234	768
WHITE	123	8765
BLUE	456	234

Re: JOIN TWO TABLE

Kurt_Bremser — Fri, 08 Nov 2019 16:27:51 GMT

You join on T1.A=T2.A, that's obvious, isn't it?

proc sql;
create table want as
select
  T1.A,
  T1.B,
  T2.B
from T1 left join T2
on T1.A = T2.A;
quit;

Re: JOIN TWO TABLE

Patrick — Sun, 10 Nov 2019 22:48:24 GMT

And because column B exists in both source tables you need to rename it for the target table as there can't be two columns with the same name in the same table. Below @Kurt_Bremser 's SQL amended accordingly.

proc sql;
  create table want as
    select
      T1.A,
      T1.B as T1_B,
      T2.B as T2_B
    from T1 left join T2
    on T1.A = T2.A
    ;
quit;