SAS Tips and Tricks

Use hash object to validate data

SAS hash objects are super fast in-memory technic allowing you to perform join operation, lookup, data check (etc.) this technic can be used on datasets but also when flat files are read allowing you to do data validation during the load phase of your data.

Details

In this tips and tricks, we will first talk about SAS in-memory technics: arrays, formats and hash object will be briefly described in terms of their utilization. Then we 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?
  • How can we call a Hash Object?

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 validate your data against reference table using Hash Object.

Quick Facts

  • Scheduled date: 2019-12-19 from 2 pm to 5 pm
  • 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