BookmarkSubscribeRSS Feed
JDMTX
Fluorite | Level 6
Is it possible via Management Console to define a stored process parameter for the program path and name when the web stored process utilizes a custom jsp input page? I would like to utilize a parameterized value to reduce maintenance overhead by taking the currently hardcoded values out of the jsp page and have them reside in Management Console.

Have included an example below that shows the jsp being used in the development environment and the programmer or server administrator has to remember to change this value when promoting a project to either test or production environments. Realize that this seems like a minor thing but it is easy to overlook when one is fighting dealines.

Many Thanks!!!!

---- Begin Example Code ---



5 REPLIES 5
Vince_SAS
Rhodochrosite | Level 12
If you define a text-based parameter named "PROGRAM2" you could write some Java code to use that parameter value in the custom JSP page, instead of a hard-coded value. But if I understand your question, I think you are moving the hard-coding from the JSP page to the stored process definition. Is that what you want?

Vince DelGobbo
SAS R&D
JDMTX
Fluorite | Level 6
You are correct. The content on my BI Server is order into three distinct folders: Development, Test and Production. It is very easy to promote content from one folder to another with the exception of web stored processes that utilize jsp pages to handle custom input parameters. In the current usage situation, it is necessary for us to modify the value that is hardcoded in the jsp to reflect the revised directory/program path. Ideally, we would like to define a stored process parameter in Management Console that is used to pass the correct path to the jsp. Is this feasible?
Vince_SAS
Rhodochrosite | Level 12
Which version of SAS are you running, SAS 9.1.3 or SAS 9.2?

Vince DelGobbo
SAS R&D
Vince_SAS
Rhodochrosite | Level 12
You may not have to add a parameter to the stored process, but instead, use the reserved "parameter" _PROGRAM. Here is some sample code that works in SAS 9.1.3 and SAS 9.2. Simply replace the hard-coded value for _PROGRAM:
[pre]
">
[/pre]

Give this a try to see if it meets your needs.

Vince DelGobbo
SAS R&D

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1232 views
  • 0 likes
  • 2 in conversation