Join Now

SAS User Forum 2017: Lookup methods in SAS®: Two hidden methods

by SAS Employee DorteBrix on ‎06-13-2017 09:57 AM - last edited on ‎06-19-2017 02:56 AM by SAS Employee GeorgMorsing (153 Views)

Presentation number 76 by Georg Morsing, SAS Institute

Copenhagen, 15 June 2017

 

Abstract

With SAS programming, we have many lookup methods. A lookup method is when we want to use a key value to look into a master table and retrieve a value. An example is using a CRS-number to fetch a person’s address.
In this presentation, we will give you an overview of all the possible methods for doing this in the DATA Step and then focus on two of the methods that SAS programmers do not use very often. 

 

Click on the download symbol to the right of the PDF filename to download the PDF file.

 

SAS programs attached below.