Hi,
Kinda dumb question to ask but I'm just curious.
Given that I create a sql create table similar to the one below, isn't it that summarization will be done on the teradata database before it is passed to sas?
libname tera_lib teradata server="terasvr" schema="my_schema" user=sasuser password=abc123;
proc sql;
create table sas_lib.out as
select a,b,sum(val) as total
from tera_lib.tera_src
group by a,b
quit;
But what if I declared a view instead of a table? Will processing still be done in the teradata database everytime I try to access the view?
proc sql;
create view sas_lib.vw_out as
select a,b,sum(val) as total
from tera_lib.tera_src
group by a,b
quit;
Best Regards,
Milton
