I have two tables (a and b) where both tables have column "time" and the tables has different number of rows (b has more rows than a) However, a.time and b.time are not the same and I hope to merge the two tables to a, using time as constraint. I want data from b only be merge to a, where b.time is the closest time to a.time, but less than a.time. Thinking how to use proc sql for the data.... my previous attempts reported an error for insufficient memory... Many Thanks
... View more