thanks for your suggestions. - "sample of output" is actual result (I added a first column to indicate the rows I ideally want to retain) - Each unique id in Unique_ID_A, I only want to see once (e.g., 975059187 appears twice) -Additionally, there is also a unique identifier from table B (i.e., I would like to retain 536184298 linked with 975059187) -Some details on this data: table B captures anytime an agent processes a credit on an account. Could be more than 1 credit for same account same day, and could get deleted prior to getting processed. table A captures credits that did get processed. The objective is to identify which credits did get processed for a given agent. -Additional rules: the linking variable between both tables is the acct_id. Then the criteria is, match by date, and amount. - Also, each table contains a unique identifier whose sequence is linear (a greater number means the credit got processed later) Perhaps a data step merge is best approach to do the join?
... View more