In reply to Lysbet.

proc sql allows you to use functions in join conditions, which has been eminently useful for me when the linking fields on my two (or more) datasets are not exact matches ,but have quantifiable similarity. You can get all the possible matches with liberal join criteria, and then select the best one with a "having" statement.