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
I would expect that also the view gets executed on the DB.
But why not just try - eventually using below options to show you in the log what gets sent to the DB.
option sastrace=',,,d' sastraceloc=saslog no$stsuffix;
good paper for the contest
http://support.sas.com/resources/papers/proceedings11/105-2011.pdf
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.