Hello,
I'm trying to get that
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