SAS Certified Adv Programmer 50 Questions (5)
Given the following SAS data sets One and Two:
One
| Num | Var1 |
| 1 | A |
| 1 | A |
| 2 | B |
| 3 | C |
Two
| Num | Var2 |
| 1 | A |
| 4 | Y |
| 4 | Z |
The following SAS program is submitted:
proc sql;
select *
from one
intersect all
select *
from two;
quit;
Which of the following reports is generated?
a.
| Num |
| 1 |
b.
| Num |
| 1 |
| 2 |
c.
| Num | Var1 |
| 1 | A |
d.
| Num | Var1 |
| 1 | A |
| 1 | A |
Topics:
SAS Adv Questions |
3 Comments »
C
D. the ALL includes unique and non unique rows
Isn’t it d, because the ‘intersect ALL’
does not drop duplicates?