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

[vfarmak]

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

[ChrisHemedinger · Accepted solution]

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.

[vfarmak]

Thank you very much @ChrisHemedinger for your quick response! 

I will check your suggestion in DI.