Hello all.

I am trying to use the IN operator in macro code, but cannot get it to work. the code look like this:

%if &RptMBS2 # Middle Key %then %do ; . . %end;

The Log issues the following error: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &RptMBS2 # Middle Key

All I am trying to do is check for the condition that the Character value of &RptMBS2 is either 'Middle' or 'Key'.

Anyone know why this doesn't work?

Thanks -Paul