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;
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;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.