Desktop productivity for business analysts and programmers

Proc Sql Vs Pass thru

Reply
N/A
Posts: 0

Proc Sql Vs Pass thru

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.
Super Contributor
Posts: 359

Re: Proc Sql Vs Pass thru

That will depend on the relative size and tuning of the Oracle vs SAS platforms.
Valued Guide
Posts: 2,111

Re: Proc Sql Vs Pass thru

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.
Community Manager
Posts: 2,696

Re: Proc Sql Vs Pass thru

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
Ask a Question
Discussion stats
  • 3 replies
  • 100 views
  • 0 likes
  • 4 in conversation