topic Re: create a template program with an associated prompt in SAS Enterprise Guide

create a template program with an associated prompt

Phuels — Tue, 23 Oct 2018 16:30:58 GMT

Hello,

I currently use an abbreviation macro to insert my connection string when writing a new program. Recently, my company turned on validation, so I now need to enter a user id and password when creating the data connection.

I modified the abbreviation macro to include the necessary references:

proc sql outobs=;
connect to db2 (database='ACTDM5' user=&_CLIENTUSERID password=&User_Password);

The User_Password variable comes from a prompt I created using the Prompt Manager.

Is there a way to automatically associate the prompt when creating a new program? If so, how would I do this?

Thanks for your help.

-Frank

Re: create a template program with an associated prompt

tomrvincent — Wed, 24 Oct 2018 14:11:15 GMT

Can you explain what you mean by 'automatically associate'? Does that mean a new program would have access to it? Or something else?

Re: create a template program with an associated prompt

Phuels — Wed, 24 Oct 2018 14:16:36 GMT

I'd like to create a macro (or series of macros) that:

Create a new program with the default connection string
Create the User_PASSWORD prompt
Associate the User_PASSWORD prompt with the new program without having to go into the program properties > prompts > add... to manually associate.

Re: create a template program with an associated prompt

tomrvincent — Wed, 24 Oct 2018 15:17:49 GMT

What I do is have a egp template that has an autoexec program with the password prompt defined. That'll solve your problem.