https://communities.sas.com/t5/SAS-Viya/lookups-with-many-different-keys-and-values/m-p/949076#M2655 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/31461">@mkeintz</a>&nbsp;The SAS data step with hash lookup also works in Viya for in CAS processing.&nbsp;<A href="https://communities.sas.com/t5/SAS-Communities-Library/CAS-Table-Lookup-Left-Outer-Join-on-SAS-Viya/ta-p/830405" target="_self">CAS Table Lookup (Left Outer Join) on SAS Viya</A></P> <P>As long as you don't modify the hash table once loaded (like using the add() method) there is no difference in outcome as compared to running under compute/SAS9.4</P> Fri, 25 Oct 2024 22:13:54 GMT Patrick 2024-10-25T22:13:54Z https://communities.sas.com/t5/SAS-Viya/lookups-with-many-different-keys-and-values/m-p/948729#M2652 <P>If I have many variables, I am creating rules and decisions on it and these variables must be compared with a specified values example: I have nationality must be equal EG and salary must be equal 1000 and so on how to put these keys and values in one table and check against it in sas rule sets?</P> Wed, 23 Oct 2024 13:07:41 GMT https://communities.sas.com/t5/SAS-Viya/lookups-with-many-different-keys-and-values/m-p/948729#M2652 mernamaher 2024-10-23T13:07:41Z https://communities.sas.com/t5/SAS-Viya/lookups-with-many-different-keys-and-values/m-p/949067#M2654 <P>I have no idea whether a Viya-specific solution is available.&nbsp; But if you run a SAS DATA step, you can use a hash object, with nationality and salary defined as the keys.</P> Fri, 25 Oct 2024 20:04:11 GMT https://communities.sas.com/t5/SAS-Viya/lookups-with-many-different-keys-and-values/m-p/949067#M2654 mkeintz 2024-10-25T20:04:11Z https://communities.sas.com/t5/SAS-Viya/lookups-with-many-different-keys-and-values/m-p/949076#M2655 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/31461">@mkeintz</a>&nbsp;The SAS data step with hash lookup also works in Viya for in CAS processing.&nbsp;<A href="https://communities.sas.com/t5/SAS-Communities-Library/CAS-Table-Lookup-Left-Outer-Join-on-SAS-Viya/ta-p/830405" target="_self">CAS Table Lookup (Left Outer Join) on SAS Viya</A></P> <P>As long as you don't modify the hash table once loaded (like using the add() method) there is no difference in outcome as compared to running under compute/SAS9.4</P> Fri, 25 Oct 2024 22:13:54 GMT https://communities.sas.com/t5/SAS-Viya/lookups-with-many-different-keys-and-values/m-p/949076#M2655 Patrick 2024-10-25T22:13:54Z