topic Re: ACCESSING DATASETS FROM DIFFERENT SESSION in Developers

ACCESSING DATASETS FROM DIFFERENT SESSION

dropez — Fri, 20 Aug 2010 13:10:50 GMT

Hi there.

I have a Stored Process (SP) that i want to add to a process flow. This SP is supposed to work with two datasets from the process flow. The problem is that this datasets are in WORK library and the work library that the SP uses is different from the one my process flow does. Also, i want the output from the SP to be placed in the same WORK library as the process flow. Is there a way to make SP use the same library of the process flow it is inserted in or to get the path to the process flow library from within the SP?
This SP is supposed to be used in many different process flows.

Regards in advance,
Pedro.

Re: ACCESSING DATASETS FROM DIFFERENT SESSION

SASKiwi — Wed, 25 Aug 2010 22:51:13 GMT

Have you considered using permanent SAS libraries to share SAS files between different Stored Processes?

Re: ACCESSING DATASETS FROM DIFFERENT SESSION

dropez — Wed, 01 Sep 2010 08:45:48 GMT

Unfourtunatly my hands are tied in that matter due to company policies. 😞

Re: ACCESSING DATASETS FROM DIFFERENT SESSION

Vince_SAS — Wed, 01 Sep 2010 12:34:58 GMT

If the machines running Enterprise Guide can access the location where the SAS code for the STP is stored, your best option may be to simply include the SAS code into the process flows when needed. You may have to make small modifications to the code to get it to behave properly in Enterprise Guide. If so, save a copy and include that into the process flows.

Vince DelGobbo
SAS R&D