How do you use a prompt for multiple values in a stored process?

[hwilson]

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.

[BrunoMueller · Accepted solution]

The %_eg_WhereParam macro is not an autocall macro, therefor it is not available by default.

To get the source code of this macro, do the follwoing:

create a multiple value parameter in SAS Enterprise Guide

use the parameter in a query

export the code using File -> Export -> Export all code in process flow

This will also add the source code for %_eg_WhereParam

Bruno

[hwilson]

That worked perfectly! 

Thank you.

[BrunoMueller]

Please mark the discussion as answered, so others will know this question has an answer. This helps greatly when searching for topics.

Thanks

Bruno