Given the SAS data sets EMPLOYEE and NEWEMPLOYEE:

EMPLOYEE NEWEMPLOYEE NAME DEPT NAME SALARY ------- -------- --------- ---------- Alan Sales Michelle 50000 Michelle Sales Paresh 60000 A SAS program is submitted and the following is written to the SAS log:

530 proc sql; 531 select dept, name 532 from employee 533 where name = (select name from newemployee where salary > 40000); ERROR: Subquery evaluated to more than one row. 534 quit; What would allow the program to successfully execute without errors?

Question

Given the SAS data sets EMPLOYEE and NEWEMPLOYEE:

EMPLOYEE NEWEMPLOYEE NAME DEPT NAME SALARY ------- -------- --------- ---------- Alan Sales Michelle 50000 Michelle Sales Paresh 60000 A SAS program is submitted and the following is written to the SAS log:

530 proc sql; 531 select dept, name 532 from employee 533 where name = (select name from newemployee where salary > 40000); ERROR: Subquery evaluated to more than one row. 534 quit; What would allow the program to successfully execute without errors?

Accepted Answer

A. Change the equal sign to IN.

Answer

B. Qualify the column names with the table names.

Answer

C. Add an observation with a name of Paresh to the EMPLOYEE data set.

Answer

D. Replace line 533 with where employee.name = (select name from newemployee where

Given the SAS data sets EMPLOYEE and NEWEMPLOYEE: EMPLOYEE NEWEMPLOYEE NAME DEPT NAME SALARY ------- -------- --------- ---------- Alan Sales Michelle 50000 Michelle Sales Paresh 60000 A SAS program…

Question

Options

How the community answered

Community Discussion