Extract Records Matching Criteria in another File
A common problem that presents itself when doing analysis is the need to extract detail records that match a list of values (criteria) in another file. This can range from simple to more complicated, primarily depending on the nature of the match. The following describes three approaches, based on the objective of the analysis. Simple question: A simple question of this type is where we have a file with detailed…