Hi All, When I was trying to do something like:
proc sql;
create table work.test as
select col1,
col2,
put(col3, 3.) as new_col3,
sum(col4) as new_col4
from source_table
group by col1,
col2,
col3;
quit;
I constantly got an Error: The following columns were not found in the contributing tables: new_col3 I did some search and understood that this kind of error usually appears when using some calculated value in the WHERE clause and can be solved by using the key word CALCULATED. I am not sure if here's the same situation when I was trying to use GROUP BY. If it is a similar situation, where should I use the CALCULATED key word? Thanks! Eric
... View more