topic Re: Should %eval evaluate the FIND function? in SAS Programming

Should %eval evaluate the FIND function?

saras — Wed, 01 May 2019 21:51:52 GMT

When I run the following code (simplified from my original problem) I get the following error message :

ERROR: Required operator not found in expression: find("apple", "a")
ERROR: The macro TEST will stop executing.

Is there any reason I cannot use the %eval on the find function?

%macro test();
%let a=apple;
%let b=a;
%let c=%eval(find("&a", "&b"));
%put &c;
%mend test;
%test();

Re: Should %eval evaluate the FIND function?

Reeza — Wed, 01 May 2019 21:57:49 GMT

%EVAL() is for integer calculations primarily or condition checks. For functions you want %SYSFUNC() which you need to wrap around each SAS function to differentiate it from text.

You can use %SYSEVALF() to do decimal math.

@saras wrote:

When I run the following code (simplified from my original problem) I get the following error message :

ERROR: Required operator not found in expression: find("apple", "a")
ERROR: The macro TEST will stop executing.

Is there any reason I cannot use the %eval on the find function?

%macro test();
%let a=apple;
%let b=a;
%let c=%eval(find("&a", "&b"));
%put &c;
%mend test;
%test();

Re: Should %eval evaluate the FIND function?

ballardw — Wed, 01 May 2019 23:02:20 GMT

When running strictly macro code as you are the values of variables should seldom be inside quotes at all:

%macro test();
%let a=apple;
%let b=a;
%let c=%sysfunc(find("&a", "&b"));
%put Test value of c is &c;
%mend test;
%test(); 

%macro test2();
%let a=apple;
%let b=a;
%let c=%sysfunc(find(&a, &b));
%put Test2 value of c is &c;
%mend test2;

%test()
%test2()

Re: Should %eval evaluate the FIND function?

FreelanceReinh — Thu, 02 May 2019 12:06:21 GMT

Also, if there's a suitable macro function, you don't need to call a DATA step function:

%let c=%index(&a, &b);

Re: Should %eval evaluate the FIND function?

ChrisNZ — Tue, 28 May 2019 23:47:02 GMT

%EVAL() is for integer calculations primarily or condition checks. For functions you want %SYSFUNC() which you need to wrap around each SAS function to differentiate it from text.

You can use %SYSEVALF() to do decimal math.

Additionally,

%eval (and %sysevalf) can be used for boolean evaluations.

%sysevalf can interpret SAS dates strings correctly.

%put => %eval(%sysfunc(findw(bb ba,ba))>0); 
%put => %sysevalf('01jan1990'd);

=> 1
=> 10958