Big Data Module 2 PROC IMSTAT - schemas - left and right joins

[odesh]

Hello,

Please see the attached.

I chose option "c" also because schema joins support "left joins on a single key only".

There was no mention of right join in the previous slide and so I assumed that right joins would be different.

Would it be clearer to say that left  AND RIGHT joins can be done using a single key only ?

Regards.

Odesh.

[Cynthia_sas]

Hi:
The instructors commented that there are a few lectures you should revisit to see why C was not correct. They said "The answer on your screen capture is taken directly from the lecture. The SCHEMA statement only supports a star schema for joins. If there are only two tables, it basically behaves just like a “left join.” You cannot specify “left” or “right” on the SCHEMA statement. The question and the answer are both correct and match up to the lectures and the documentation." Here are the lectures they suggest you revisit:

Hope this helps,
Cynthia