Your SAS programs, embedded in web apps and elsewhere

Stored process not asking for parameter value.

Reply
Occasional Contributor
Posts: 10

Stored process not asking for parameter value.

Hi..

Here is the situation.I have two diff stored process. In the first store process we have an html page where we are displaying some information. If anyone want to change it they have to press the button which will hit the second stored process where we have 3-4 mandatory prompt.

while executing the whole thing I am getting error in the second page.If i press edit button it is going to the second stored process but it is giving error-

* x,y,z parameter doesn't have any value.

As per me the prompt page of the second stored process should have opened but its expecting the value instead of that. How to resolve this???

Thanks in advance.

PROC Star
Posts: 1,322

Re: Stored process not asking for parameter value.

Hi,

I'm having a hard time understanding your question, and guessing other folks are as well, since nobody responded today.  Can you provide more description of what you are doing?

You have two different stored processes.  Does the first stored process generate an HTML page that gathers user inputs for the second stored process?  I'm not sure what you mean by "edit button." 

I think a little more information would help people help you.

--Q.

Occasional Contributor
Posts: 10

Re: Stored process not asking for parameter value.

well...edit button is nothing but a submit button which will take you to the next stored process.

Ok..I am explaining ...

I have two diff stored process.

First one is an html page where it displays the last updated value. If anyone want to change it,  he has to press the button which will take you to the next stored process.

In the second stored process I have several mandatory prompt.As per the input value it updates the table.

whenever I am executing, its is going to the next stored process but it is not asking for the value. Means no  prompt page is getting appeared .....Its throwing an error saying that no value for input parameter.

As per me a prompt page should open to ask for the input parameter value/prompt value.

I hope its clear (keeping my finder crossed Smiley Happy )

PROC Star
Posts: 1,322

Re: Stored process not asking for parameter value.

So first stored process generates an html page, where user clicks a button on that generated page.  And when user clicks, you want them to get a prompt page for the second stored process, right?

On the generated html page, what does the URL behind the button look like?  Would think it should include _action=properties if you want it to display the prompts for the second stored process.

Occasional Contributor
Posts: 10

Re: Stored process not asking for parameter value.

I am doing-

PUT '<form name="rarrs" method = "post" action="/SASStoredProcess/do">' ;

PUT '<input type="hidden" name="_PROGRAM"'

    ' value="second stored process name">';

but its not giving me the prompt page.

PROC Star
Posts: 1,322

Re: Stored process not asking for parameter value.

I would try adding  a second input field (variable?)  _ACTION with the value of "Properties", analogous to the _PROGRAM field.  That should (could?) tell SAS to show the prompt page rather than execute the stored process.

Ask a Question
Discussion stats
  • 5 replies
  • 728 views
  • 0 likes
  • 2 in conversation