merging two tables and changing var names

[yoyong555]

Hi. 

I have two identical tables and I want to add the last column of the second table to the first table. But I want to change the variable names.

How do I program it?

Table 1

Group	Setting	Value
1	a	25
2	b	30
3	c	45

Table 2

Group	Setting	Value
1	a	48
2	b	59
3	c	35

Final output

Group	Setting	Value 1	Value 2
1	a	25	48
2	b	30	59
3	c	45	35

Thanks.

[Kurt_Bremser]

data want;
merge
  table1 (rename=(value=value_1))
  table2 (rename=(value=value_2))
;
by group setting;
run;

[yoyong555]

Thank you. If I use PROC SQL, how will the program look like?

[Kurt_Bremser · Accepted solution]

proc sql;
create table want as
  select
    coalesce(t1.group,t2.group) as group,
    coalesce(t1.setting,t2.setting) as setting,
    t1.value as value_1,
    t2.value as value_2
  from table1 t1
  full join table2 t2
  on t1.group = t2.group and t1.setting = t2.setting  
;
quit;