BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Dear Sas users!
Could you please give here a brief example of submitting data from a web form to a sas table. Thank you in advance!
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi:
Generally, form processing follows this model, assuming that you have a standard HTML form to collect user input information.

1) Users enter information in an HTML form using their Web browser and then submit it. The information is passed to the Web server which invokes a program specified using the HTML FORM ACTION:

a) If you are using SAS/IntrNet, then you would usually be invoking an Application Dispatcher program using the Application broker via a URL like this:
<FORM ACTION="http://yourcomp.com/cgi-bin/broker.exe?
_service=default&_program=applib.pgmname.sas&wantrec=lucy">

b) If you are using the BI platform, then you would usually be invoking a stored process program using the Stored Process Web Application via a URL like this:
<FORM ACTION="http://www.host.com:9090/SASStoredProcess/do?
_program="/Foundation/SP_Repos/SP_Name&wantrec=ricky">

2) Either the SAS/IntrNet components process the request (A) or the Stored Process Web Application and the BI Platform servers process the request (B). The results of the SAS program are usually sent back to the browser as streaming results. If you are using SAS Stored Processes, you have the alternative of publishing the SP results to a webDAV location.

There's not a good way to post an example here, since it involves more than just a set of linked files: an HTML form, the SAS/IntrNet program or Stored Process that will be invoked when the form fields are sent. There's also considerable infrastructure and configuration that needs to be in place, depending on whether you are using SAS/IntrNet or the BI Platform.

I suggest you refer to the documentation and/or sample programs for the software you plan to use to process your HTML form data. Or, Tech Support could help you get aimed in the right direction for what you want to do.

cynthia
deleted_user
Not applicable
Thank you, Cynthia!
I've got the result wanted thanks to your comments. My case was BI and the challenge for me was the line after

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 691 views
  • 0 likes
  • 2 in conversation