SAS_Institute
A00-212 · Question #80
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…
The correct answer is C. 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
(31 responses)- A10% (3)
- B16% (5)
- C71% (22)
- D3% (1)
Community Discussion
No community discussion yet for this question.