Question

In this PROC SQL step, which clause or clauses are written incorrectly?

proc sql;
select Employee_ID
Name
Dependents
from orion.employees
where Salary < 50000;
quit;
a. FROM
b. WHERE
c. SELECT

Answer 1

The incorrect clause in the given PROC SQL step is the SELECT clause due to the missing comma between 'Employee_ID' and 'Name'. The corrected query should have a comma separating these columns.

Step-by-step explanation:

The incorrect clause in the PROC SQL step you provided is the SELECT clause. When specifying multiple columns to be selected from a database, each column should be separated by a comma. However, in the SQL query you've written, there is a missing comma between Employee_ID and Name.

The corrected SELECT clause should read SELECT Employee_ID, Name, Dependents. The FROM and WHERE clauses are written correctly provided that 'orion.employees' is the correct path to the data set and 'Salary' is a valid column within that data set. The complete corrected SQL statement would be SELECT Employee_ID, Name, Dependents FROM orion.employees WHERE Salary < 50000;.