Traditional web-based reporting with SAS BI tools

Using prompt macro variables in a Stored Process

Reply
Occasional Contributor
Posts: 14

Using prompt macro variables in a Stored Process

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
SAS Employee
Posts: 238

Re: Using prompt macro variables in a Stored Process

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
Occasional Contributor
Posts: 14

Re: Using prompt macro variables in a Stored Process

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
Contributor
Posts: 40

Re: Using prompt macro variables in a Stored Process

Hi Jay,

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

-Nithin
Ask a Question
Discussion stats
  • 3 replies
  • 300 views
  • 0 likes
  • 3 in conversation