proc sql; create table new as select table1.col1, table4.col2, table5.col3, table2.col4, table3.col5, (table3.col6) as newcol6, sum(table0.col7) as col7, sum(table0.col8) as col8 from table0 inner join table1 on table0.key1=table1.key1 inner join table2 on table0.key2=table2.key2 inner join table3 on table0.key3=table3.key3 inner join table4 on table0.key4=table4.key4 inner join table5 on table0.key5=table5.key5 group by 1, 2, 3, 4, 5, 6; quit;