Prompt selection for stored process

[gauravp1993]

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.

[gauravp1993]

I found the solution in following link:

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