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

ShammiKalsi — Mon, 29 Jan 2024 11:36:31 GMT

WARNING: Apparent symbolic reference MAXLIMIT not resolved.
WARNING: Apparent symbolic reference MAXLIMIT not resolved.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:
+&maxLimit
74 The SAS System Sunday, January 28, 2024 11:08:00 AM

ERROR: The macro RSKMGT_ADD_CUST_FIELDS will stop executing.
NOTE: {START: RSKMGT_MODIFY_DATE_TIME}
MPRINT(RSKMGT_MODIFY_DATE_TIME): proc sql noprint;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
MPRINT(RSKMGT_MODIFY_DATE_TIME): select EPOCH_LOCAL format=32. into :epoch_local from rgfcntl.time_difference;
NOTE: Statement not executed due to NOEXEC option.
MPRINT(RSKMGT_MODIFY_DATE_TIME): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode.
This prevents execution of subsequent data modification statements.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

NOTE: {START: RSKMGT_LIVE_NOW_SETUP}
NOTE: {END: RSKMGT_LIVE_NOW_SETUP}
MPRINT(RSKMGT_MODIFY_DATE_TIME): ;

MPRINT(RSKMGT_MODIFY_DATE_TIME): proc contents data=work.Incident out=cols noprint;
MPRINT(RSKMGT_MODIFY_DATE_TIME): run;

NOTE: The data set WORK.COLS has 0 observations and 41 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

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

Kurt_Bremser — Mon, 29 Jan 2024 12:38:12 GMT

The ERROR message without the code that caused it is useless. Copy/paste the complete log (include the whole macro definition and the macro call) into a window opened with this button:

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

ballardw — Mon, 29 Jan 2024 12:53:26 GMT

At a guess as code wasn't supplied you want to look at where the macro variable MAXLIMIT is supposed to be assigned values. Your log

WARNING: Apparent symbolic reference MAXLIMIT not resolved.
WARNING: Apparent symbolic reference MAXLIMIT not resolved.

indicates that no value has been assigned to the macro variable Maxlimit before your code attempted to use it.