Example 8.3 Separating Completely Duplicate Observations from Unique Observations
Identify observations that are a complete copy of another observation. Write the unique observations to one data set and write the duplicate observations to another data set.
|Featured Step||PROC SORT|
|Featured Step Options and Statements||DUPOUT=, NODUPRECS, and OUT= options|
|Related Technique||DATA step, BY statement and LAG function|
Input Data Set
Data set PMTEMPS records the hourly afternoon weather data for three locations. Note that the 17:00 Rooftop measurement is recorded identically three times. The 18:00 Rooftop, 16:00 Beach, and 16:00 Downtown measurements are recorded twice. The 14:00 and 15:00 Downtown measurements are identical except ...