Solved

Calling SAS from SQL

Posted on 2012-03-19
1
427 Views
Last Modified: 2012-06-21
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)?
0
Comment
Question by:morinia
1 Comment
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 37740656
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question