On-Demand Webinar

Lookup Techniques

Comparison of methods for linking information.


About the webinar

There are multiple methods available in SAS for linking related information, stored in different tables. Each has different advantages and constraints. The best option will depend on factors like the size of the tables, the number of items to be retrieved and the complexity of the join.

What you'll learn:

Multiple methods for performing lookups and some guidance on when to use each one.

  • Data step If..then..else logic
  • Data step SELECT block
  • SQL CASE statement
  • Data step merge
  • Data step KEY= indexed join
  • SQL join
  • SAS Formats
  • Arrays
  • Hash tables

Have a SAS profile? To complete this form automatically Sign In


All personal information will be handled in accordance with the SAS Privacy Statement.

  Yes, I would like to receive occasional emails from SAS Institute Inc. and its affiliates about SAS products and services. I understand that I can withdraw my consent at any time by clicking the opt-out link in the emails.

About the Experts

Peter Hobart
SAS customer success team

Peter has worked at SAS for 24 years, in customer support, education, architecture and now customer success. Prior to joining SAS Peter was the IT manager for a major brewery's research laboratory.. Peter has written several SAS courses and questions for the SAS certification exams.

Peter has presented at SAS forum but spends most of his time answering customer questions and presenting at customer events. Peter is a certified SAS advanced programmer, data integration developer and SAS platform administrator.

He is currently learning the new features of SAS Viya 3.5.