topic Re: SAS API in SAS Programming

SAS API

Mathie — Mon, 20 Aug 2018 12:06:38 GMT

Hello,

I am a new SAS user and I am interested in the APIs they offer. I have a hard time locating myself in the documentation.

I would like to know if it is possible, from an Internet site and the API, to transmit data to analyze directly on its software of the user ?
Without needing to export in CSV

Thanks you advance !

Re: SAS API

RW9 — Mon, 20 Aug 2018 12:11:14 GMT

You would likely need a SAS server setup somewhere (with the appropriate licenses), and then stored processes to read the data, process and return results.

http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/index.html

Re: SAS API

Mathie — Mon, 20 Aug 2018 16:40:52 GMT

Thanks for your help !

But that does not seem to answer my need.

To be more clear (sorry): I have data in a database (Simple mysql database)

I would like that when the user clicks on a button on my site, this data (that I treated) are directly imported into the user software

It's possible with that ?

Thanks you !!

Re: SAS API

ybolduc — Mon, 20 Aug 2018 17:53:40 GMT

Hi Mathie,

Yes, SAS can connect directly to a MySQL database and extract the data. It can also write the result back to MySQL.

To do so, you will need to acquire SAS/Access to MySQL.

SAS being an extremely poverful and flexible platform, there is an extremely large numbers of way to do this. Using Stored Process as mentionned earlier is probably the most user-friendly approach if there is no existing SAS practice at your corporation.

Thanks,

Re: SAS API

Mathie — Mon, 20 Aug 2018 18:32:58 GMT

Thanks, I'm going to look into it

I read this page: http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/using.html

What software should I use to send information to the client software?

I would rather select data in the database (in NodeJS), write a stored procedure and send the result directly to the user's software.

Re: SAS API

error_prone — Mon, 20 Aug 2018 20:33:22 GMT

All depends largely on the sas licence you have and what the users need to do with data.

Re: SAS API

ybolduc — Mon, 20 Aug 2018 20:37:25 GMT

Hi Mathie,

I get the feeling that you may need to hire a technical architect for your solution. This is a support forum, we can provide input for technical detals but I think at this point the answers you are looking for would better be addressed by someone who will take the time to understand your need and your existing technology and provide you different options.

Thanks,

Re: SAS API

Mathie — Mon, 20 Aug 2018 21:30:07 GMT

I have not a licence for the time being

Users just need to be able to process the data from their software.

I am a developer but unfortunately I do not know SAS at all and it is hard to understand everything at once, I apologize ..