I have a stored process I am using to allow uses to pull their own report through the AMO add-on and am having difficulty allowing them to choose multiple people from a list when using a prompt in a stored process. as an example the prompt request an associate or multiple associates to be chosen from a drop down list. Bob Smith Jane Doe John Doe One or all may be chosen. How do I include this prompt in a stored process? I know using SAS Enterprise guide it uses the following: WHERE %_eg_WhereParam( t1.AnalystIDCM, Analyst, IN, TYPE=S, IS_EXPLICIT=0 ) however this does not work in a stored process. Thank you for any help in advance.
... View more