SAS_Institute
A00-201 · Question #80
A00-201 Question #80: Real Exam Question with Answer & Explanation
Sign in or unlock A00-201 to reveal the answer and full explanation for question #80. The question stem and answer options stay visible for context.
Question
20: The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set named WORK.SALARY contains 10 observations for each department, currently ordered by DEPARTMENT.
Which one of the following is true regarding the program above?
Options
- AThe BY statement in the DATA step causes a syntax error.
- BFIRST.DEPARTMENT and LAST.DEPARTMENT are variables in the WORK.TOTAL data set.
- CThe values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
- DThe values of the variable PAYROLL represent a total for all values of WAGERATE in the WORK.SALARY data set.
Unlock A00-201 to see the answer
You've previewed enough free A00-201 questions. Unlock A00-201 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.