Dynamic prompts: using the selection from one prompt to define the list in the next one

[AJChamberlain]

Greetings community,

This is a query about EG prompts, if this is the wrong place to put this please let me know. 

I am using SAS EG and have been developing prompts to assist with my project. I think I need to use cascading prompts but am not sure how to.

I am looking at exam data and I have a dataset showing the month of exam sessions and also a code for each batch of papers that need to be sent for marking and grading, my dataset looks something like the one reproduced below. I need to set up two prompts that allow the user to first select first the exam month and then the batch number.

So the user selects the exam session month (Sep-18 to Jan-19) and then, once one of those months has been selected, only present the analyst with options for 'Batch sent for marking' based on the selection made for the exam session. So for example, if the analyst selects "Oct-18" for the exam session then the next prompt will only present the options: B006 to B012 for the 'batch sent for marking' selection.

Can someone tell me how to do this using prompts in EG please?

Thanks

Andy

Dataset:

Exam Session	Batch sent for marking
Sep-18	B001
Sep-18	B002
Sep-18	B003
Sep-18	B004
Sep-18	B005
Oct-18	B006
Oct-18	B007
Oct-18	B008
Oct-18	B009
Oct-18	B010
Oct-18	B011
Oct-18	B012
Nov-18	B013
Nov-18	B014
Nov-18	B015
Nov-18	B016
Nov-18	B017
Nov-18	B018
Nov-18	B019
Nov-18	B020
Dec-18	B021
Dec-18	B022
Dec-18	B023
Dec-18	B024
Dec-18	B025
Dec-18	B026
Jan-19	B027
Jan-19	B028
Jan-19	B029

[ChrisNZ · Accepted solution]

Is this for a stored process?

I never did this myself, but there seems to be many links when looking for 

sas eg cascading prompts

and they seem to require stored processes.

Did you read these resources?

[AJChamberlain]

Thanks Chris, I did read these and worked out that I need to do a selection from a dynamic list and so it needs to be from a stored process.

Thanks for your help.