Cannot merge two excel files

[ayushupadhyay22]

I have two files that I am trying to merge using the variable Address. I am trying to do this in University Edition but the log shows that the merging is not possible by address. Below is my code and screenshot of the log

libname orion "/folders/myfolders/project";
proc sort data= orion.fullerton_edited out=orion.fullerton_edited1;
by Address;
proc sort data= orion.agent1line out=orion.agent1line1;
by Address;
merge orion.fullerton_edited1 orion.agent1line1;
by Address;
run;

[collinelliot · Accepted solution]

libname orion "/folders/myfolders/project";
proc sort data= orion.fullerton_edited out=orion.fullerton_edited1;
by Address;
proc sort data= orion.agent1line out=orion.agent1line1;
by Address;

data WANT; <------- You're missing this 
merge orion.fullerton_edited1 orion.agent1line1;
by Address;
run;