SAS Tips and Tricks

Create and use hash objects in SAS

The SAS hash object is meant to enable you to quickly and efficiently store, search, and retrieve data based on lookup keys , Conceptually, the hash object provides programmers the means to easily define and utilize a hash table within the Data Step.

Details

SAS developed different in-memory technics to perform lookup. In this tips and tricks, we will will dive into Hash Object:

  • What is a Hash Object?
  • What is the syntax of an Hash Object?
  • How can we load values in the Hash Object? (manually or from dataset)
  • How can we deal with duplicates ?
  • How can we add more keys to improve unicity?
  • How can we combine different hash objects in a single datastep

In a second step, we will apply the syntax of the hash object during the read phase of a CSV. The idea behind will be to validate the data (compared to a reference table loaded in memory) and to output records to an error table if they don't meet acceptance criteria.

Prerequisites

You have some SAS experience and would like to create and use hash objects in order to speed up your lookup.

Quick Facts

  • Scheduled date: Session not yet scheduled.
  • Duration :3 Hours
  • Fee :240 Euros (VAT Exclusive)
  • Language: French/English
  • Included: Coffees, tips and tricks material

Christophe Kabacinski

click here to get more information about this teacher.

Course Location

This course will be organized at : Lodge.co Boulevard Simon Bolivar 34 1000 Bruxelles


Go back to your selection


This site uses cookies. .

By continuing to browse the site you are agreeing to our use of cookies. Review our cookies information for more details.