Desktop productivity for business analysts and programmers

Change default identifier and column name for computed column

Reply
Occasional Contributor
Posts: 9

Change default identifier and column name for computed column

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

Contributor
Posts: 30

Re: Change default identifier and column name for computed column

Can you elaborate please if you are looking for

data a;

input a 1.;

cards;

1

2

3

4

5

;

run;

proc sql;

create table b as

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


Occasional Contributor
Posts: 9

Re: Change default identifier and column name for computed column

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?

Computed Column Example.JPG

Ask a Question
Discussion stats
  • 2 replies
  • 184 views
  • 0 likes
  • 2 in conversation