ACCESSING DATASETS FROM DIFFERENT SESSION

[dropez]

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.

[SASKiwi]

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

[dropez]

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

[Vince_SAS]

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