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

odesh — Wed, 11 Sep 2019 12:19:45 GMT

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.

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

Cynthia_sas — Sat, 14 Sep 2019 14:41:35 GMT

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

topic Re: Big Data Module 2 PROC IMSTAT - schemas - left and right joins in SAS Academy for Data Science

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

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