By admin | January 3, 2010

SAS Certified Adv Programmer 130 Questions (40)

Given the following SAS data sets ONE and TWO:

ONE 
OBS COMMON X 
1   A      10
2   A      13
3   A      14
4   B      9
5   C      8
6   C      14

TWO 
OBS COMMON Y
1   A      1
2   A      3
3   B      4
4   B      2
5   C      5

The following SAS DATA step is submitted:

data combine;
    merge one two;
    by common;
run;

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

A.

OBS COMMON X  Y 
1   A      10 1
2   A      13 3
3   A      14 3
4   B      9  4
5   B      9  2
6   C      8  5
7   C      14 5

B.

OBS COMMON X  Y
1   A      10 1
2   A      13 3
3   B      9  4
4   C      8  5

C.

OBS COMMON X  Y
1   A      10 1
2   A      13 3
3   B      14 4
4   B      9  2
5   C      8  5

D.

OBS COMMON X  Y
1   A      10 1
2   A      13 1
3   A      14 1
4   A      10 3
5   A      13 3
6   A      14 3
7   B      9  4
8   B      9  2
9   C      8  5
10  C      14 5 

2 comments | Add One

  1. admin - 01/3/2010 at 9:10 am

    A

  2. persona - 04/4/2015 at 4:38 pm

    I know the answer, but could anybody give me an explanation about the question?
    I just think it should be D

Leave a Comment

Leave a Reply

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