Hello, i need help to merge below table
have1
var1 var2 var3_a
1234567891 15721572 au
1234567891 26702670 io
have2
var1 var2 var3_b
1234567891 15721572 au
1234567891 26702670 io
1234567891 11301130 io
merge by var1 var2
want
1234567891 15721572 au
1234567891 26702670 io
1234567891 11301130 io
Thanks............
Given both tables are sorted by var1-var3,
data want;
set have1 have2;
by var1 var2 var3;
run;
Haikuo
proc sql;
select a.* from have2 a
left join have1 b
on a.var1=b.var1
and a.var2=b.var2;
quit;
May I ask what is the difference between "have2" and "want"?
sorry Hai.Kuo - so in some cases i have below situation;
var1 var2 var3_a
1234567891 15721572 au
1234567891 26702670 zz
have2
var1 var2 var3_b
1234567891 15721572 au
1234567891 26702670 io
1234567891 11301130 do
merge by var1 var2
want
var1 var2 var3_a
1234567891 15721572 au
1234567891 26702670 zz
1234567891 26702670 io
1234567891 11301130 do
thanks.......
Given both tables are sorted by var1-var3,
data want;
set have1 have2;
by var1 var2 var3;
run;
Haikuo
Does not look like you want to MERGE the tables as that would imply that you wanted to combine records from different tables based on matching key variables. Looks more like you want to UNION the two tables.
proc sql ;
create table want as
select var1,var2,var3_a as var3 from have1
union
select var1,var2,var3_b as var3 from have2
;
Thanks Hai.kuo and Tom...Now i have two options
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.