topic Re: Hash Multiple Keys and Different Names in SAS Programming

Hash Multiple Keys and Different Names

railfan1975 — Fri, 21 Sep 2012 03:50:11 GMT

So I know that if I want to have multiple keys in a hash table I do the following:

hh.DefineKey('Key1', 'Key2');

I also know that if my key in the dataset I'm matching the hash table to has a different name for the key I do the following:

hh.find(Key: DiffName);

What I'm wondering is if you can combine the two? Can you have a multiple key lookup and the names in the dataset you are matching to be different for both keys?

Thanks!

Jonathan

Re: Hash Multiple Keys and Different Names

Ksharp — Fri, 21 Sep 2012 06:38:36 GMT

NO. But you can use Hiter object to achieve this, but it is low efficient .

Re: Hash Multiple Keys and Different Names

Haikuo — Fri, 21 Sep 2012 14:32:02 GMT

Yes, if you mean something like: hh.find(Key: DiffName1, key:diffname2); Try it out, you will see.

Haikuo