comparing two times to find the nearest minute for a specific time

we have two tabels A and B each of which have column representing the date and time in the format "uuuuMMddHHmm", we would like to check if there are any matching dates between the two tables, the year, month, day and hour should completley match whereas for the minutes, since it is hard to compare for the same minute we would like to check for the nearest minute that we can find for that specific time of day. After we find the matching dates we would like to copy the corresponding value of the variable fof2 from table B to table A.

I was able to do the first comparison, but I am not sure how to find the nearset minute to a specific time, if anyone can help.

Thank you in adavnce.

Answer 1

[KSSV]

Read about ismember, ismembertol, knnsearch