Date:         Fri, 21 Feb 1997 14:07:22 +0200
Reply-To:     Dvora Zomer <epid04@POST.TAU.AC.IL>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Dvora Zomer <epid04@POST.TAU.AC.IL>
Subject:      SQL problem
Comments: To: Ian Whitlock <whitloi1@WESTATPO.WESTAT.COM>
In-Reply-To:  <9701018548.AA854840563@westatpo.westat.com>
Content-Type: TEXT/PLAIN; charset=US-ASCII

SAS-L folks:
 
I have a problem that is easy to solve with other SAS tools, but I am
interested if there is a simple SQL solution.
 
I want to join two tables using a common variable NUM. The problem is that
in the second table some NUM values are absent and thus the total number
of rows in the table is less than in another. But I want to keep all rows
(with missing values for the variables from the second table).
 
Thanks for help.
 
Ilya Novikov Ph.D.
Senior Statistician                            fax  :  972-3-5348360
Dept. of Clinical Epidemiology                 voice:  972-3-5303256
The Chaim Sheba Medical Center                 mail :  epid04@post.tau.ac.il
Tel Hashomer Israel 52621