Is it possible to make a dynamic web page using SAS and html? 2

[Katie6]

Hi there,

I have just started a new job. The department has an enormous database of information about customers. What they want to do is create a web portal for the customers to access that information. I know html, but no SAS and the rest of the department know SAS but not html. We somehow need to link the two together and I would like to know what skills I need to develop in order to do that (e.g. do I need to learn javascript?). This is what we want exactly:

Reading from the database: When a user enters their name into a form, we want to use that information to access the rest of their details (address etc) and then auto-fill the rest of the form with those details.

Writing to the database: In the form there will be empty fields that the user will need to fill in. We would like the information entered by the user to be written to the database.

What languages/scripts will I need to do this? I would ordinarily think of using php and sql, but this is a department of SAS coders so I need to use SAS if it is possible.

Many, many thanks for your kind help,

Katie

 

[dje]

The product SAS Intrnet product is a product that you will likely find helpful. With that product you can establish web buttons that execute sas programs and the output can be directed to _webout which provides the html output of the results of the SAS program, charts, lists , stats, whatever. If you have forms for users to fill in for querys then you would need to get familiar with HTMSQL which is a part of the SAS Intrnet product.


The short answer is that SAS can be a good tool for Dynamic web page solutions. The Products on the server needs to include the Intrnet product, Share, and possible some others depending on your needs. It takes a bit to get the setup on the server but once you do you have a very powerful tool to accomplish your desires.

dje

 

[ChrisW75]

As an alternative, if you have SAS Integration Technologies on the server, you can use a java front end to submit SAS jobs etc. In other words, with some JAva or Java script knowledge, you can create a web page which will run pre-built SAS programs on the server to pull out results and display them.
I don't know much more on the topic than that, but searching on the SAS Support site can give you some good ideas.

http://www2.sas.com/proceedings/sugi29/030-29.pdf

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

 

[Katie6]

Thank you very much for your help

Katie