Forgive me if this is easy to do but I am new to SAS. I am trying to do a proc sql and use a text string as the match key. The only problem is that the string changes between 4 or 2 digits and I need to either do a match to the 4 digit if it exists or to match to the 2 digit if the 4 is not available. For example in table 1 I have: ABCD ABDH EFGH GHIJ In table 2 I have: AB ABCD EF GHIJ I would want it to match as: ABCD -> ABCD ABDH-> AB EFGH-> EF GHIJ-> GHIJ I hope that makes sense? ... View more