topic Re: Execute (Call) a stored process in SAS DI in User Written Code in SAS Enterprise Guide

Execute (Call) a stored process in SAS DI in User Written Code

vfarmak — Tue, 02 Feb 2021 22:45:16 GMT

Greetings Everyone!

I have the following question: I have created a stored process in Enterprise Guide and I have used two prompts (start and end date).

I have published the stored process, executed successfully.

I was wondering if I could call or execute the stored process in a DI job, since I have the parameters and I want to add the job in a loop transformation.

The stored process simply writes data to a sas dataset.

Best Regards,

Vassileios

Re: Execute (Call) a stored process in SAS DI in User Written Code

ChrisHemedinger — Tue, 02 Feb 2021 23:12:17 GMT

One option might be to use PROC STP in a code transform. There's an INPUTPARAM statement that allows you to pass in parameters, and various OUTPUT* statements for data, files, and values.

Re: Execute (Call) a stored process in SAS DI in User Written Code

vfarmak — Wed, 03 Feb 2021 15:22:45 GMT

Thank you very much @ChrisHemedinger for your quick response!

I will check your suggestion in DI.