SAS Training

SAS Certified Adv Programmer 130 Questions (32)

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
M        .
M        110
F        150
F        210

C.

CATEGORY SALARY BONUS EARNINGS
M        200    .     200
M        100    10    110
F        100    50    150
F        200    10    210

D.

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 

2 comments | Add One

Leave a Comment