topic Re: How to Add Prompt to Filter in Query setting in SAS Enterprise Guide

How to Add Prompt to Filter in Query setting

sdang — Tue, 17 Mar 2015 19:53:40 GMT

How do I add prompt to filter in Query setting. So when users open the report it prompts them to input two date values. I created the prompt in Prompt Manager. Below is the image of where I want to use my prompt.

Thanks

Re: How to Add Prompt to Filter in Query setting

tlk — Tue, 17 Mar 2015 20:04:24 GMT

In Options menu you will have the prompt option, there you can had your prompt, then after you will be able to filter using the macro variable defined by the prompt (&yourprompt)

Re: How to Add Prompt to Filter in Query setting

sdang — Tue, 17 Mar 2015 20:10:56 GMT

How do I apply macro?

Re: How to Add Prompt to Filter in Query setting

tlk — Tue, 17 Mar 2015 20:19:49 GMT

You create a new filter

Then you select your column and after in the value field

you select your prompt

Re: How to Add Prompt to Filter in Query setting

sdang — Tue, 17 Mar 2015 20:27:06 GMT

Thank you. I applied your setting and it worked but no data were shown. Any idea? Below is an image of my Promp_1 setting and the structure of the date/time variable.

Thanks

Re: How to Add Prompt to Filter in Query setting

sdang — Tue, 17 Mar 2015 20:44:11 GMT

I found the solution. In step 3 of 4 of Build a basic filter, I selected "In a Range". Thank you for all your help.