Administrative Information Services

Data Administration
 

VISION:Results Workshop #12 Outline

MATCHING MULTIPLE FILES IN VISION:Results

I. The File Matching Process

A. Matching and Key fields
B. Sort Order
C. Determining File Order (Primary, Secondary, Tertiary, etc)
D. Multiple occurrences of key field in Secondary, Tertiary file, etc.
E. Possible conditions

1. Two-File Match conditions
2. Multiple File Match conditions

F. Sorting the Input File
G. Matching Multiple Files Using Files with Different Keys
H. Match Templates

1. Two-File Match

a. Basic Match Logic
b. List all Primary, whether or not there is a match
c. List 1st hit, based on single Primary, multiple Secondary
d. PICNSAVE all Primary, all Secondary that do not match

2. Multiple File Match

a. Basic Match Logic
b. Using Different Keys

3. Elimination of Duplicate Records

II. Workshop Exercise

Michigan State University Copyright 1998.  All rights reserved.    This page last updated on 06/02/02 10:55 PM.

  If you have comments or suggestions about this webpage Email us.    (Please do not change the subject line)