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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.