Help using Base SAS procedures

delete statement in Proc SQL

Reply
New Contributor
Posts: 2

delete statement in Proc SQL

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.

Occasional Contributor
Posts: 18

Re: delete statement in Proc SQL

Syntax seems to be fine. What error do you get?

Super User
Posts: 13,583

Re: delete statement in Proc SQL

Doesn't work is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of a dataset, the actual results and the expected results. Data should be in the form of a data step. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Ask a Question
Discussion stats
  • 2 replies
  • 145 views
  • 0 likes
  • 3 in conversation