topic Re: SAS Stored Process - Pre process code in SAS Enterprise Guide

SAS Stored Process - Pre process code

Mushy — Sat, 18 Jan 2025 00:52:21 GMT

Hello,

In SAS Stored process the prompts pop up first and then the sas code executes based on the filter selection.

Is there a way where I could pre-execute the code in SAS Stored process .

I need to ensure that the promts get the latest updated information which will be provided by the pre code I am referring to.

Thanks

Mushy

Re: SAS Stored Process - Pre process code

ChrisNZ — Sat, 18 Jan 2025 02:10:28 GMT

You need a dynamic prompt.

Lots of material about dynamic prompts such as

https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fwww.lexjansen.com%2Fphuse%2F2011%2Fts%2FTS02_ppt.ppt

http://support.sas.com/kb/62/051.html

or these about SAS Enterprise Guide prompts (the interface very similar to the Stored Process prompts)

Getting Started with SAS® Prompts

Be Prompt! Do it Now! Creating and Using Prompts in SAS Enterprise Guide

Re: SAS Stored Process - Pre process code

Mushy — Sun, 19 Jan 2025 09:21:28 GMT

Hi Chris,

Thanks for responding.

In fact my question is , when the dynamic promts use a dataset and we want to update the dataset in the same stored process,

is it possible to first update the dataset in the stored process so that when we open the stored process we get the updated information in the dynamic promt.

Thanks,

Mushy

Re: SAS Stored Process - Pre process code

Kurt_Bremser — Sun, 19 Jan 2025 13:00:38 GMT

You would need two stored processes, one that updates the dataset and one that uses it.

Re: SAS Stored Process - Pre process code

JuanS_OCS — Sun, 19 Jan 2025 16:53:51 GMT

Indeed, either a second stored process or a SAS/Connect execution. Anyways, a separate SAS process.

Re: SAS Stored Process - Pre process code

AlanC — Sun, 19 Jan 2025 17:48:21 GMT

Take control of the whole thing with a custom task. If you want power in SAS EG, custom tasks are your best bet. They aren't too hard to do. Focus on a simple Hello World to get started and work up from there.

See these:

https://support.sas.com/documentation/onlinedoc/guide/customtasks/

https://blogs.sas.com/content/sasdummy/2015/06/11/creating-custom-tasks-for-sas-enterprise-guide-expert/

Re: SAS Stored Process - Pre process code

Mushy — Sun, 19 Jan 2025 21:50:16 GMT

Hello Kurt,

Could you help me on how I could call a stored process from another stored process via EG?

I need ro first create the dataset and need to use that in the promp of another stored process.

Thanks,

Mushy

Re: SAS Stored Process - Pre process code

Mushy — Sun, 19 Jan 2025 21:50:49 GMT

@Kurt_Bremser

Hello Kurt,

Could you help me on how I could call a stored process from another stored process via EG?

I need ro first create the dataset and need to use that in the promp of another stored process.

Thanks,

Mushy

Re: SAS Stored Process - Pre process code

Kurt_Bremser — Mon, 20 Jan 2025 11:06:08 GMT

You should be able to chain STP's as part of an Enterprise Guide project, IIRC.

But you may be entering the realm of building web applications with STP's here. You have a STP creating a HTML form, from which you then call other STP's (or the same STP to update the form).

Re: SAS Stored Process - Pre process code

Quentin — Mon, 20 Jan 2025 13:51:29 GMT

Not sure this will work, but if the pre-process code could be a single DATA step, then it might be possible to use a DATA step VIEW (https://documentation.sas.com/doc/en/lrcon/9.4/n07vq6hmss6f67n1vhnnn5cw0chh.htm) to calculate the values. And then register that view in metadata and use it as the source for your dynamic prompt. Views are dynamic, the code executes when the view is referenced. I've never tried using a view as a source for a stored process prompt, but it might work. Assuming it's possible to register a view as metadata object.

Re: SAS Stored Process - Pre process code

macrobo — Wed, 27 Aug 2025 14:54:29 GMT

Hello Mushy,

perhaps this Blog Entry can help you: https://blogs.sas.com/content/sgf/2017/07/28/controlling-stored-process-execution-through-request-initialization-code-injection/

It describes how to request a code injection during the STP initialisation.

Regards,

Robert