Comparing Observations that Have Matching IDNUMs |
COMPARE Procedure Comparison of WORK.EMP95_BYIDNUM with WORK.EMP96_BYIDNUM (Method=EXACT) Data Set Summary Dataset Created Modified NVar NObs WORK.EMP95_BYIDNUM 13MAY98:16:03:36 13MAY98:16:03:36 4 10 WORK.EMP96_BYIDNUM 13MAY98:16:03:36 13MAY98:16:03:36 4 12 Variables Summary Number of Variables in Common: 4. Number of ID Variables: 1. |
Observation Summary Observation Base Compare ID First Obs 1 1 idnum=0987 First Unequal 1 1 idnum=0987 Last Unequal 10 12 idnum=9857 Last Obs 10 12 idnum=9857 Number of Observations in Common: 10. Number of Observations in WORK.EMP96_BYIDNUM but not in WORK.EMP95_BYIDNUM: 2. Total Number of Observations Read from WORK.EMP95_BYIDNUM: 10. Total Number of Observations Read from WORK.EMP96_BYIDNUM: 12. Number of Observations with Some Compared Variables Unequal: 5. Number of Observations with All Compared Variables Equal: 5. |
COMPARE Procedure Comparison of WORK.EMP95_BYIDNUM with WORK.EMP96_BYIDNUM (Method=EXACT) Values Comparison Summary Number of Variables Compared with All Observations Equal: 1. Number of Variables Compared with Some Observations Unequal: 2. Total Number of Values which Compare Unequal: 8. Maximum Difference: 2400. Variables with Unequal Values Variable Type Len Ndif MaxDif address CHAR 42 4 salary NUM 8 4 2400 |
Value Comparison Results for Variables _______________________________________________________ || Base Value Compare Value idnum || address address _____ || ___________________+ ___________________+ || 0987 || 2344 Persimmons Bran 2344 Persimmons Bran 2776 || 12988 Wellington Far 12988 Wellington Far 3888 || 5662 Magnolia Blvd S 5662 Magnolia Blvd S 9857 || 1000 Taft Ave. Morri 100 Taft Ave. Morris _______________________________________________________ |
COMPARE Procedure Comparison of WORK.EMP95_BYIDNUM with WORK.EMP96_BYIDNUM (Method=EXACT) Value Comparison Results for Variables _______________________________________________________ || Base Compare idnum || salary salary Diff. % Diff _____ || _________ _________ _________ _________ || 0987 || 44010 45110 1100 2.4994 3286 || 87734 89834 2100 2.3936 3888 || 77558 79958 2400 3.0945 9857 || 38756 40456 1700 4.3864 _______________________________________________________ |