08-31-2017 02:55 AM
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;
Need further help from the community? Please ask a new question.