topic Help with SAS Global Statement not supported in PROC SQL in SAS Procedures

Help with SAS Global Statement not supported in PROC SQL

bradja — Thu, 31 Aug 2017 06:55:34 GMT

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;

Re: Help with SAS Global Statement not supported in PROC SQL

Astounding — Thu, 31 Aug 2017 07:47:00 GMT

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

Re: Help with SAS Global Statement not supported in PROC SQL

bradja — Thu, 31 Aug 2017 23:32:49 GMT

*facepalm*

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

Re: Help with SAS Global Statement not supported in PROC SQL

eduardocuco — Wed, 02 May 2018 16:51:07 GMT

The same issue happened to me

Re: Help with SAS Global Statement not supported in PROC SQL

adrianet86 — Tue, 27 Nov 2018 17:47:08 GMT

Thank you!