Multiple choice technology programming languages

In order for PROC SQL to perform an inner join,

  1. the tables being joined must contain the same number of columns.

  2. the tables must be sorted before they are joined

  3. the columns that are specified in a join condition in the WHERE clause must have the same data type.

  4. the columns that are specified in a join condition in the WHERE clause must have the same name.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

For PROC SQL to perform an inner join, only the columns in the join condition must have compatible data types - they don't need matching names, and tables don't need sorting or equal column counts. Data type compatibility is the fundamental requirement for join operations.

Keep practicing — related questions