Here is a sample of the data set I have:
DIRMKT TIME YEAR --- DIRMKT TIME YEAR
ALBDCA 0535 2012 --- AGSDCA 1940 2013
BDADCA 1255 2012 --- ALBDCA 1153 2013
BDLDCA 0620 2012 --- ALBDCA 1710 2013
BDLDCA 0938 2012 --- BDADCA 1350 2013
BDLDCA 1150 2012 --- BDLDCA 0620 2013
BDLDCA 1338 2012 --- BDLDCA 0938 2013
BDLDCA 1635 2012 --- BDLDCA 1152 2013
BDLDCA 1939 2012 --- BDLDCA 1330 2013
BHMDCA 1755 2012 --- BGRDCA 1727 2013
I am trying to find a way to find the closest match of the time column in the right set of data to the corresponding time column in the first set, but only when the dirmkt is the same. For example, second from the bottom on the right set BDLDCA 1330 would return 1338 since that was the closest value in the left set of data with the SAME dirmkt. Any help would be amazing....I'm stuck. Thanks!!
Bookmarks