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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.