topic Re: Exclude values from dynamic prompts in SAS Enterprise Guide

Exclude values from dynamic prompts

Pontus — Wed, 01 Mar 2017 14:23:33 GMT

I have created an STP in EG, with dynamic prompts and dependencies.

So, when I choose a value from the firts prompt, the next prompt is populated with values.

However, I don't want all the values to be available in the second prompt. Is there some way to exclude values from being shown?

Re: Exclude values from dynamic prompts

Jay_TxOAG — Thu, 02 Mar 2017 10:35:27 GMT

Creating a prompt data set separate from your STP data source is a good way to control your prompt values...where are you getting your prompt values?...your dynamic data values

Re: Exclude values from dynamic prompts

Pontus — Thu, 02 Mar 2017 10:38:47 GMT

I get the prompt values from one of the tables in the database.

I don't have access rights to create new tables and place them in the public areas of the database. Is there another way?

Re: Exclude values from dynamic prompts

Jay_TxOAG — Thu, 02 Mar 2017 10:46:10 GMT

Sorry, that functionality does not exist in the prompt creation process...all you get is, essentially, a where statement in your dependency choice.
Since prompt data sources must be registered, there is no way to make the prompt source conform without a permanent data set.