Hello Experts,
I have an anormal join result, for example, the key L004IV is common, but the result of left join is empty. I tried left, compress, right option, but it doesn't work.
My code is :
proc sql;
create table ACCORD13_1 as select a.*, b.*
from ACCORD2_q as a
left join DONNEEMAQUETTE3_q as b on left(a.CD_PRODUIT)=left(b.CD_PRODUIT)
;
quit;
The data is joined.
Thank you very much for your help!
... View more
