topic Re: Prompt using generated dataset in the a project in SAS Enterprise Guide

Prompt using generated dataset in the a project

ridiculas — Wed, 23 Dec 2015 03:17:28 GMT

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?

Re: Prompt using generated dataset in the a project

Manu_SAS — Wed, 23 Dec 2015 05:49:30 GMT

Go to -> Prompt Manager

Click Edit the prompt

Navigate to General tab -> Options

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

-Manohar

Re: Prompt using generated dataset in the a project

ridiculas — Wed, 23 Dec 2015 06:05:36 GMT

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.

Re: Prompt using generated dataset in the a project

RahulG — Mon, 28 Dec 2015 04:44:26 GMT

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.