- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.