I hope to achieve something below in SAS.  The syntax is based on MySQL I believe: SELECT name FROM id_name WHERE number BETWEEN number_start AND number_end LIMIT 1 The things is that the number_start and number_end are big.  And there are millions of entries in the database.  So without the lim…