topic How to force sas functions to run on sas not Oracle in Statistical Procedures

How to force sas functions to run on sas not Oracle

jerry898969 — Fri, 07 Jan 2011 18:21:15 GMT

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

Re: How to force sas functions to run on sas not Oracle

sbb — Fri, 07 Jan 2011 19:35:27 GMT

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

Re: How to force sas functions to run on sas not Oracle

jerry898969 — Fri, 07 Jan 2011 19:40:15 GMT

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

Re: How to force sas functions to run on sas not Oracle

sbb — Sat, 08 Jan 2011 15:02:13 GMT

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