Help using Base SAS procedures

Help with SAS Global Statement not supported in PROC SQL

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

Help with SAS Global Statement not supported in PROC SQL

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;

 


Accepted Solutions
Solution
4 weeks ago
Super User
Posts: 5,263

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

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

View solution in original post


All Replies
Solution
4 weeks ago
Super User
Posts: 5,263

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

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

Occasional Contributor
Posts: 6

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

*facepalm*

 

Of course! I've removed the semicolon and it's working fine now Smiley Very Happy

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 243 views
  • 3 likes
  • 2 in conversation