Which one of the following reports is generated?

Given the following SAS data sets ONE and TWO:

ONE TWO

NUM COUNTRY NUM CITY

1 CANADA 3 BERLIN

2 FRANCE 5 TOKYO

3 GERMANY 4 BELGIUM

5 JAPAN

The following SAS program is submitted:

proc sql;

select country

from one

where not exists

(select *

from two

where one.num = two.num);

quit;

Which one of the following reports is generated?
A . COUNTRY
GERMANY
JAPAN
B . COUNTRY
FRANCE
BELGIUM
C . COUNTRY
CANADA
FRANCE
BELGIUM
D . COUNTRY
CANADA
FRANCE
GERMANY

View Answer

Answer: C