Hi. I have 2 datasets, one is quite large with more than 20mil rows. I am trying to join the two datasets using proc sql. This is my query, but it takes a really long time. " Select [columns] From Table2 left join Table1 on Table2.Number between Table1.bottom_range and Table1.top_range" Is there a more efficient solution to doing this? I have checked and the format of the fields in the join are all numeric. Table1: has 3 columns , a bottom_range, top_range and a description. For example, the bottom_range might have values 10000, 20000 etc. The top_range might have values 19999, 29999 etc. Table 2 has multiple columns, one of which, as an example, is called Number, with values such as 17999, 21887 etc. ) this table has 20 million+ observations. ... View more