I'm not sure why you have the %str in the %let statement, but if you keep that then you need to change your insert statement to:
insert into work.matrix_state (id_state, state_name) values (2, %unquote(&var1));
and that should work for you.
Michelle
... View more