topic merging two tables and changing var names in SAS Programming

merging two tables and changing var names

yoyong555 — Tue, 10 Nov 2020 19:23:12 GMT

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.

Re: merging two tables and changing var names

Kurt_Bremser — Tue, 10 Nov 2020 19:28:59 GMT

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

Re: merging two tables and changing var names

yoyong555 — Tue, 10 Nov 2020 19:36:28 GMT

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

Re: merging two tables and changing var names

Kurt_Bremser — Tue, 10 Nov 2020 20:01:40 GMT

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;