topic %EVAL error in SAS Programming

%EVAL error

vnreddy — Mon, 05 Jul 2021 10:24:24 GMT

Hi,

I am using below code to identiy the yyyymm in old vs new path. I am getting %EVAL error, could someone help me with it.


%macro comp(yyyymm);
%let new_path = /sas/Prod/Data/July21/&yyyymm.;
%if %eval(&yyyymm. IN 
	200701 200704
	200810
	200905 200906 200911 200912
	201005 201006 201011 201012
	201205 201206 201209 
	201408 201409 201410 201411 201412)|(&yyyymm. >= 201704 & &yyyymm. <= 202008) %then %do;
	%let old_path = /sas/Prod/&yyyymm.;
	%end;
%else %if &yyyymm. = 200808 | &yyyymm. = 200809 | (&yyyymm. >= 201301 & &yyyymm. <= 201612) |  (&yyyymm. >= 201701 & &yyyymm. <= 201703) %then %do;
	%let old_path = /sas/Prod/BT/&yyyymm.;
	%end;
%else %do;
	%let old_path = /sas/Prod/Repair/&yyyymm.;
	%end;


LIBNAME N&yyyymm. "&new_path." access=readonly;
LIBNAME O&yyyymm. "&old_path.";
%mend;

%comp(200701);

error :

ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:

200701 IN 200701 200704 200810 200905 200906 200911 200912 201005 201006 201011 201012 201205 201206 201209 201408

201409 201410 201411 201412

ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:

%eval(&yyyymm. IN 200701 200704 200810 200905 200906 200911 200912 201005 201006 201011 201012 201205 201206 201209

201408 201409 201410 201411 201412)|(&yyyymm. >= 201704 & &yyyymm. <= 202008)

2 The SAS System 11:15 Monday, July 5, 2021

ERROR: The macro COMP will stop executing.

Re: %EVAL error

andreas_lds — Mon, 05 Jul 2021 10:44:17 GMT

As always i recommend to write code without macro-statements and after the code has been tested, create a macro if necessary.

If the option minoperator is active in your sas session, you could use

%if &yyyymm. in (200701 200704 ....) %then %do; ...

Re: %EVAL error

vnreddy — Mon, 05 Jul 2021 11:51:06 GMT

unfortunately, no luck ended up with new error.

ERROR: Required operator not found in expression: &yyyymm. in (200701 200704 200810 200905 200906 200911 200912 201005 201006
201011 201012 201205 201206 201209 201408 201409 201410 201411 201412) |(&yyyymm. >= 201704 & &yyyymm. <= 202008)

Re: %EVAL error

andreas_lds — Mon, 05 Jul 2021 12:27:27 GMT

Please verify that minoperator is active.

Re: %EVAL error

Astounding — Mon, 05 Jul 2021 12:54:21 GMT

As you probably know, the IN operator can be tricky in macro language. Global options have to be properly in place, and properly utilized in your code.

Before getting to that point, get rid of %EVAL. It serves no purpose in your code, and just complicates the logic. It is likely that %EVAL would not even be the correct function, and you would need to switch to %SYSEVALF. But you actually can get by with neither.

Re: %EVAL error

Amir — Mon, 05 Jul 2021 13:30:07 GMT

Hi @vnreddy,

As @andreas_lds has advised, one way to check the minoperator (allows you to use the in operator in a macro) is:

proc options option=minoperator;
run;

As you are only using logic, the %eval is not required. If you don't want to change the global value of the minoperator option, then you can specify it as an option on the %macro statement.

%macro comp(yyyymm) / minoperator;

More information can be found in the documentation:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p1nypovnwon4uyn159rst8pgzqrl.htm

Kind regards,

Amir.