*SQL LEFT OUTER JOIN;

proc sql;

create table left_outer_join as

select *

from movies(keep=title length rating)

left join actors(keep=title actor_leading)

on movies.title=actors.title;

select * from left_outer_join;

quit;

*QUESTION 1:

*Write the steps to create the "right" version of the merge and join above;

*Keep the order of movies and actors the same;

*QUESTION 2:

*Create a left join of movies and actors as above reversing the order of the

tables around the left join keyword;

*QUESTION 3: Compare and contrast the results of question 1 and 2;