By admin | December 16, 2009

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

  1. admin - 12/16/2009 at 10:13 am

    B

  2. Consty - 02/20/2013 at 11:46 pm

    B: because of the missing value in the first observation.

Leave a Comment

Leave a Reply

Your email address will not be published. Required fields are marked *