topic Re: Filter using a prompt in New SAS User

Filter using a prompt

Leandro_Vasconc — Tue, 16 Apr 2019 19:15:31 GMT

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)

Re: Filter using a prompt

ChrisBrooks — Tue, 16 Apr 2019 23:25:31 GMT

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

Re: Filter using a prompt

Leandro_Vasconc — Mon, 22 Apr 2019 15:01:51 GMT

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.