Thank you so much, Shmuel! This worked perfectly and led me to learn more about the cntlin= option here http://www2.sas.com/proceedings/forum2007/068-2007.pdf ... View more

Thanks- I should clarify.   There are as many as six loans recorded for each observation in data set A, so there are potentially six unique dates for when the loan was taken out.   I can do six merges, but I'm almost sure there is a better way to handle this. Here's what I'd like to do:   Data set A: X7804   X7827   X7850   X7904   X7927   X7950 1913     1913     1914      1915     1916     . ...   Data set B: Year     CPI 1913    9.783333333 1914    9.9 1915    10.03333333 1916    10.56666667 1917    12.35 ...   Desired Data Set:   X7804   X7827   X7850   X7904   X7927   X7950   CPI1    CPI2      CPI3      CPI4      CPI5      CPI6 1913     1913     1914      1915     1916     .             9.783   9.783    9.9         10.03     10.57     .     ... View more