Calling SAS from SQL

I am "old school" and remember calling an assembler subroutine into a COBOL program and passing the results back.

Does anyone know if this can be done with MsSQL calling a SAS module and passing results back (ADO)?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dqmqCommented:
The scripting language for MSSQL is called TSQL and it does not support direct calls to "called subroutines" in the old-school sense.  It is remotely possible, that your vendor provides TSQL functions or procedures that indirectly expose the SAS modules, but I cannot speak to that.  

More than likely, you need to use a more powerful language that gives you access to both the MSSQL data and to the SAS modules.  Again,  you need to ask your SAS vendor what kind of API's they provide and what development environments are supported.   Typically, are packaged and distributed in a DLL that can be referenced from your code. BTW, even in old-school COBOL, you would need to ask the same question.  Callable subroutines did not happen by chance; they happened by design because the vendor chose to make them available.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.