Implicit Pass Through SQL View

[milts]

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

[Patrick]

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;

[sassharp]

good paper for the contest

http://support.sas.com/resources/papers/proceedings11/105-2011.pdf