SAS BASE Q69. first/last

QUESTION NO: 69

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 WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments. What is the result?

 

A. The WORK.TOTAL data set contains 5 observations.

B. The WORK.TOTAL data set contains 100 observations.

C. The WORK.TOTAL data set contains 500 observations.

D. The program fails to execute due to errors.

 

 

Answer: A

# 문제 풀이

 - last.department=1인 항목만 표시한다. 각 department별로 마지막 변수만 표시되고, 5개의 변수가 있으므로 5개의 관측값이 출력된다.