how to create & store a SAS prompt programmatically

[rajuganesh30]

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

[jimbarbour]

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

[AllanBowe]

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:

• https://sasjs.io/resources/
• https://cli.sasjs.io

[Sajid01]

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