Date:         Mon, 23 Feb 2009 06:54:59 -0500
Reply-To:     Marianne Weires <m.weires@DKFZ.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Marianne Weires <m.weires@DKFZ.DE>
Subject:      Re: merging three files with three key variables
Comments: To: Haigang Zhou <haigang.zhou@GMAIL.COM>

Hi Annie,

In order to safe some typing and assuming the same columns' name, use a
natural inner join. With the FEEDBACK procedure option you should see the
transformed output in the LOG window (the implicitly coded join criteria).

PROC SQL FEEDBACK;
    CREATE TABLE MERGED AS
 SELECT * FROM mydata1 NATURAL INNER JOIN mydata2 NATURAL INNER JOIN mydata3;
QUIT;


Regards,
Marianne