Solved

Calling SAS from SQL

Posted on 2012-03-19
1
420 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

831 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