Hi, I need some help with the case. I have something like this: %macro my_macro;      %do i = 1 %to 3;           proc sql;                create table my_table as                select                     my_text_column,                     my_numeric_column,                     my_numeric_column + 100 as new_name_%eval(my_numeric_column + &i.)                from other_table      %end; %mend; %my_macro; And here's the error I get: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:        my_numeric_column + 1 How can make a column with a name that contains equation with sql column value? For example when my_numeric_column equals 15 and i=1, the result I expect is new column name new_name_16 Thanks for the reply katrinaaa90 ... View more