topic Re: Stored process that outputs a data set? in Developers

Stored process that outputs a data set?

FrankE — Tue, 18 Oct 2011 21:11:17 GMT

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?

Stored process that outputs a data set?

TriciaA — Tue, 15 Nov 2011 11:32:45 GMT

Frank

I have an example of how to do this kind of stored process in my Biz Intel Blog. Here's the post:

http://www.bi-notes.com/2011/11/sas-stored-process-outputs-data-without-a-report/

Hope this helps,

Tricia

Re: Stored process that outputs a data set?

RajaSa — Wed, 07 Nov 2012 10:25:55 GMT

Tricia,

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?

Re: Stored process that outputs a data set?

SASBIROX — Wed, 07 Nov 2012 12:30:57 GMT

I'm not sure what you asking - is it about using the Data Library prompt or about not outputting a dataset?

Re: Stored process that outputs a data set?

andreas_lds — Fri, 09 Nov 2012 13:33:40 GMT

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.

Re: Stored process that outputs a data set?

NN — Mon, 12 Nov 2012 17:53:46 GMT

Hi i dont think it is necessary to have preassigned libraries. you can always define a libref in your code with a libname statement and use the same.

However it is always good to have preassigned libraries as shown by Tricia so that user restrictions/security are honoured by the stored process.

Re: Stored process that outputs a data set?

RajaSa — Tue, 13 Nov 2012 06:07:24 GMT

Tricia,

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.

Thanks

Re: Stored process that outputs a data set?

SASBIROX — Tue, 04 Dec 2012 15:03:05 GMT

Not that I know of.

Re: Stored process that outputs a data set?

trt — Tue, 22 Aug 2017 13:52:44 GMT

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.