Hello It seems that the reference to your second table is incorrect. Also the Left join syntax is incorrect. Please see below: proc sql noprint; create table pl201903.query as select a.*, b.ratecde AS ratecde_1 from pl201903.Fire_clm_201903 a left join pl201903.Fire_clm_cov_201903 b on a.claim=b.claim and a.zsumsi=b.totsi ; QUIT;
... View more