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

Answer: C

Latest A00-212 Dumps Valid Version with 184 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments