Hello team,
Can someone tell me how to do joins (Left Outer Join, Inner Join) in SAS without using SQL?
Regards,
GN
Hi:
You will learn about SAS and the MERGE statement in the Programming 2 course. Are you in Programming 1 or Programming 2? The question you asked previously was in relation to the Programming 1 class. Are you working in Programming 1 in the Lesson on SQL? If so, what example are you asking about?
If you're just curious, here are some resources you might find enlightening:
https://support.sas.com/resources/papers/proceedings09/036-2009.pdf
https://support.sas.com/resources/papers/proceedings12/251-2012.pdf
https://www.lexjansen.com/nesug/nesug08/ff/ff03.pdf
Cynthia
Hi:
You will learn about SAS and the MERGE statement in the Programming 2 course. Are you in Programming 1 or Programming 2? The question you asked previously was in relation to the Programming 1 class. Are you working in Programming 1 in the Lesson on SQL? If so, what example are you asking about?
If you're just curious, here are some resources you might find enlightening:
https://support.sas.com/resources/papers/proceedings09/036-2009.pdf
https://support.sas.com/resources/papers/proceedings12/251-2012.pdf
https://www.lexjansen.com/nesug/nesug08/ff/ff03.pdf
Cynthia
Hello Cynthia,
This is a very good source. Thanks for sharing.
GN
Inner
data innerJoin;
merge table1 (in=A) table2 (in=B);
by ID:
if A & B;
run;
Outer Left Join
data outerLeft;
merge table1 (in=A) table2 (in=B);
by ID;
if A;
run;
@GN0001 wrote:
Hello team,
Can someone tell me how to do joins (Left Outer Join, Inner Join) in SAS without using SQL?
Regards,
GN
Hello Reeza,
I already have a certificate. I have not used SAS in the job market. I am refreshing my knowledge.
Regards,
Guity
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Follow along as SAS technical trainer Dominique Weatherspoon expertly answers all your questions about SAS Libraries.
Find more tutorials on the SAS Users YouTube channel.