Date:         Sat, 7 Mar 1998 08:32:23 GMT
Reply-To:     Andreas Grueninger <grueni@STUTTGART.NETSURF.DE>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Andreas Grueninger <grueni@STUTTGART.NETSURF.DE>
Organization: LF.net GmbH, Internet Services, Stuttgart, Germany
Subject:      Re: Multiple joins

DATA tmp;
   MERGE alumns (IN=in1) alumcur (IN=in2 RENAME=(rcalumn=calumn
rccourse=ccourse));
   BY calumn;
   IF (in1 & in2);
RUN;
 
PROC SORT DATA=tmp; BY ccourse; RUN;
 
DATA tmp (KEEP=nalumn ncourse);
   MERGE tmp (IN=in1) courses (IN=in2);
   BY ccourse;
   IF (in1 & in2);
RUN;
 
Greetings from germany.
I would prefer the sql procedure in this case.
 
On Thu, 05 Mar 1998 14:43:18 +0000, Agustmn Alvarez <alvarea@cinsa.es>
wrote:
 
 
---------------------------
Andreas Grueninger
 
PRIVAT: grueni@stuttgart.netsurf.de
OFFICIAL: grueninger@lfl.bwl.de
---------------------------