Prompt using generated dataset in the a project

[ridiculas]

Hi Guys,

I created a prompt to allow users to select multiple values from a dynamic list. The dynamic list is updated in the first process flow of a project, and the prompt is used in the program in the second process flow in the same project. So the issue is, the prompt pops up every time the project is run even before the first process flow is executed.

Is it possible to delay the prompt until the first process flow finished?

[Manu_SAS]

Go to -> Prompt Manager

Click Edit the prompt 

Navigate to General tab -> Options

Check the box with "Use prompt value throughout the project".

-Manohar

[ridiculas]

Hi Manu

I tried that but still having the issue. The two process flows I mentioned in the original post are two sas programs. The first program in the 1st process flow updates the dynamic list that will be used in the prompt for user to select, and the second program in 2nd process flow uses the prompt values for a few procedures.

Thanks for the reply.

[RahulG]

Your dataset should be populated before prompt ask for user to enter. 

One of the ways I know is 'Submit code when server is connected'. Here, you write sas code that creates dataset which is needed in dynamic prompt.

Before EG show you the prompt, the required dataset would be ready and you will get the updated prompt values.

Go to Tool  --> Options --> SAS programs --> Submit code when server is connected

Click Edit and enter your code here.

I have also attached a snapshot with this reply.

The only problem with this approach is - this change would be applied to your SAS EG setting, so it would run for every EG project.