I agree with KSharp, the narrative and the examples are confusing. Particularly as the narrative seems to be missing variables and you have 3 heading and 4 pieces of data in the sample.
Reading between the lines, I generally attack this sort of problem with PROC SQL. The idea of a "fuzzy" match or "nearest" match on dates is a natural for the BETWEEN operator on a JOIN. There are good examples of this in the SQL reference manual as well as in several BBUs.
Doc Muhlbaier
Duke
... View more
