BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
AJChamberlain
Obsidian | Level 7

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 SessionBatch sent for marking
Sep-18B001
Sep-18B002
Sep-18B003
Sep-18B004
Sep-18B005
Oct-18B006
Oct-18B007
Oct-18B008
Oct-18B009
Oct-18B010
Oct-18B011
Oct-18B012
Nov-18B013
Nov-18B014
Nov-18B015
Nov-18B016
Nov-18B017
Nov-18B018
Nov-18B019
Nov-18B020
Dec-18B021
Dec-18B022
Dec-18B023
Dec-18B024
Dec-18B025
Dec-18B026
Jan-19B027
Jan-19B028
Jan-19B029

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisNZ
Tourmaline | Level 20

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?

 

View solution in original post

2 REPLIES 2
ChrisNZ
Tourmaline | Level 20

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
Obsidian | Level 7

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: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 683 views
  • 0 likes
  • 2 in conversation