Invoking SAS in-database procedures is fun and easy; simply set the SQLGENERATION option to DBMS:
options sqlgeneration = dbms;
proc options option=sqlgeneration;
And, to see how it is working, make sure to specify the SASTRACE option:
options sastrace=',,,d' sastraceloc=saslog nostsuffix;
As a final note, check out this very well-written; very helpful SAS Global Forum 2010 paper by SAS Institute smarties Scott Mebust and Robert S. Ray:
SAS Presents In-Database Base Procedures in Practice
Integrating SAS in-database procedures into your approach to crunching your Oracle data may just be the thing you need to save you time, time, and more time!
Andy, best of luck in all your SAS endeavors!
I hope that this suggestion proves helpful now, and in the future!
Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.
Michael A. Raithel
"The man who wrote the book on performance"
Author: Tuning SAS Applications in the MVS Environment
Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition
Author: The Complete Guide to SAS Indexes
Make of it what you will. - Leif Enger