sas merge on multiple columns and rename multiple columns

nnnwf — Thu, 30 Aug 2018 22:40:05 GMT

proc sql;
     select * 
     from may_nomatch_2 a
     inner join march2018_3_9char b on a.Loan_9 = b.LOAN and a.PropZIP = b.Property_Zip;
quit;

data;
     merge may_nomatch_2(rename=(Loan_9=LOAN PropZIP=Property_Zip)) march2018_3_9char;
     by Loan_9 PropZIP;
run;

I have above code. proc sql shows how I would do the join using sql. But I want to perform the join using merge and not sure how to do it

it is an inner join using 2 columns

those 2 columns don't have same name in both tables

Re: sas merge on multiple columns and rename multiple columns

Reeza — Thu, 30 Aug 2018 22:58:27 GMT

Try adding the IN option to both on the data set statement and then filtering on that to control for an inner join.

data;
     merge may_nomatch_2(IN=T1 rename=(Loan_9=LOAN PropZIP=Property_Zip)) 
                march2018_3_9char (IN=T2);
     by Loan_9 PropZIP;

If T1 and T2; *inner join;

run;

topic sas merge on multiple columns and rename multiple columns in SAS Programming

sas merge on multiple columns and rename multiple columns

Re: sas merge on multiple columns and rename multiple columns