01-29-2017 11:32 PM
I wish to have cascading prompts within Enterprise Guide so I created a stored process (named Select Report Institute) and added it as a task to my EG project.
The prompts cascade as required and the log shows that the macro variables have been assigned correctly.
However, the macro variables are not assigned when I attempt to use them from a separate program (e,g, Initialise Values) within the EG project.
Stored Process prompts - I have tried accessing both the input prompts and output parameters within Initialise Values
Stored Process SAS code
%global in_selected_institutes in_this_university selected_institutes this_university; *ProcessBody; %stpbegin; %let selected_institutes = &in_selected_institutes; %let this_university = &in_this_university; %put &selected_institutes; %put &in_selected_institutes; %stpend;
Output form Stored Process Code:
44 %let selected_institutes = &in_selected_institutes;
45 %let this_university = &in_this_university;
47 %put &selected_institutes;
48 %put &in_selected_institutes;
Output from Initialise Values program
WARNING: Apparent symbolic reference SELECTED_INSTITUTES not resolved. 26 27 %put &selected_institutes; &selected_institutes 28 %put &in_selected_institutes; WARNING: Apparent symbolic reference IN_SELECTED_INSTITUTES not resolved. &in_selected_institutes
Any advice on how to use cascading prompts to define macro variables within SAS EG will be much appreciated.
12-01-2017 05:37 AM
I think you should check the box "Use prompt value throughout project" in the general prompt ialog. That way the macro variable does not get deleted after the process is run.