SAS_Institute
A00-202 · Question #77
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…
The correct answer is D. COUNTRY. See the full explanation below for the reasoning.
Question
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?
Options
- ACOUNTRY
- BCOUNTRY
- CCOUNTRY
- DCOUNTRY
How the community answered
(27 responses)- A4% (1)
- B11% (3)
- C4% (1)
- D81% (22)
Community Discussion
No community discussion yet for this question.