In many occasions, fast access into a lookup table to find desired value is necessary. In computer science, linked list, associative array, and hash table are widely used to construct the relationship between values and keys. Hash function, like value...
Read more »
Introduction: Merging two or multiple datasets is essential for many ‘data people’. Yes, it is a dirty and routine job. Everyone wants to get it done quick and accurate. Actually, SAS has many ways to tackle this job. In two competing papers fro...
Read more »
One guy asked in a SAS forum about a typical table look up problem:
He has a data with two IDs:
id1 id2
a b
a e
b c
b e
c e
d e
and he wants to generate a new data set with the following structure according to above...
Read more »
In most table lookup tasks, we are doing EXACT matching. However, sometimes we are looking for closest match in the lookup table. By 'closest', we mean smallest Eucleadian distance:
||X-Y||2
Typically we have to manually code the search function ...
Read more »
first step, build encoding tables based on the documentation: data encSimple encEnhanced; s='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.'; format raw 8. enc $8.; raw=.; enc='_'; output encSimple; enc='__'; output encEnhanced;...
Read more »
first step, build encoding tables based on the documentation: data encSimple encEnhanced; s='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.'; format raw 8. enc $8.; raw=.; enc='_'; output encSimple; enc='__'; output encEnhanced;...
Read more »