Getting prompt manage to run

[Reeza]

First off, I have access to SAS 9.2 and 9.3, as well as EG 4.3 and 5.1, all running on individual Windows XP computers, ie no servers.

Here's what I'd like to do (and why).

There's a bunch of reports that I run regularly for other users that basically require setting macro parameters and running. For reasons beyond my control I can't send these reports to Microsoft Reporting Services which is what we use as our BI tool. 

I'd like to set it up so that if a user opens the appropriate project on EG and they can get prompted through the prompt manager and then the program will run using the macro variables set through the prompts.

I have the prompts set up and the program that generates the output that gets written to an excel file but I can't figure out how to get the prompt manager to run.

This seem simple enough when you have a server and can create a stored process, but if there's a way to do this with a single install I'd love to hear about it.

Thanks!

[ChrisHemedinger]

If you put the content that you want to run in a process flow named "Autoexec", EG will run it automatically when you open the project.

http://blogs.sas.com/content/sasdummy/2011/01/10/you-asked-for-it-the-autoexec-process-flow/

It that the behavior you're looking for?

Chris

[Reeza]

That's definitely helpful and I'll play with it, but I'm unsure of how to get the prompt manager to run to set macro variables still.

[ChrisHemedinger]

If you've got a SAS program node for "Set macro variables"...

1. Use View->Prompt Manager to get to the prompt manager window
2. Add an appropriate prompt for each macro variable in your "Set macro variables" program
3. While viewing the program in the editor, click on the Properties icon in the top right of the editor.
4. In the Properties window, select the Prompts tab.  Use the buttons to Add each prompt (associating each prompt with this program).
5. Move the "Set macro variables" program to a process flow named "Autoexec"

After you save the project, and then open it next time, you should see the prompts that you need pop up as the program gets ready to run.

Chris