topic Getting prompt manage to run in SAS Enterprise Guide

Getting prompt manage to run

Reeza — Thu, 24 May 2012 17:31:39 GMT

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!

Re: Getting prompt manage to run

ChrisHemedinger — Thu, 24 May 2012 17:39:34 GMT

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

Re: Getting prompt manage to run

Reeza — Thu, 24 May 2012 17:59:45 GMT

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.

Re: Getting prompt manage to run

ChrisHemedinger — Thu, 24 May 2012 18:31:43 GMT

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

Use View->Prompt Manager to get to the prompt manager window
Add an appropriate prompt for each macro variable in your "Set macro variables" program
While viewing the program in the editor, click on the Properties icon in the top right of the editor.
In the Properties window, select the Prompts tab. Use the buttons to Add each prompt (associating each prompt with this program).
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