Date:         Mon, 23 Feb 2009 02:11:01 -0500
Reply-To:     Annie Lee <hummingbird10111@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Annie Lee <hummingbird10111@HOTMAIL.COM>
Subject:      merging three files with three key variables

I would like to merge three data files (mydata1, mydata2, mydata3) with
three common key variables (id, ADM DIS) using proc sql.
I would appreciate it if anyone would offer some help.

Data:

DATA mydata1;
INFILE "C:\mydata1.txt" LRECL=30  missover;
length grp $11.;
INPUT ID $ ab $ cd $ ef $ ADM $ DIS $ gh $ ij kl $ mn ;
run;

DATA mydata2;
INFILE "C:\mydata2.txt" LRECL=30  missover;
INPUT ID $ aaa   bbb  ccc  ddd  eee ADM $ DIS $;
run;

DATA mydata3;
INFILE "C:\mydata3.txt" LRECL=30  missover;
INPUT ID $ abc def  ADM $ DIS $;
run;