Hi folks! I started working with SAS Enterprise Guide about 5 months ago and it's been a fun learning experience. I am trying to build a Stored Process to facilitate the life of my teammates when running queries. I know that Stored Processes seem to be mostly associated with web applications and whatnot, but that's not what I'm looking for. I just want to leverage their interfacing capabilities and use those hierarchical cool prompts. TOO LONG DIDN'T READ My stored process returns a dataset to my process flow, but that dataset is defined on a libname unknown to EG. I want suppress that output, force the stored process not to return it. I don't want the PROMPT_DATA dataset appearing in the Process Flow. The long version: The problem I'm facing is related to the Stored Process output. However, let me describe the overall approach I'm taking. The Stored Process Side My stored process "Query Prompt" runs first; the user enters various fields (mostly texts and dates) and hit Run. The stored process collects all those internal macro variables and builds a dataset called Prompt_Data. Still within the Stored Process, I copy this dataset from WORK to a permanent location (UserHome), like shown in the snippet below. /* Define home location for user */
libname UserHome base "/data/home/&sysuserid";
proc datasets nolist nodetails;
copy in=WORK out=UserHome memtype=data;
select Prompt_Data;
run;
libname UserHome clear;
dm 'log;clear;output;clear;'; The EG Side At this point, all user inputs are available as a table in the home folder, so I can access the results in my Enterprise Guide environment. I built a SAS program called "Importing Prompts into Macro Variables", which will basically move the table Prompt_Data from home to WORK (now the EG work though), and define a macro variable for each entry in that table. This is the portion of my process flow that relates to those two stages: My actual problem: as you can see above, my Stored Process is outputting the PROMPT_DATA table (its file name being USERHOME.PROMPT_DATA). The very first time I run the process, it all goes well. However, let's say that I save my project and restart EG. In this scenario, the PROMPT_DATA output icon will still show up in the process flow due to my previous run. Then, if I try to run the stored process again, I will get the following error: USERHOME is defined within the stored process so it makes sense that EG won't know what it is, what I don't understand is why it's being returned to EG to being with. I can make it work if I manually delete PROMPT_DATA from my Process Flow, but that would be impractical. What I need is for my Stored Process to NOT output that in the first place! I've been looking for a solution to this for a while now and decided to give it a try with the community. I know my post is way too long, but I would rather over than underexplaining this. Thank you in advance for any help, it will be much appreciated! Arthur
... View more
