If you want your transactions to be able to convert the value to missing then you need to set the value to ._ in the transaction dataset. data master; input ID $ var1 $ var2 $; datalines; 123 Yes Red 124 No Blue 125 Yes Yellow ;;;; data trans ; infile cards truncover ; if 0 then set master; input id= var1= var2= ; datalines; id=123 var1= No id=123 var2= Orange id=124 var2= Red id=125 var1= _ ;;;; data Final; update master trans; by ID; run; proc print; run;
... View more
