Exam A00-211 All QuestionsBrowse all questions from this exam
Question 29

Given the SAS data set WORK.ONE:

And the SAS data set WORK.TWO:

The following program is submitted:

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

    Correct Answer: A

    When the `SET` statement is used with the `BY` statement in the provided SAS program, it interleaves the two data sets (WORK.ONE and WORK.TWO) based on the common variable 'Id'. However, it's important to note that this is not a merge operation, so variables from the two data sets are not combined. Instead, the rows are ordered by 'Id' and taken as they appear in each data set sequentially. Here, the first row from WORK.ONE has 'Id' as 111 and 'Char1' as A, and this should be the first observation in the interleaved data set WORK.BOTH, making the correct answer option A.

Discussion
KleinstoneOption: A

the answer should be A. this is not a merge.

DEAWSOption: A

Correct Answer is :A

Mandar77Option: A

data one; infile datalines; input id char1; datalines; 111 10 158 20 329 30 644 40 ; ANSWER is A.. it gives 111 10 as a first row

mhminkovOption: A

yes, A, .. this is interleaving