Prompt selection for stored process

gauravp1993 — Mon, 08 Aug 2016 14:53:11 GMT

Hello,

I am trying to create a dataset using proc sql in which filters are applied in where clause of proc sql uaing parameters linked to prompt filters of stored process.

Is there any way so that if 4 filter prompts are available for selection,on which only two are compulsory to selection,

while if i am not selecting the other two prompt,by default all values are used for filtering data and if i am selecting one option in prompt,that will be used for filtering data in proc sql.

Re: Prompt selection for stored process

gauravp1993 — Thu, 11 Aug 2016 05:50:15 GMT

I found the solution in following link:

http://bi-notes.com/2014/01/sas-stored-processes-simple-trick-letting-user-choose/

topic Prompt selection for stored process in Developers

Prompt selection for stored process

Re: Prompt selection for stored process