SAS API

[Mathie]

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 !

[RW9]

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

[Mathie]

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 !!

[ybolduc]

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,

[Mathie]

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.

[ybolduc]

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,

[error_prone]

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

[Mathie]

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 ..