Adding a quick SAS Stored Process query to your main website

0

Well, I had a few users this week who wanted to access a print out of one record in the database. Fortunetly, they all know the primary key - so the query was really simple. However, to make it extremely easy for users, I didn't want to link to another location on the intranet from the page they are already on. Why not have an input box & a 'Go' button that runs the SAS Stored Process from there!

Here is the code:

<form name="form1" method="post" action="http://localhost:8080/SASStoredProcess/do?_program=/folder/stored process name">

<b>Key Lookup:</b><input name="KEY" maxlength="6" tabindex="1" title="Type the Key Number in this field." type="text">

<br> <INPUT TYPE="submit" value="Go">

</form>

Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Comments are closed.

Back to Top