- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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 ;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?