Programming the statistical procedures from SAS

How to force sas functions to run on sas not Oracle

Reply
Super Contributor
Posts: 400

How to force sas functions to run on sas not Oracle

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
Super Contributor
Super Contributor
Posts: 3,174

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

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

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

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
Super Contributor
Super Contributor
Posts: 3,174

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

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