When I aggregate a dataset via proc sql, I have to state the column name via "as" statement else the column will return as something like "TEMP005." There are so many cases where I just want the new aggregated column to have the same name as the var that I am aggregating. For example, say I have a table with four variables: name, amount, hours, and rate, and I am aggregating columns amount, hours, and rate. proc sql; create table test as  select distinct name, sum(amount) as amount, sum(hours) as hours, sum(rate) as rate from have group by name ; quit; Is there any way to not have to write the "as" statement every single time and have the column names just default to whatever I am aggregating?    ... View more