SAS Certified Adv Programmer 50 Questions (6)
Given the following SAS data sets One and Two:
One
| Num | Product |
| 1 | Computer |
| 2 | Printer |
| 3 | Monitor |
| 4 | Keyboard |
| 5 | Modem |
Two
| Num | Product |
| 1 | Portable |
| 5 | External |
The following SAS program is submitted:
proc sql;
select product
from one
where exists
(select *
from two
where one.num=two.num);
Which of the following reports is generated?
a.
| Product |
| Computer |
| Modem |
b.
| Product |
| Computer |
| Printer |
c.
| Product |
| Printer |
| Monitor |
| Keyboard |
d.
| Product |
| Computer |
| Printer |
| Monitor |
| Keyboard |
| Modem |
Topics:
SAS Adv Questions |
1 Comment »
A