topic Re: how to create & store a SAS prompt programmatically in Developers

how to create & store a SAS prompt programmatically

rajuganesh30 — Mon, 16 Aug 2021 12:24:21 GMT

Hello Everyone,

i want to embed a SAS prompt in a program that will be executed using SAS EG.

if the prompt is embedded in the program, anyone who will try to run the program can be able to give the prompt and use them(which is not defined in a project).

Can you please help me on this?

Kind Regards,

Raju G

Re: how to create & store a SAS prompt programmatically

jimbarbour — Mon, 16 Aug 2021 23:26:19 GMT

As far as I know, this is not possible with just a regular .sas program. Prompts are defined at the project level, not at the program level. You may be able to set this up as a stored process if your shop uses stored processes.

Jim

Re: how to create & store a SAS prompt programmatically

AllanBowe — Thu, 19 Aug 2021 17:31:20 GMT

Stored Processes are definitely the way to go - your code will be safer (harder for end users to modify) and you have complete flexibility through HTML / JavaScript / CSS how your prompts should look and behave.

To create Stored Processes using SAS code, you can leverage this macro: https://core.sasjs.io/mm__createstp_8sas.html

The equivalent for Viya is here: https://core.sasjs.io/mv__createjob_8sas.html

A much tidier, and more git-centric way to build services in this way would be to use the SASjs CLI. This will also help you to seperate the frontend from the backend. Some useful links:

Re: how to create & store a SAS prompt programmatically

Sajid01 — Wed, 29 Sep 2021 22:27:16 GMT

Hello @rajuganesh30
If you save the program as an EGP project yes. The code and prompt will be apart of the EGP