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?
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.
ok thanks, I think I know how to sort.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.