Multiple choice technology programming languages

Which statement is false with respect to a set operation that uses the EXCEPT, UNION, or INTERSECT set operator without a keyword?

  1. Column names in the result set are determined by the first table.

  2. To be overlaid, columns must be of the same data type.

  3. To be overlaid, columns must have the same name.

  4. By default, only unique rows are displayed in the result set.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SAS SQL set operations (UNION, INTERSECT, EXCEPT) without keywords like ALL or CORR, columns are matched by position (ordinal) not by name. The columns must have compatible data types but need not have the same name. Column names in the result come from the first table. Therefore, the statement that 'To be overlaid, columns must have the same name' is FALSE, making option C the correct answer.

Keep practicing — related questions