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
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:
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.