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
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.
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.
Thank you very much @ChrisHemedinger for your quick response!
I will check your suggestion in DI.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.