topic Re: Can anyone know how to integrate SAS with PHP? in Administration and Deployment

Can anyone know how to integrate SAS with PHP?

Vimal_U — Tue, 16 Apr 2013 04:47:37 GMT

Can anyone know how to integrate SAS with PHP?

Re: Can anyone know how to integrate SAS with PHP?

LinusH — Tue, 16 Apr 2013 07:36:27 GMT

Kind of open question.

If you could give some examples of your requirements, it would be simpler to point in the right direction.

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Tue, 16 Apr 2013 07:52:25 GMT

We want to access SAS datasets for data manipulations like creating new DS from raw datasets. And we want to write SAS codes inside the PHP to handle the DSs.

Is this is possible. If so, how?

Note: We are trying to create a web based application using this.

Re: Can anyone know how to integrate SAS with PHP?

LinusH — Tue, 16 Apr 2013 08:26:41 GMT

Not being a PHP-programmer, just trying to interpet web information...

One obviuos way is for you to talk to SAS via ODBC/JDBC. Unfortunately, your SAS installation needs to licensed to act as a ODBC Server (SAS/SHARE and SAS/SHARE*NET).

Another way to integrate with SAS is to use the API for IOM (Integrated Object Model). Check out the on line doc and resources to see whether this is feasible for you. i think this method requires a license for "SAS Integration Technologies".

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Tue, 16 Apr 2013 09:01:08 GMT

Ya.Thanks a lot. We are having license for SAS/SHARE.. But how can we use that to integrate with PHP?

Is there any kind of procedures to follow?

Re: Can anyone know how to integrate SAS with PHP?

LinusH — Tue, 16 Apr 2013 10:35:06 GMT

You also need a license for SHARE*NET (it's just a license add on, not a real product that needs to be installed).

That will give you the possibility to access SAS via ODBC, hence giving you possibility to read and manipulate data via SQL.

The procedure is to have a SAS/SHARE server up and running, and then define it as a data source in your ODBC manager (which of course requires that you have the SAS ODBC driver installed on that host).

SAS ODBC Drivers

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Tue, 16 Apr 2013 12:01:41 GMT

Is there any possibility of accessing using "SAS/ACCESS Interface to ODBC"?

Re: Can anyone know how to integrate SAS with PHP?

LinusH — Tue, 16 Apr 2013 12:31:22 GMT

That's the other way around, that module is used by SAS for accessing other data sources.

A possible solution is to use any other ODBC database, and have your web app access that (and SAS can then access that data separately). But then the question is, what role has SAS in your application, other than a data store...?

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Tue, 16 Apr 2013 12:40:00 GMT

We want to use SAS as our back end.

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Tue, 16 Apr 2013 12:44:44 GMT

Actually we want to run SAS codes inside the PHP to generate SAS DS. And we can reuse the new DS as well.

Re: Can anyone know how to integrate SAS with PHP?

LinusH — Tue, 16 Apr 2013 12:52:21 GMT

Perhaps you could write some SAS Stored Process, which you could call from PHP (via http calls)....? ODBC won't let you run SAS specific code, just ANSI-like SQL.

Re: Can anyone know how to integrate SAS with PHP?

Tom — Tue, 16 Apr 2013 13:03:21 GMT

If SAS is installed on the same server that is running the PHP code then you can just call SAS the same as you would call any other operating system command. Not necessarily as interactive of using IOM, but probably a lot simpler to get started.

http://chipmunkninja.com/Program-Execution-in-PHP%3A-exec-m@

Re: Can anyone know how to integrate SAS with PHP?

chrisj75 — Tue, 16 Apr 2013 13:17:57 GMT

I'd done something similar whereby SAS calls PHP via a URL fileref, but never with PHP controlling SAS.

Also, be aware that the terms of your SAS licence prohibit exposing of SAS functionality to a web-based environment, i.e. you are not allowed to take a HTML form submission containing SAS code, and pass it back to SAS for processing.

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Tue, 16 Apr 2013 13:25:07 GMT

I have tried the following piece of code already but it's working. Is this rit format?

<?php echo exec('"C:\Program Files\SASHome\SASFoundation\9.3\sas.exe" -SYSIN <<pgmpath with name>> -CONFIG "C:\Program Files\SASHome\SASFoundation\9.3\nls\en\sasv9.cfg"');

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Tue, 16 Apr 2013 13:31:36 GMT

We have license version of SAS 9.3 so it may not lead any issues i think.

Re: Can anyone know how to integrate SAS with PHP?

chrisj75 — Tue, 16 Apr 2013 13:38:44 GMT

From the PHP snippet, it seems you're invoking SAS on a local machine. The licence will cover that machine only. Exposing SAS functionality via a web-based / PHP-processed form to multiple users is a breach of that single PC/user licence.

Re: Can anyone know how to integrate SAS with PHP?

Tom — Tue, 16 Apr 2013 13:53:19 GMT

Not sure that there will be anything to "echo" even if it works. You might want to add -LOG and -PRINT option to make sure that the SAS log and output files are written where you want them.

<?php echo exec('"C:\Program Files\SASHome\SASFoundation\9.3\sas.exe" -SYSIN <<pgmpath with name>> -CONFIG "C:\Program Files\SASHome\SASFoundation\9.3\nls\en\sasv9.cfg"');

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Fri, 19 Apr 2013 05:10:59 GMT

Sorry Tom, Actually the code snippet i mentioned earlier was not working. I hope the above code will work in UNIX based system, But it doesn't work in Windows.

So Let me know if there are any similar codes that would run in a Windows based system.

Re: Can anyone know how to integrate SAS with PHP?

Vimal_U — Fri, 19 Apr 2013 10:39:02 GMT

Hi to all,

Is this possible to use SAS with ASP.NET for the same need?

Re: Can anyone know how to integrate SAS with PHP?

PrinceAde — Sat, 24 Aug 2024 14:22:19 GMT

Hello @Vimal_U

Good day.

Please I would like to know if you are able to achieve your aim back then, i.e. the integrating SAS with PHP. I'am trying to do achieve the same thing.
I will appreciate your insight, thank you.