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!
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
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.
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.
Chris
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.