topic Re: Implicit Pass Through SQL View in SAS Procedures

Implicit Pass Through SQL View

milts — Mon, 02 Jul 2012 09:16:20 GMT

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

Re: Implicit Pass Through SQL View

Patrick — Mon, 02 Jul 2012 09:31:27 GMT

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;

Re: Implicit Pass Through SQL View

sassharp — Tue, 03 Jul 2012 15:39:11 GMT

good paper for the contest

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