topic Re: " Required operator not found in expression" in SAS Programming

" Required operator not found in expression"

GabrielGajardo — Mon, 19 Dec 2016 21:06:13 GMT

hi all.

Due to @Reeza, recomendation im opening this thread.

I am new at sas and having some issues with %IF %ELSE conditions, I am trying to write a macro to execute some code on the when the last date, on a data set, is from "today - 1" but whe i run the macro it keep giving the error "Required operator not found in expression"

/* +++++++++ Variables*/
rsubmit;
proc sql;
 select max(offer_Date) into :valDateSales
 from qwer ;
quit;
proc sql;
 select max(offer_Date) into :valDateOffers
 from asdf;
quit;
%let maxDateSales= %sysfunc(substrn(&valDateSales.,1,9));
%let maxDateOffers= %sysfunc(substrn(&valDateOffers.,1,9));
endrsubmit;

/* +++++++++ MACRO*/

 %macro Continuity(MaxDateSales, MaxDateOffers);
     %Let yesterday = %eval(%sysfunc(today())-1);
        %if ("&MaxDateSales."d eq "&yesterday."d)%then %do;
              %if ("&MaxDateOffers."d eq "&yesterday."d))  %then %do;
                  %export_to_Drive(ds=workunx.X, outf_name=ASDF..csv)
                  %export_to_Drive(ds=workunx.Y, outf_name=qwer.csv)
                  %export_to_ftp(dsn=workunx.x,outfile_name=asdf..csv)); 
                  %export_to_ftp(dsn=workunx.Y ,outfile_name=qwer..csv));
                  %successMailing();
                  %put "succes statement";
              %end;
              %else %do;
                  %failMailing();
              %end
        %else %do;
              %failMailing();
              %put "fail statement";
        %end;
  %mend;

/*++++++LOG

693  %Continuity(MaxDateSales=&MaxDateSales., MaxDateOffers=&MaxDateOffers.);
MLOGIC(CONTINUITY):  Beginning execution.
SYMBOLGEN:  Macro variable MAXDATESALES resolves to 20806
SYMBOLGEN:  Macro variable MAXDATEOFFERS resolves to 20806
MLOGIC(CONTINUITY):  Parameter MAXDATESALES has value 20806
MLOGIC(CONTINUITY):  Parameter MAXDATEOFFERS has value 20806
MLOGIC(CONTINUITY):  %LET (variable name is YESTERDAY)
SYMBOLGEN:  Macro variable MAXDATESALES resolves to 20806
SYMBOLGEN:  Macro variable YESTERDAY resolves to 20806
MLOGIC(CONTINUITY):  %IF condition ("&MaxDateSales."d eq "&yesterday."d) is TRUE
SYMBOLGEN:  Macro variable MAXDATEOFFERS resolves to 20806
SYMBOLGEN:  Macro variable YESTERDAY resolves to 20806
ERROR: Required operator not found in expression: ("&MaxDateOffers."d eq "&yesterday."d))
ERROR: The macro CONTINUITY will stop executing.
MLOGIC(CONTINUITY):  Ending execution.
NOTE: Remote submit to A complete.

well as i have said, i am new at SAS so please, any help will be appreciated.

Re: " Required operator not found in expression"

Reeza — Mon, 19 Dec 2016 21:10:14 GMT

Your macro is nested and you're calling several different macros. I think the error is in one of those macros, not the one shown.

Is this your code or are you running someone else's and trying to debug?

PS please try and format the code, I know the forum does change it sometimes, but the current layout is difficult to read.

Re: " Required operator not found in expression"

GabrielGajardo — Mon, 19 Dec 2016 21:21:48 GMT

1.- it is my code, but is an extention for an older code of some one else.

2.- i have tried to comment all the macros that this code is calling, but the error stay there.

3.- i have tried to format de posted code, but the forum change it a lot =(

thaks for the quick reply

Re: " Required operator not found in expression"

Reeza — Mon, 19 Dec 2016 21:29:10 GMT

Try fixing this issue:

SYMBOLGEN:  Macro variable MAXDATESALES resolves to 20806
SYMBOLGEN:  Macro variable MAXDATEOFFERS resolves to 20806

Your code:

 %if ("&MaxDateOffers."d eq "&yesterday."d))  %then %do;

Replacing the values generates invalid SAS code:

 %if ("20806"d eq "20806"d))  %then %do;

Your dates are not formatted correctly. So either format them as Date9 or remove the D from the comparison.

It should look like:

 %if ("18Dec2016"d eq "18Dec2016"d))  %then %do;

Re: " Required operator not found in expression"

Astounding — Tue, 20 Dec 2016 03:06:28 GMT

It can't hurt to remove the d (as Reeza suggested). But the likely cause of the problem is that you have an extra right-hand parenthesis on that same line of code.

(Also note a couple of instances of an extra right-hand parenthesis on two of the later lines that call the macro.)

Re: " Required operator not found in expression"

Shmuel — Mon, 19 Dec 2016 22:29:28 GMT

As %IF compares character strings ther is no need -

neither to use "&var"d nor change into "ddmmmyy"d

but just to use

%if &MAXDATESALES = &MAXDATEOFFERS

Re: " Required operator not found in expression"

GabrielGajardo — Tue, 20 Dec 2016 14:46:23 GMT

thank you for notice it!

Re: " Required operator not found in expression"

GabrielGajardo — Tue, 20 Dec 2016 14:47:30 GMT

thank you it help, not solve it but help a lot.