Example 8.14 Comparing the Value of a Variable to Its Value in the Next Observation
Goal
Within the same data set, look ahead from a variable value in one observation to return the value of the same variable in the observation that immediately follows it. Then compare the returned value with the current observation or use it in a calculation on the current observation.
This example uses the same input data set as Example 8.13.
Example Features
Featured Step | DATA step |
Featured Step Options and Statements | MERGE statement, FIRSTOBS= data set option |
Input Data Set
Data set PRODUCTION records the number of units of an item made on several days at four plant locations.
PRODUCTION units_ Obs plant proddate made 1 Aux Plant 03/02/2009 76 2 Main Plant ...
Get Combining and Modifying SAS® Data Sets: Examples Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.