Desktop productivity for business analysts and programmers

SAS Guide 6.1 ? mark in Query Builder Icon

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

SAS Guide 6.1 ? mark in Query Builder Icon

Wondering what a ? mark in the query builder icon means.  There are no errors or warnings in the log. 

 

Imported Picture

SAS Guide 6.1.PNG


SAS Guide 6.1.PNG

Accepted Solutions
Solution
‎12-09-2016 05:06 PM
SAS Super FREQ
Posts: 306

Re: SAS Guide 6.1 ? mark in Query Builder Icon

[ Edited ]

It means there is a prompt associated with it.  When you run a node (ex. Query Builder, program, etc.) that has an associated prompt, a dialog will be displayed where you can dynamically enter a value for the prompt at runtime, which is then used in the running of your node.

 

For example, you could define a query that returns all the values less than a certain date.  But rather than hard-coding the max date, you could define the filter such that it returns the records whose date is less than a prompt value.  Then, when the Query Builder node is run, you'd enter the max date value you want to use for this particular run.

 

Here is a screenshot of how you can create a prompted filter in the Query Builder:

(Note: You have to define the prompts first, in EG's View->Prompt Manager.)

 

filterWithPrompt.png

And then the prompt dialog that will then be displayed when you run this Query Builder node:

filterWithPrompt2.png

View solution in original post


All Replies
Solution
‎12-09-2016 05:06 PM
SAS Super FREQ
Posts: 306

Re: SAS Guide 6.1 ? mark in Query Builder Icon

[ Edited ]

It means there is a prompt associated with it.  When you run a node (ex. Query Builder, program, etc.) that has an associated prompt, a dialog will be displayed where you can dynamically enter a value for the prompt at runtime, which is then used in the running of your node.

 

For example, you could define a query that returns all the values less than a certain date.  But rather than hard-coding the max date, you could define the filter such that it returns the records whose date is less than a prompt value.  Then, when the Query Builder node is run, you'd enter the max date value you want to use for this particular run.

 

Here is a screenshot of how you can create a prompted filter in the Query Builder:

(Note: You have to define the prompts first, in EG's View->Prompt Manager.)

 

filterWithPrompt.png

And then the prompt dialog that will then be displayed when you run this Query Builder node:

filterWithPrompt2.png

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 144 views
  • 0 likes
  • 2 in conversation