Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Calling SAS from SQL

Posted on 2012-03-19
1
Medium Priority
?
449 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 42

Accepted Solution

by:
dqmq earned 2000 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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

704 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