SAS Guide 6.1 ? mark in Query Builder Icon

[RickyS]

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

Imported Picture

[CaseySmith · Accepted solution]

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.)

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