topic Change default identifier and column name for computed column in SAS Enterprise Guide

Change default identifier and column name for computed column

audioa84 — Thu, 28 Mar 2013 15:05:48 GMT

Is there a way to change what the default Identifier and Column Name are for computed columns? If I am simply summarizing a column, I tend to like to use the same name as the column I am summarizing. I know this may not be recommended but it looks cleaner in my opinion.

Thanks in advance,

Mark

Re: Change default identifier and column name for computed column

BobyGadu — Fri, 29 Mar 2013 20:17:09 GMT

Can you elaborate please if you are looking for

data a;

input a 1.;

cards;

;

run;

proc sql;

create table b as

select sum(a) as a from a;quit ;

Re: Change default identifier and column name for computed column

audioa84 — Fri, 29 Mar 2013 20:28:58 GMT

When in the query builder function, if you create a new computed column, follow steps 1 and 2 which have you select what type of computed column you want and what the calculation is or what column to summarize/recode, the 3rd screen will ask you what to name the new computed column. The default for Identifier is _Calculation and for Column Name is Calculation. Is there somewhere in the options or anywhere else, where I can tell it to simply use the name of the originating column when the type of column (step 1) is a summarized column?