10-18-2011 05:11 PM
I have a stored process that performs commonly used business logic. I'd like this stored process to output a data set, not a report. Ideally if it were run in Enterprise Guide it would show a dataset coming out of it that could be used in subsequent steps. Is there any way to do this?
11-15-2011 06:32 AM
I have an example of how to do this kind of stored process in my Biz Intel Blog. Here's the post:
Hope this helps,
11-07-2012 05:25 AM
Apparently this seems to work only if the target library is pre-assigned(sashelp etc.). Is there any way that we can make this work with the Work Library?
11-13-2012 01:07 AM
I am trying to create an output from the stored process, I have noticed that the output dataset appears as a step in the Enterprise guide project only if the it is created into a preassigned library.
However my dataset has more than one million rows, and I do not want that to be be created in a permanent library. Is there a way to make the datset appear as a step in the project without writing it to a permanent library.
11-09-2012 08:33 AM
Writing to the work-library of another sas session is not possible - unless the server configuration lacks a proper configuration of write-access to the location in which then directories for the work-libraries are created.
11-12-2012 12:53 PM
Just to have it in the air within this discussion.
You can also use the Stored Process sessions (http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sesssamp.html). A macro variable (_sessionid) you need to pass through your pages (as a GET parameter). All pages which have the same _sessionid can share the libref called SAVE, and all datasets created in it. This library is temporary, as session expires after (by default) 15 minutes.
If any of the SAS experts are there to correct me, please do.