topic Query while creating Stored process. in Developers

Query while creating Stored process.

india2016 — Wed, 07 Mar 2018 05:02:24 GMT

Hello everyone,

Actually I have created Stored Process using SAS EG.

1) Now I wanted to know how can I create stored process in which I have 6 parameters,

and if I give only 4 parameters value then that should give output on those 4 parameters.But I cant use 'OR' condition in between that 4 conditions because that may give unnecessary result.

2) And stored process has two outputs so I want those output in one page .(I have created stored process in SAS EG and running on SAS Stored Process Web Application).

Re: Query while creating Stored process.

Kurt_Bremser — Wed, 07 Mar 2018 07:18:43 GMT

How are the 6 prompts defined?

If you allow a prompt to be emtpy/missing, you can react on that in the STP.

For further help, we will need the code you already have in the STP, especially the part that creates the outputs.

Re: Query while creating Stored process.

andreas_lds — Wed, 07 Mar 2018 07:20:47 GMT

We need to see the code you have to answer the questions.

For 1) You will most likely need some marcro-code so solve this.