Help using Base SAS procedures

Implicit Pass Through SQL View

Reply
Super Contributor
Posts: 316

Implicit Pass Through SQL View

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

Respected Advisor
Posts: 3,887

Re: Implicit Pass Through SQL View

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;

Frequent Contributor
Posts: 110

Re: Implicit Pass Through SQL View

Ask a Question
Discussion stats
  • 2 replies
  • 182 views
  • 0 likes
  • 3 in conversation