05-24-2012 01:31 PM
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.
05-24-2012 01:39 PM
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.
It that the behavior you're looking for?
05-24-2012 02:31 PM
If you've got a SAS program node for "Set macro variables"...
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.