32. Left and Right Joins

{\rtf1\ansi\ansicpg1252\cocoartf2577

\cocoatextscaling0\cocoaplatform0{\fonttbl\f0\fswiss\fcharset0 Helvetica;}

{\colortbl;\red255\green255\blue255;}

{\*\expandedcolortbl;;}

\margl1440\margr1440\vieww11520\viewh8400\viewkind0

\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural\partightenfactor0


\f0\fs24 \cf0 \

proc sql;\

create table joineddata as\

select A.name, A.age, A.weight, B.height\

from classweight as A left join classheight as B\

on A.name=B.name;\

quit;\

\

\

\

proc sql;\

create table joineddata as\

select A.name, A.age, A.weight, B.height\

from classweight as A right join classheight as B\

on A.name=B.name;\

quit;\

\

\

\

\

\

\

}

Complete and Continue