SAS_Institute
A00-212 · Question #155
A00-212 Question #155: Real Exam Question with Answer & Explanation
Sign in or unlock A00-212 to reveal the answer and full explanation for question #155. The question stem and answer options stay visible for context.
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?
Options
- AChange the equal sign to IN.
- BQualify the column names with the table names.
- CAdd an observation with a name of Paresh to the EMPLOYEE data set.
- DReplace line 533 with where employee.name = (select name from newemployee where
Unlock A00-212 to see the answer
You've previewed enough free A00-212 questions. Unlock A00-212 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.