Can anyone suggest a fix to this code? I'm trying to divide the value yr17 by the macro variable value &yr17 27 proc sql noprint; 28 select yr17 into :yr17 29 from T10_1 30 where Group=1; 31 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 32 33 options symbolgen; 34 proc sql; 35 select put(Group,Group_num.) as Group, Value, yr17, %eval(yr17/&yr17) as Pct17 SYMBOLGEN: Macro variable YR17 resolves to 4,618 ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: yr17/ 4,618 35 select put(Group,Group_num.) as Group, Value, yr17, %eval(yr17/&yr17) as Pct17 _____ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. 2 The SAS System 14:03 Tuesday, June 27, 2023 36 from T10_1 37 where Group=2; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 38 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
... View more