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

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

hwilson — Tue, 10 Nov 2015 15:11:42 GMT

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.

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

BrunoMueller — Tue, 10 Nov 2015 16:07:31 GMT

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

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

hwilson — Tue, 10 Nov 2015 19:14:22 GMT

That worked perfectly!

Thank you.

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

BrunoMueller — Wed, 11 Nov 2015 18:09:50 GMT

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

Thanks

Bruno