backnextLearning Path
   


Introduction

Sometimes you need to combine data from two or more sets into a single observation in a new data set according to the values of a common variable. When the data sources are two or more data sets that have a common structure, you can use a match-merge to combine the data sets. However, in some cases the data sources do not share a common structure. When data sources do not have a common structure, you can use a lookup table to match them. A lookup table is a table that contains key values.


A Merge Using a Lookup Table


The technique that you use to perform a table lookup is dependent on your data. This lesson focuses on using multidimensional arrays to perform table lookups and transposing SAS data sets in preparation for a match-merge.

 

Time to Complete

This lesson contains pages and takes approximately 1.5 hours to complete.


Objectives

In this lesson, you learn to

  • use a multidimensional array to match data
  • use stored array values to match data
  • use PROC TRANSPOSE to transpose a SAS data set and prepare it for a table lookup
  • merge a transposed SAS data set.

Prerequisites

Before taking this lesson, you should complete the following lessons:

  • .

  Copyright © 2003 SAS Institute Inc., Cary, NC, USA. All rights reserved.
Terms of Use & Legal Information | Privacy Statement
backnext