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 |
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?
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?
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.