SAS Base Certification – Question 2

Question 2: Given the SAS data set WORK.ONE:

 Id Char1
--- -----
182 M
190 N
250 O
720 P

and the SAS data set WORK.TWO:

 Id Char2
--- -----
182 Q
623 R
720 S

The following program is submitted:

1
2
3
4
data WORK.BOTH;
 merge WORK.ONE WORK.TWO;
 by Id;
run;

What is the first observation in the SAS data set WORK.BOTH?

Options:

A.	Id Char1 Char2
--- ----- -----
182 M

B.	Id Char1 Char2
--- ----- -----
182 Q

C.	Id Char1 Char2
--- ----- -----
182 M Q

D.	Id Char1 Char2
--- ----- -----
720 P S

*The SAS certification sample problem and answer above are sourced from the official SAS sample questions page. All answer logs, data sets, output, and commentary are provided by this blog.

Correct Answer

Incorrect Answer

Click to see Answer Explanation below

thanks for your support

4 Comments

    Uer Sep 25, 2016

    I agree with C. Why isnt ‘D’ also the correct answer? Please explain, Thanks

    Reply
      acrews7 Dec 28, 2016

      It completes in the order given. It asks for the first observation which would be the first observation line that is ran.

      Reply
      Hasan Apr 11, 2017

      Because 720 P S is not the first observation

      Reply
    RD Oct 24, 2016

    IT asked for by id so 182 comes first than 720

    Reply

Leave a Comment

Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let us have a personal and meaningful conversation instead.