From your explanation, possibly a program-flow sequence using multiple sorts (one to filter update candidates; another to de-dup'ing to get one obs with min value from to data-matching table2), merge, with output to a tracking file for identifying deletions in the same DATA step as the MERGE (capture some key variables or _N_ obs # in table 2 for deletion candidate).
Scott Barry
SBBWorks, Inc.
... View more