How to force sas functions to run on sas not Oracle

[jerry898969]

Is there a way to make SAS run it's functions on a query to oracle? This way I don't have to worry about how oracle handles the functions.

Thank You

[sbb]

Suggest the OP share a code example for more specific, tailored guidance.

Scott Barry
SBBWorks, Inc.

SAS/ACCESS for Relational Databases: Reference, Optimizing Your SQL Usage
http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/a002254657.htm

[jerry898969]

Scott,

Thank you for your reply.

ex.

Proc sql ;
select max(id)
from oracle.customers
quit ;

In this instance is there a way to have sas get all the rows from oracle then run the sas max function to get the correct value?

I know I can just bring in the table and do it in seperate steps but I was asked to see if this example is possible.

Thank you

[sbb]

Check SAS/ACCESS DOC and PASS-through facility using the CONNECTION parameter as part of your SELECT.

Scott Barry
SBBWorks, Inc.


Suggested Google advanced search argument, this topic / post:
proc sql nested query oracle site:sas.com