DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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

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.


Accepted Solutions
Solution
‎11-11-2015 03:13 PM
SAS Super FREQ
Posts: 682

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

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

 

View solution in original post


All Replies
Solution
‎11-11-2015 03:13 PM
SAS Super FREQ
Posts: 682

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

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

 

New Contributor
Posts: 2

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

That worked perfectly! 

 

Thank you.

SAS Super FREQ
Posts: 682

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

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

 

Thanks

 

Bruno

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 395 views
  • 0 likes
  • 2 in conversation