topic Re: Proc Sql Vs Pass thru in SAS Enterprise Guide

Proc Sql Vs Pass thru

deleted_user — Thu, 13 Aug 2009 11:58:30 GMT

Hi,

Please help me understand which would to fast to fetch tran level data form Oracle database.

Will there be any differece for the query response time with the facilities available.

Help will be appreciated.

Thanks!
Sridhar.

Re: Proc Sql Vs Pass thru

Flip — Thu, 13 Aug 2009 13:06:59 GMT

That will depend on the relative size and tuning of the Oracle vs SAS platforms.

Re: Proc Sql Vs Pass thru

Doc_Duke — Thu, 13 Aug 2009 13:33:37 GMT

Passthru gives you explicit control. With the LIBNAME approach to database connections, SAS tries to generate native SQL code that it passes. Sometimes it writes better code than you can, other times not. Sometimes you may inadvertently use a function in SAS that oracle doesn't recognize, so the entire table is pulled to SAS for analysis.

As was mentioned earlier, your mileage may vary.

Re: Proc Sql Vs Pass thru

ChrisHemedinger — Thu, 13 Aug 2009 15:23:15 GMT

You might check out the wealth of knowledge in these related papers from SAS:

http://support.sas.com/resources/papers/tnote/tnote_database.html

Chris