Architecting, installing and maintaining your SAS environment

Web application using SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

Web application using SAS

Hello Friends,

 

We want to design WEB Application using SAS. Just wanted to understand do and don't . As currently we are using django framework but wanted to use power of SAS .

Which all language is supported in SAS framework , if we need SAS Internet etc . If SAS supports rest API.

 

Would appreciate any information .


Accepted Solutions
Solution
‎09-26-2016 09:41 AM
Trusted Advisor
Posts: 1,326

Re: Web application using SAS

[ Edited ]

Hello,

 

django is a nice framework. It uses python, right?

 

Please let me list and pin-point you to some options that SAS offers for you:

 

- As previously and very well proposed, you can use SAS Stored Process. This allows you to print the final pages on your prefered language: SAS, html, javascript, php, html5, etc. Great thing of stored processes is that you can call them from the SAS webs (Portal, VA, WRS, etc) , but also from SAS EG, or even from SAS batches. Therefore you can create stored process for front-end only and stps for the back-end to process the data. Neat, isn't it?

 

- Another option, more a framework, solution, you can use SAS IntrNet ( http://support.sas.com/documentation/onlinedoc/intrnet/ ), which basically is a framework to create your custom SAS web application, and using Stps.

 

- More options: As of SAS 9.4, SAS brings out-of-the-box a good Apache server (vFabric). And previously, you can just build your own Apache as reverse proxy/load balancer. This means, if you can store static files, with dynamic content, such as HTML5 with jQuery or similar, or even you can build in your php/phython module, you can put there your web application and query SAS, with the right interfaces to SAS.

 

- Also, SAS offer a good framework to develop any web or dektop application towards SAS, with Java, using Eclipse as programming GUI. The solution is called SAS AppDev Studio: http://www.sas.com/en_us/software/app-dev-studio.html

 

Interfaces to SAS:

- You can connect to SAS data with an ODBC connector: http://support.sas.com/downloads/browse.htm?cat=40

- You can use the SAS Integration Technlogies not only to connect to the data, but also as interface to SAS services: https://support.sas.com/documentation/cdl/en/itechov/64881/PDF/default/itechov.pdf

- Finally, not from SAS institute but also interesting, specially if you are used to work with HTML5, @boemskats created a HTML5 adapter to SAS, which can help you to boost your development of web applications that uses SAS: https://boemskats.com/h54s/

 

I believe I am not leaving any important option on the back of my mind.

 

As you see, many options, with pros, and cons. Not only skills-related, but also budget wise. You will need to evaluate which one will fit on your team's power and skills, and fitting on budget and business requirements.

 

Should you have any further question, please let us to know.

 

Best regards,

Juan

 

View solution in original post


All Replies
Super User
Posts: 19,865

Re: Web application using SAS

What exactly are you trying to do? I'm not sure SAS will be the correct tool for a web application as I'm not sure it licenses that way. You're best off talking directly to SAS. 

 

 

Super User
Posts: 7,854

Re: Web application using SAS

You can build a web application solely with SAS, using stored processes. The Stored Process Developer's Guide has a section with a simple example.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Solution
‎09-26-2016 09:41 AM
Trusted Advisor
Posts: 1,326

Re: Web application using SAS

[ Edited ]

Hello,

 

django is a nice framework. It uses python, right?

 

Please let me list and pin-point you to some options that SAS offers for you:

 

- As previously and very well proposed, you can use SAS Stored Process. This allows you to print the final pages on your prefered language: SAS, html, javascript, php, html5, etc. Great thing of stored processes is that you can call them from the SAS webs (Portal, VA, WRS, etc) , but also from SAS EG, or even from SAS batches. Therefore you can create stored process for front-end only and stps for the back-end to process the data. Neat, isn't it?

 

- Another option, more a framework, solution, you can use SAS IntrNet ( http://support.sas.com/documentation/onlinedoc/intrnet/ ), which basically is a framework to create your custom SAS web application, and using Stps.

 

- More options: As of SAS 9.4, SAS brings out-of-the-box a good Apache server (vFabric). And previously, you can just build your own Apache as reverse proxy/load balancer. This means, if you can store static files, with dynamic content, such as HTML5 with jQuery or similar, or even you can build in your php/phython module, you can put there your web application and query SAS, with the right interfaces to SAS.

 

- Also, SAS offer a good framework to develop any web or dektop application towards SAS, with Java, using Eclipse as programming GUI. The solution is called SAS AppDev Studio: http://www.sas.com/en_us/software/app-dev-studio.html

 

Interfaces to SAS:

- You can connect to SAS data with an ODBC connector: http://support.sas.com/downloads/browse.htm?cat=40

- You can use the SAS Integration Technlogies not only to connect to the data, but also as interface to SAS services: https://support.sas.com/documentation/cdl/en/itechov/64881/PDF/default/itechov.pdf

- Finally, not from SAS institute but also interesting, specially if you are used to work with HTML5, @boemskats created a HTML5 adapter to SAS, which can help you to boost your development of web applications that uses SAS: https://boemskats.com/h54s/

 

I believe I am not leaving any important option on the back of my mind.

 

As you see, many options, with pros, and cons. Not only skills-related, but also budget wise. You will need to evaluate which one will fit on your team's power and skills, and fitting on budget and business requirements.

 

Should you have any further question, please let us to know.

 

Best regards,

Juan

 

Trusted Advisor
Posts: 1,326

Re: Web application using SAS

Posted in reply to JuanS_OCS

Just as an addition, from my personal experiences:

 

Ironically, I started with SAS, as application developer, a J2EE A/P. So I started creating applications with the SAS AppDev Studio solution. Good experiences I must to say, because the libraries allow you to play a lot with the power of the SAS backend. Run processes on the STP or Workspace Server, add options on the code, etc. Really powerful for people used to web technologies.

 

In the meantime, I also maintained some applications with SAS/IntrNet & Stored Processes. I think this is the best option for people that are more used to SAS programming that to the Web, because this allows the SAS programmer to focus on the code, and just generate HTML pages and forms that not always require high skills.

 

Recently, and specially with the apparition of SAS VA, a nice looking web application, that works with Flash and HTML5, I could experience a mix of STPs and HTML5/js/jQuery etc. That seems to be a good balance if you don;t need to boost the performance too much, just rely on the power of your STP server, because you can give the SAS programming to SAS programmers and the interface generation to web developers.

 

Also, during the whole time, I followed @boemskats progresses because another tool his company develops. Then 1 or 2 years ago, it was presented to me the HTML5 adapter to SAS. I was honestly impressed, not only of the nice looking applications that can be generated, and the performance they give (removing intermediaries on the web integrations), but also on the easiness on developing applications. At this moment, this adapter is free, and requires a bit to get used to the framework, but once you do, the experiences are very good.

Occasional Contributor
Posts: 12

Re: Web application using SAS

Posted in reply to JuanS_OCS
Thanks a lot
Occasional Contributor
Posts: 12

Re: Web application using SAS

Posted in reply to JuanS_OCS
Yes Django is a high-level Python Web framework .

Thanks a lot, this is exactly what I was looking for. Good to start.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 1770 views
  • 6 likes
  • 4 in conversation