Re: Proc Sql Vs Pass thru

deleted_user · Posted 08-13-2009 07:58 AM

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.

Flip · Posted 08-13-2009 09:06 AM

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

Doc_Duke · Posted 08-13-2009 09:33 AM

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.

ChrisHemedinger · Posted 08-13-2009 11:23 AM

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

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

Proc Sql Vs Pass thru