Hi There, Under same topic (P. 84) in book page 87 it says, "When you add the COALESCE function to the SELECT clause of the PROC SQL outer join, the PROC SQL outer join can produce the same result as a DATA step match-merge." Also, pretty much similar example is on page 88 in the book, which output also has same issue, but book claiming that it is combining rows in the same way. I just want to understand that how it is combining same way because for the duplicate value for joining column (X) has only two row in merge output and four rows in sql join output. Also, can someone suggest me how we can get same result for this particular example in merge and sql both? Exact book example from page 87 & 88 shown below: /****************************************************************/ /*DATA Step Match-Merge */ /*Below I created the table 3 and 4 unless someone don't have table access*/ data Three; input X A$ @@; cards; 1 a1 1 a2 2 b1 2 b2 4 d ;run; data Four; input X B$ @@; cards; 2 x1 2 x2 3 y 5 v ;run; /***************************************************************************/
... View more
