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 |