This is not a macro error, although your use of macros makes it more complicated to see. Your code
proc sql;
create table _temp_ as
select
name
,age
,case %Assign_99_999(nos_iteration=&records_flow_id_value., ColumnName=Column1) end as Column1
from class
;quit;
resolves to
proc sql;
create table _temp_ as
select
name
,age
,case 0>=1 and lengthN(Column1)=0 then "-999" else Column1 end as Column1
from class
;quit;
and if you had typed this yourself without macros, you would get the same error. This is invalid SQL code. Please look at it carefully and find the SQL error.
... View more