Inner Join with different column names

pw7632 — Fri, 15 Nov 2019 14:10:46 GMT

proc sql noprint;
create table baseball as
select a.Name , a.dob , a.gender , b.name, b.start, b.end

from salaries b inner join
TMP2.players a
on a.name = b.name;
quit;

I have a dataset that have the same values but different column names. a.Name , a.dob , a.gender all have different column names. How do I change them to make them the same as the b table? I also want the common variable to be name to join them.

Re: Inner Join with different column names

Tom — Fri, 15 Nov 2019 14:22:11 GMT

@pw7632 wrote:

proc sql noprint;
create table baseball as
select a.Name , a.dob , a.gender , b.name, b.start, b.end

from salaries b inner join
TMP2.players a
on a.name = b.name;
quit;

I have a dataset that have the same values but different column names. a.Name , a.dob , a.gender all have different column names. How do I change them to make them the same as the b table? I also want the common variable to be name to join them.

A SAS dataset cannot have two variable with the same name. So in your example code the second variable named NAME is not going to be written. Just provide new name in the select statement. There is no need for two copies of NAME since your join is requiring them to be the same value. But if both dataset had DOB and GENDER for example you could select both and rename one of them.

create table baseball as
 select a.Name 
      , a.dob 
      , a.gender 
      , b.dob as dob2
      , b.gender as gender2
      , b.start
      , b.end
 from salaries b
   inner join TMP2.players a
   on a.name = b.name
;

topic Re: Inner Join with different column names in SAS Programming

Inner Join with different column names

Re: Inner Join with different column names