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.
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
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
That worked perfectly!
Thank you.
Please mark the discussion as answered, so others will know this question has an answer. This helps greatly when searching for topics.
Thanks
Bruno
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.