Which one of the following represents the data values stored in the data set TWO?

Given the following SAS data set ONE:

ONE

CATEGORY AGE SALARY BONUS

—-

M 28 200 .

M 25 100 10

F 18 100 50

F 25 200 10

The following SAS program is submitted:

proc sql;

create table two as

select category, salary + bonus as EARNINGS

from one; quit;

Which one of the following represents the data values stored in the data set TWO?
A . CATEGORY EARNINGS
M 200
M 110
F 150
F 210
B . CATEGORY EARNINGS
C . M 110
F 150
F 210
D . CATEGORY SALARY BONUS EARNINGS
M 200 . 200
M 100 10 110
F 100 50 150
F 200 10 210
E . CATEGORY SALARY BONUS EARNINGS
M 200 . .
M 100 10 110
M 200 . 200
M 100 10 110
F 100 50 150
F 200 10 210

View Answer

Answer: B