SAS : Join on Multiple Columns

Suppose you need to join two data sets (tables) based on multiple variables (columns) in SAS.

Step I : Creating two data sets (tables)
data def;
input a b $ d;
cards;
123 X 5
441 D 2
;
run;

data abc;
input a b $ c;
cards;
123 A 5
123 B 6
123 X 8
441 C 2
441 D 5
;
run;
Task : Suppose you need to join these two data sets (tables) based on variables a and b.

Step II : SQL Joins / Data Step Merge Statements
proc sql noprint;
create table xyz as
select * from
def x left join abc y
on x.a = y.a and x.b = y.b;
quit;
data xyz1;
merge def(in=x) abc(in=Y);
by a b;
if x;
run;
Output

Proc SQL Tutorials : 15 Proc SQL Tutorials


SAS Tutorials : 100 Free SAS Tutorials

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like banking, Telecom, HR and Health Insurance.

While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*
Related Posts:
1 Response to "SAS : Join on Multiple Columns"

Next → ← Prev