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?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.