SAS Training

SAS Certified Adv Programmer 130 Questions (9)

Given the following SAS data sets ONE and TWO:

ONE 
NUM COUNTRY 
1   CANADA 
2   FRANCE 
3   GERMANY
4   BELGIUM
5   JAPAN

TWO
NUM CITY
3   BERLIN
5   TOKYO

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

One comment | Add One

Leave a Comment