Selection Group Prompt and Management Console

I have code allowing end users to choose either a date range for "filedate" or "termdate." I want to set the prompts in Management Console to limit a users data entry to if they select filedate_min and filedate_max, they then are not allowed to enter date for termdate_min and termdate_max, and vice verse. In other words, I want it to be a gray scale. I'm including my code below. I'm not sure how I would set this up in the Management Console?

Selection Group Prompt and Management Console

I had an opportunity to look at your blog site and have a few followup questions for you.

1. When using a date range prompt, is there a way to limit the date range to only custom (hide year to date, month to date, previous N days, next N days)?

2. I want to establish dependencies between two prompts, where the values that are displayed for the District prompt will depend on the value that is selected for the Division prompt. I'm just not certain how I would do this in Management console? In the example in SAS Help Management Console, it talks about having tables with columns, I'm wondering what those tables would need to look like. For instance, if the user selected Circuit (0) then the only District that would appear would be (90) District of Columbia; if the user selects Circuit (1) then the District options would be (00) Maine, (01) Massachusetts, (02) New Hampshire, (03) Rhode Island and (04) Puerto Rico and so forth.

Selection Group Prompt and Management Console

Wrt. 2, your data has to have a Circuit column and a District column. In addition, you need a table just with the Circuit values. Then use the Dependencies tab in the Prompt dialogue to point the Circuit column to the selection field where you selected Circuit.

Re: Selection Group Prompt and Management Console

2 - This very example is covered in the Building Business Intelligence with SAS book on pages 93 and 115. Based on the questions you have been asking - I think you would find the book a tremendous asset on your learning path.