First, I would advise you to test my suggestion with some simple made-up data, so you can verify if my idea works at all.
Next, you need to expand the _where_ variable in the update dataset so that it identifies unique observations:
data INC_TABLE;
set VALIBLA.INC_TABLE;
length _where_ $200;
_where_ = "name = '" !! strip(name) !! "' and year = " !! put(year,z4.) !! " and amount = " !! put(amount,best.);
run;
... View more
