Cannot merge two excel files

ayushupadhyay22 — Thu, 23 Feb 2017 23:10:22 GMT

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;

Re: Cannot merge two excel files

collinelliot — Thu, 23 Feb 2017 23:11:44 GMT

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;

topic Cannot merge two excel files in SAS Programming

Cannot merge two excel files

Re: Cannot merge two excel files