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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.