Help with SAS Global Statement not supported in PROC SQL

[bradja]

Hi All,

Why does this give me a warning "This SAS global statement is not supported in PROC SQL. It has been ignored.

It is ignoring the WHERE line.

Is there another way I can dynamically use the 1st day of the previous month (based on yesterday) and yesterday for my startdate and enddate?

%LET startDate = intnx('month',today()-1,-1,"BEGINNING");
%LET endDate = today()-1;

proc sql;
  DELETE FROM CCEXTCSD.SQA_RESULTS;
  WHERE EVAL_LOCAL_DATE BETWEEN &startDate AND &endDate;
quit;

[Astounding · Accepted solution]

Have you tried removing the extra semicolon after SQA_RESULTS?  WHERE should be a clause, not a separate statement.

[bradja]

*facepalm*

Of course! I've removed the semicolon and it's working fine now 😄

[eduardocuco]

The same issue happened to me 

[adrianet86]

Thank you!