Hi how do I convert SQL delete statements into Proc SQL delete statements? I would like to convert the following sql to proc sql. delete #campaigntrk_comb from #campaigntrk_comb a, campaigndb.dbo.CampaignTrck_Ended b where a.NBID = b.nbid and A.trandate = b.Trandate and a.campcode <> b.targetcampaign go I tried the following which does not work: proc sql; delete from campaigntrk_comb as a where EXISTS (select a.nbid, a.trandate, a.campcode from camp.CampaignTrck_Ended as b where a.NBID = b.nbid and a.trandate = b.Trandate and a.campcode NE b.targetcampaign); quit; and I did at left outer join to exclude data and the result is different. Thanks.
... View more