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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: