BookmarkSubscribeRSS Feed
TimCampbell
Quartz | Level 8

Hi Everyone,

I have a stored process that multiple different users will need to run from within an enterprise guide project and am having some problems with settings on the prompts.

When one user has run the stored process it retains the values selected in the prompts so that when the next user runs the process the prompts are filled in with the last used values.

This is causing a problem as one of the prompts is for a password which not all the users will have and I would rather it not be filled in by default.

I know that from enterprise guide I can choose to reset the prompts on the stored process but is there a way to do this automatically when the project opens for example?

Thanks in advance,

Tim

2 REPLIES 2
Reggie_SAS
Calcite | Level 5

Tim

I am haveing the same issue.  Have you gotten a response to your question.

Thanks,

Reggie

TimCampbell
Quartz | Level 8

Not really,

I raised it as a track with SAS and they mostly came up with suggestions around trying the latest hot fixes and didn't seem to understand the problem however I did manage to work out some things...

Because every enterprise guide project is basically a zip file i changed the extension of my project to .zip from .egp and had a poke around.

looking at some of the contents I discovered that the prompt values are (as i suspected) being stored within the project itself and not in the metadata object. This is backed up by the fact that if I add the stored process to a new project or run it through the web server the prompts are not pre-filled for me.
The other thing I spotted was that if I run the stored process and then close the project without saving, when I re-open the project the prompts are set back to the previous time I ran them.

Whilst this has not helped me to find a way to automatically reset the prompts it does mean that I have half a workaround as follows;

  • Reset the prompts myself and save the project
  • Make the project read only (properties on the file in windows)
  • Then release the project to the users

This has drawbacks because the users get the horrible 'this project is read only' message every time they open it and they have to remember to export the log files whenever they hit errors, however it does mean that the stored processes are always blank and they cannot accidentally delete any of the code I have written for them.

If you ever find a way to actually get the prompts to reset I am still very interested.

Tim

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1206 views
  • 0 likes
  • 2 in conversation