topic ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand in SAS Programming

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

kimdukes77 — Wed, 06 Dec 2017 10:00:21 GMT

Attempting to evaluate a macro variable variable and getting the following error.

A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:
(&num2.) not in (3 3A)

Can anyone help?

Re: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric oper

RW9 — Wed, 06 Dec 2017 10:12:36 GMT

Post the complete code around the error part, for instance what do you think &num is? Why do I ask, it is because there is no such thing as number in macro language - it is purely a text find and replace system. More complete code will show the problem, and likely show a better solution than doing this in macro in the first place.

Re: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric oper

kimdukes77 — Wed, 06 Dec 2017 10:18:24 GMT

ok thanks, I think I know how to sort.

Re: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric oper

Astounding — Wed, 06 Dec 2017 13:43:22 GMT

Your use of IN is incorrect, for a macro language statement. Macro language uses a different syntax than a DATA step for the IN operator. For correct usage, see this example:

http://support.sas.com/kb/35/591.html

Note that you will need to understand the MINOPERATOR and MINDELIMITER options, and will need to remove the parentheses.