topic Re: SQL Left Join in New SAS User

SQL Left Join

WilliamB — Fri, 30 Aug 2019 13:12:33 GMT

Hello,

I'm trying to get that

a	b	Copt
Tom	52	45678
Titi	88

But my code does not work:

Here is my code and my tables

Data employee;
input a $ b;
datalines;
Tom 52
Titi 88
;
run;

Data portefeuille;
input b Copt D;
datalines;
52 45671 201929
52 45678 201930
56 45897 201930

;
run;

proc sql;
create table comp as
select emp.*,Port.Copt
from employee as emp left join portefeuille as Port on Port.b=emp.b
where Port.D = 201930;
quit;

Thanks for your help

Re: SQL Left Join

novinosrin — Fri, 30 Aug 2019 13:22:27 GMT

Use AND

from employee as emp left join portefeuille as Port on Port.b=emp.b
and Port.D = 201930;

Re: SQL Left Join

WilliamB — Fri, 30 Aug 2019 13:25:40 GMT

Thank you so much. Have a good day