PROC SQL INTERSECT

[nketata]

Hi all,

What is the proc sql equivalent of this merge  ?  I tried some proc sql intersect commands and I had some strange results. 

data Filenew;

merge file1 (in=b) file2 (in=c);

by var1;

if b and c;

run;

[PGStats · Accepted solution]

proc sql;

create table filenew as

select file1.*, file2.*

from file1 inner join file2 on file1.var1=file2.var1;

quit;

" select file1.*, file2.* " is not quite right. In a data step merge, you get the last value of any same-named variable, but in SQL you must specify which one you want.