Advance SAS Cert Practice exam from SAS Institute (Q-32)

Saszealot — Tue, 20 Oct 2009 02:51:10 GMT

With reference to the above topic,I need some help beginning from the highlighted lines below. This is the explanation SAS gave to question 32. I 'm not in agreement with their explanation.
Thanks.
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

Two
Obs Common Y
1 A 1
2 A 3
3 B 4
4 B 2

The following SAS program is submitted:
data combine;
merge one two;
by common;
run;

What data values are stored in the data set Combine?

The MERGE statement in the DATA step processes data sequentially. The first observation of data set One is combined with the first observation of data set Two because the variable Common has a value of A in both data sets.
The second observation of the data set One is combined with the second observation of the data set Two because the variable Common has a value of A in both data sets. Because there is an additional observation in the data set Two where the variable Common has a value of A, the program data vector is not reinitialized; the value of X is retained from observation two, and the values of Common and Y are read from the data set Two. Thus, there are three observations in the data set Combine where the variable Common has a value of A.
The third observation of the data set One is combined with the fourth observation of the data set Two because the variable Common has a value of B in both data sets.
Finally, the fourth observation of the data set One is combined with the last observation of the data set Two because the variable Common has a value of B in both data sets. Thus, there are two observations in the data set Combine where the variable Common has a value of B.

Re: Advance SAS Cert Practice exam from SAS Institute (Q-32)

LinusH — Tue, 20 Oct 2009 07:27:59 GMT

I take it that the bold sentence is bothering you.
This is probably a typo, I think it should read "..in the data set One...".

/Linus

Re: Advance SAS Cert Practice exam from SAS Institute (Q-32)

Flip — Tue, 20 Oct 2009 13:35:00 GMT

Clearly the paragraph does not match the data.

topic Re: Advance SAS Cert Practice exam from SAS Institute (Q-32) in SAS Health and Life Sciences

Advance SAS Cert Practice exam from SAS Institute (Q-32)

Re: Advance SAS Cert Practice exam from SAS Institute (Q-32)

Re: Advance SAS Cert Practice exam from SAS Institute (Q-32)