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.
... View more
