Difference between revisions of "Table Lookup Techniques: From the Basics to the Innovative"

From sasCommunity
Jump to: navigation, search
m (fixed formatting)
(fixed typo)
Line 8: Line 8:
[http://www.pharmasug.org/proceedings/2014/AD/PharmaSUG-2014-AD03.pdf View the pdf here].
[http://www.pharmasug.org/proceedings/2014/AD/PharmaSUG-2014-AD03.pdf View the pdf here].
Download the data and a couple of sample programs [[File:100TableLookups.zip|here]]
Download the data and a couple of sample programs [[Media:100TableLookups.zip|here]]
== Contact Info ==
== Contact Info ==

Latest revision as of 19:11, 22 January 2018


One of the more commonly needed operations within SAS® programming is to determine the value of one variable based on the value of another. A series of techniques and tools have evolved over the years to make the matching of these values go faster, smoother, and easier. A majority of these techniques require operations such as sorting, searching, and comparing. As it turns out, these types of techniques are some of the more computationally intensive, and consequently an understanding of the operations involved and a careful selection of the specific technique can often save the user a substantial amount of computing resources.

Many of the more advanced techniques can require substantially fewer resources. It is incumbent on the user to have a broad understanding of the issues involved and a more detailed understanding of the solutions available. Even if you do not currently have a BIG data problem, you should at the very least have a basic knowledge of the kinds of techniques that are available for your use.

Online Materials

View the pdf here.

Download the data and a couple of sample programs here

Contact Info

Contact Art Carpenter with questions or comments about this paper.