Example 4.6 Performing a "Chained" Lookup
Trace the links that associate observations in one data set. Assume there are no breaks in the chain.
|Featured Step||DATA step|
|Featured Step Options and Statements||Hash object in the DATA step|
|Related Technique||DATA step, BY-group processing, RETAIN statement|
Input Data Set
Data set FLEET_REGISTRATION contains registration transactions for three vehicles. Variable VEHICLE_ID uniquely identifies the vehicle. The values for REGISTRATION change when the vehicle is transferred. When ACTION= "XFER", the vehicle has been transferred and its new registration ID is stored in variable NEW_REG. There are no breaks in the links between observations for a vehicle because all values of NEW_REG ...