In SAS 9.2 you will have a connection to the metadata server under the correct identity (whoever you logged in as). Thus it seems your code will run properly under this release.
Do you have plans to migrate to 9.2?
The SAS Stored Process Web Application is written in Java, and the logic to create the index and property pages is self-contained. If you can program in Java, you can create a JSP page to replace the logic you are now doing in SAS.
One other option is to try running your code on a workspace server. I believe you will have a connection to the metadata server under the correct identity.
When you register the stored process, select "Transient package" for the output type. Then you will have to make some modifications to your code. I assumed that your stored process writes HTML to _WEBOUT. Here is some test code based on that assumption.
Vince DelGobbo
SAS R&D
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.