merge

[pchen002]

How many observations are in data set WORK.ALL after submitting the program?

Why is the answer 2 and not 3? I thought the only observation omitted is the empid=1864 and empid=3567? Please help, thanks!!!!

[Kurt_Bremser]

Look again. 5463 is also present in both datasets. Only 1864 (Jill) and 3567 (Finance) appear in only one dataset.

[Astounding · Accepted solution]

I think you're looking at this as if the program read:

if Emp_D and Emp_N;

That statement would select the matches (and there are 3 of those).  However, the IF statement is different.  It is designed to select the mismatches (and there are 2 of those).

[pchen002]

Great!thanks!!