And Xai Kashun, Thanks to both of your for your great assistance. This is my first attempt at using hashing in SAS and it has been great to learn something new. I was not aware of the Mulitdata option in the Declare statement. I agree with Xai Kashun that this is a more elegant solution to the problem and, in my tests, worked very well! But, as Kaikou pointed out, the data may be too large. Once I had a running program with a subset of data, I ran one last night with the full file. I did not get even half of the 'Many' file into the hash table before I ran out of memory. I can control how large the 'One' file is, so I will have to continue using the 'One' table for the hash. Thank you both for the great information that you gave me. Kind Regards, Wayne
... View more
