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
Content-Type: TEXT/PLAIN; charset=US-ASCII
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 : firstname.lastname@example.org
Tel Hashomer Israel 52621