Filter using a prompt

[Leandro_Vasconc]

Hi,

I want to use a prompt to do a filter in a query, but showing a list with the column values.

Example 1:

   column

1   171

2   185

3   202

4   204

5   205

6   210

Example 2:

   column

1   83

2   88

3   90

4   95

The observations in each example depends on filters that I did before, so there is no fixed number of values to display.

So, I want the possible values to appear in a list for the user, depending on which values exist at that query.

(Sorry for about some mistakes in the text, I don't speak English very well)

[ChrisBrooks · Accepted solution]

Hi @Leandro_Vasconc and welcome to the community.

Could you tell us which SAS interface you want to create the prompt in please (e.g. Enterprise Guide, SAS Studio etc)? The answer to your question will vary depending on the answer 

[Leandro_Vasconc]

Hi @ChrisBrooks,

I'm using SAS EG, anyway the SAS Support sent me this link: https://video.sas.com/detail/video/3862944636001/create-cascading-prompts-and-define-dependencies

Thank you.