topic Re: Using prompt macro variables in a Stored Process in SAS Web Report Studio

Using prompt macro variables in a Stored Process

Jay_OAG — Mon, 21 Mar 2011 19:22:27 GMT

I have a WRS report with prompts. I have also included a stored process in my report. Should the prompts (macro variables) be accessible within the stored process? I have registered the stored process and was able to select it with WRS. I know I am using the correct macro variable name, but can't get access to the prompt value.

Any help would be appreciated.

Using WRS 4.3, EG 4.3 and Information Map 4.2

Re: Using prompt macro variables in a Stored Process

AngelaHall — Tue, 22 Mar 2011 18:03:18 GMT

If you would like the stored process to utilize the prompt value, the prompt must be defined within the stored process definition rather than the web report.

There are samples on the support site that integrate stored processes with information maps when prompts are utilized. Here are some links:
http://support.sas.com/kb/37/028.html
http://support.sas.com/kb/40/758.html
http://support.sas.com/kb/36/193.html

~ Angela

Re: Using prompt macro variables in a Stored Process

Jay_OAG — Wed, 23 Mar 2011 17:48:50 GMT

Angela,
Thanks for the reply and the links. I have started looking them over and I think they will help me understand how to insert a prompt in my information map from a stored process.

I see that in the stored process code the macro variables are defined as global, will this allow me to access them from a stored process within my web report?

Thanks
Jay

Re: Using prompt macro variables in a Stored Process

Nithin — Wed, 23 Mar 2011 18:58:44 GMT

Hi Jay,

I have come across similar scenario. The global macros can be used in Information Maps as data items.

-Nithin