|
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;
| 
