Using prompt macro variables in a Stored Process

[Jay_OAG]

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

[AngelaHall]

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

[Jay_OAG]

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

[Nithin]

Hi Jay,

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

-Nithin