Accessing the Stored Process PROMPT variables in a PROCESS Flow

[THALLA_REDDY]

Hi Team,

I have created a stored process in my SAS Enterprise Guide 8.3 and saved it under Shared Data Folder. I have created some prompts in the Stored process for getting some inputs when running the PROJECT. Unfortunately the Stored Process is taking the Inputs from the programmer but those macro variables are not getting resolved in the other objects like a program. Is that something I am missing with the stored process creation to get these macro variables created by Stored process to be used in entire PROJECT Process Flow ?

thanks in advance,

Thalla

[Kurt_Bremser · Accepted solution]

A stored process is executed in a completely different context than your other project nodes. A stored process is executed in a stored process server instance, which runs on a generic userid (sassrv), and the environment there is cleaned up immediately after the STP has finished. Your Enterprise guide can only access macro variables defined in your workspace server, which runs on your userid and is persistent for the EG session (unless you terminate it yourself).

You can attach a user prompt to a code node, set macro variables from the prompt values in that code, and use those macro variables in conditions for the next nodes.