I need to use values returned by prompted filter for calculation of 4 data items/objects. I did use ::prompt(&<<Prompt_Variable_Name>>) in information map to do this & it works well when I execute in IMS. When I create report with this kind of objects, the prompts are duplicated (prompted several times) during run time. Is there any way to overcome this?
I was able to solve this by using SAS Stored process,defining macros and using them in Information Map. The issue now is stored process prompts for input and get executed for all reports using this Information Map.
Is there anyway to make stored process associated with Information Map to get executed only for few reports?
Message was edited by: Nithin
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.