The differences for character variables are noted with an X or a period (.). An X shows that the characters do not match. A period shows that the characters do match. For numeric variables, an E means that there is no difference. Otherwise, the numeric difference is shown. By default, the output data set shows that two observations in the comparison data set have no matching observation in the base data set. You do not have to use an option to make those observations appear in the output data set.
The Output Data Set RESULT 1
idnum _TYPE_ _OBS_ name address salary
0987 BASE 1 Dolly Lunford 2344 Persimmons Branch Apex NC 27505 44010
COMPARE 1 Dolly Lunford 2344 Persimmons Branch Trail Apex NC 27505 45110
DIF 1 ............... .......................XXXXX.XXXXXXXXXXXXX 1100
2776 BASE 5 Robert Jones 12988 Wellington Farms Ave. Cary NC 27512 29025
COMPARE 5 Robert Jones 12988 Wellington Farms Ave. Cary NC 27511 29025
DIF 5 ............... ........................................X. E
3278 COMPARE 6 Mary Cravens 211 N. Cypress St. Cary NC 27512 35362
3286 BASE 6 Hoa Nguyen 2818 Long St. Cary NC 27513 87734
COMPARE 7 Hoa Nguyen 2818 Long St. Cary NC 27513 89834
DIF 6 ............... .......................................... 2100
3888 BASE 7 Kim Siu 5662 Magnolia Blvd Southeast Cary NC 27513 77558
COMPARE 8 Kim Siu 5662 Magnolia Blvd Southwest Cary NC 27513 79958
DIF 7 ............... ........................XX................ 2400
6544 COMPARE 9 Roger Monday 3004 Crepe Myrtle Court Raleigh NC 27604 47007
9857 BASE 10 Kathy Krupski 1000 Taft Ave. Morrisville NC 27508 38756
COMPARE 12 Kathy Krupski 100 Taft Ave. Morrisville NC 27508 40456
DIF 10 ............... ...XXXXXXXXXXXXXX.XXXXX.XXXXXXXXXXX....... 1700
|