topic Re: PROC SQL INTERSECT in SAS Procedures

PROC SQL INTERSECT

nketata — Mon, 04 Jul 2016 18:00:58 GMT

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;

Re: PROC SQL INTERSECT

PGStats — Mon, 04 Jul 2016 18:59:12 GMT

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.